Search results for query: *

Hi, I have a function in MS-SQL, but have difficulity to convert it into Oracle, can someone help please? Here is the Function: --===== Create a function to concatenate orders by customer CREATE FUNCTION dbo.ConcatOrderNum (@pCustomerID AS INT) RETURNS VARCHAR(8000) AS BEGIN DECLARE...

Hi, Does anybody have experience using views inside a function in Oracle? Technically it should be fine. but I had problem with the following simple view: CREATE OR REPLACE FUNCTION MetaData(Id NUMBER) RETURN VARCHAR2 AS infotypes VARCHAR2(10000); infovalue VARCHAR2(255); CURSOR...

Hi, For example I have a simple table called Session like this: PersonID SessionNum ========== ============= 101 105 101 21 102 33 102 46 102 57 103 69 . . . . The SessionNum are unique, but in a random...

Hi, I try to establish a connection from a client to a LDAP server. I use a normal user as the binding user, but I get this error message "Failed to bind the LDAP server: Invalid Credentials". Are there any user right requirement for the binding user? Thanks, Henry

Hi, I have a JVM installed on a Linux box, can someone tell, how to find if this is a 32 or 64 bits of JVM? How to check it? Where can I find/and download 64 bits 1.3.1 JRE? Thanks, Henry

Hi, I try to install an application on a new Linux Box, but end up with this errors, and installation can't complete. " Launching installer... /tmp/install.dir.9819/Linux/resource/jre/bin/../bin/realpath: line 22: /tmp/install.dir.9819/Linux/r esource/jre/bin/../bin/ia64/realpath: No such file...

Hi, Here is a question. When I create a new user in Oracle database, I normally assign "SYSAUX" as its default Tablespace, and "TEMP" as its Temporary Tablespace. Is it a good practice? Any performance effect? are there any ground rules when assigning Tablespaces to new users? Thanks, Henry

Hi, I have a table in Oracle 8i, with a clob column. Now I want to execute a query like the following: REPLACE(<clob_column>, CHR(13)||CHR(11), '<BR>') But I receive an error complain with "Inconsistent datatype". Can anybody suggest a workaround for this please? We need this very urgent...

Hi, Is it possible to slice the result set by row number in SQL 7.0 ? I know in Oracle, there is a keyword called &quot;ROWNUM&quot; which can easily slice the result by specifying a fixed number of returned rows. How can we do this in SQL 7.0? Thanks Henry

Hello everyone, I have a table like this: CREATE TABLE Items ( childCode VARCHAR(25) NOT NULL UNIQUE, parentCode VARCHAR(25) NULL, itemName VARCHAR(25) NOT NULL, ID INT NOT NULL PRIMARY KEY, ) Items =============================== parentCode childCode itemName...

Hello everyone, I have a table like this: CREATE TABLE Items ( childCode VARCHAR(25) NOT NULL UNIQUE, parentCode VARCHAR(25) NULL, itemName VARCHAR(25) NOT NULL, ID INT NOT NULL PRIMARY KEY, ) Items =============================== parentCode childCode itemName...

Hello everyone, I have a table like this: CREATE TABLE Items ( childCode VARCHAR(25) NOT NULL UNIQUE, parentCode VARCHAR(25) NULL, itemName VARCHAR(25) NOT NULL, ID INT NOT NULL PRIMARY KEY, ) Items ========================================== parentCode childCode...

Hello Everybody, I have a funny experience. In a case I want to replace all double quotes in my data content by single quotes. I use function like this: Function StrQuoteReplace(strValue) // Replace any double quote in strValue with one single quote. // The second argument to Replace...

Hello everyone, I have some problem in loading an xmldom object to another node of an xmldom object. I can load the html content into an xmldom object, such as HTMLDOM. But I am not sure how to append the HTMLDOM to one specific node of my original xmldom object. My code is something like the...

Hello everybody, I use the same examples RGeo posted at 27 Aug. I encounter exactly the same problem with her. Suggestions and tips are most welcome at this stage. This xml generated from ASP with values (in html format) from a database (SQL server) as follows: <?xml...