Search results for query: *

Hi Terry, Does SQL Loader treat '' as NULL? If so then this is very different from SQL statement. I will give your suggestion a try. Thanks for your feedback. CHAO

Removing the space is simply not possible due to the size of the file and the fact that blank lines appears randomly in the file. I found the solution and would like to share it with you all. Just increase the maximum # of records SQL Loader can discard in the control file. Thanks, CHAO

Hi, I am importing some data into a table from a delimited text file. Unforturnately the text file contains NULL records: ID|First Name|Last Name 1|John|Smith 2|Mary|White 3|Ken|Gray My question is how can I signal to SQL Loader to ignore any null record. Thanks for your...

Is there an approach to traverse the columns of a ref cursor to extract the column information (i.e. column name and value) in PL/SQL? I can do this with Visual Basic's recordset object. Here's VB code of what I would like to do in PL/SQL: i.e. set rs = cn.execute("select * from...

Thanks Kusch. It worked.

I would like to import data from a text file into a temp table in SQL Server. However, the temp table has an identity column. How can I indicate that it should automatically generate an identity value for each imported record?

Sorry, I mean to post the quest not to reply.

I would like to import data from a text file into a temp table in SQL Server. However, the temp table has an identity column. How can I indicate that it should automatically generate an identity value for each imported record?

I have a dblink from Oracle to SQL Server. I need to be able to call a SQL Server stored procedure and pass it some parameters. Does anybody have any clue how to do this?

I would like to update/insert data from Oracle to SQL Server using a Oracle stored procedure. The procedure contains an insert statement that inserts data into a SQL Server table. I run the Insert statement standalone and was able to insert the entry onto SQL Server. However, using Oracle stored...

Hi, Here is the general scope of my issue. I need to execute an arbitrary stored procedure/function. Only the name of the procedure is available and it is the result of a lookup from a table. At this point, I do not know the arguments (argument name, in or out or the data type) the arbitrary...

I think your query cannot be accomplished easily with one query. Have you try writing a stored procedure?

Here is a VB sampel: dim cn as adodb.connection dim strSQL as string ... set cn = new adodb.connection cn.open database, user, password ... cn.begintrans strSQL = "insert into XXX(a, b, c) values (1, 'test', null)" cn.execute strSQL ... cn.CommitTrans

First of all, there are 2 main categories of errors in Oracle. They are system errors and user generated error. System errors are errors generated by the system, such as no_data_found. User generated errors are raised by an application when an error condition is met. This type of error is an...

Sorry, the above solution is for Oracle. I thought I was in Oracle forum.

Try this, select * from Category start with cat_id in ( select distinct cat_id from category where upper(name) like 'PEN%') connect by prior pcat_id = cat_id; Hope it is not too late.

Hi, I would like to find out if there is another way to optimize my query or other ways I can make it run faster. The query attempts to determine the nodes in the List where the node return is the highest level in its branch within the List. The query takes around 5 minutes. Your feedback is...

... dim intFileHandle as integer dim strFileName as string dim strInRec(0) as string ... strFileName = "c:\temp\InFile.txt" ... open strFileName For Input AS #intFileHandle While not EOF(intFileHandle) line input #intFileHandle, strInRec(ubound(strInRec)) redim...

Thanks sem. I did not understand the usage of the restrict_reference very well. With your comment in mind, I put all the functions and constants into one stand alone function unit and it worked great. After that I started to replacing the calls to the local function with calls to other stand...

What I am trying to do is have a front end call a stored procedure that will return a result set (via SELECT ...). In this stored procedure, the select statement will called a function (say GetData) to query the related data depending on the transaction type. Everything compile fine until I...