Search results for query: *

Hi, I have a script that accepts a variable and then some queries with this variable. eg: set pages 0 set feedback off accept new prompt seqid Select count(*) from T_LE_PROFILE Where le_id >= &new and rownum < 5; Select count(*) from T_LE_ADDR Where le_id >= &new and rownum < 5; Now, when...

Hi, I would like to know if its possible to imp data (exported from table t1 ,say) to table t2 having the same structure? One way is to import t1 and rename to t2. But, it would be great if we can import directly to t2.

Hi, sorry guys. this question is totally off the forum. I am tempted to post it here as I am assured of getting a reply. Here's my query: Does anyone know about a utility which can output the checksum of a file (I mean add up all the characters/spaces/numbers ..in the file ..using some...

Is there an easy way to restrict user from entering anything besides letters and numbers into a varcharfield on the Oracle Form?

Is there any way to import a csv file into the Oracle 9i database without DBA studio or SQL Loader ?

Hi, When I create a directory in sqlplus using create directory dir1 as 'd:\' ..where does it get created ?

Hi, Has anyone worked with Version Control in DS 6.x. If so, I would like to get some tips to work with it. I have created a folder for version in the existing project where the actual jobs are. Therefore, able to see all the versions from the Designer when working with the jobs. I would want...

Whenever data(in a column) is getting truncated, the rows are not passed on to the target..Has anyone come across this?

Is Datastage version6 lower version compatible? What I mean is If I design a job in ver 6, can I use it in 4 ? Are there any limitations? Thanks for your help