Search results for query: *

Can we find out why heap dumps are happening by using Tivoli or any other way? Thank you.

Hi, Does any body has idea about which tool is best for j2ee development and why? Thank you .

hi , how can we save sql results to excell file with column headings. I know TOAD can do this. but I need at sql plus. ex: SET PAGESIZE 10000; SET LINESIZE 200; spool h1.txt --spool h1.xls COLUMN empno heading 'EMPLOYEENUMBER' format A15; COLUMN decode(ename, 'SMITH','SMITH',NULL)heading...

Hello, Does any body know how to create a Message driven bean(EJB) in myeclipse and deploy on jboss application server(queue).( step by step tutorial or atleast simple helloworld program) I thank you so much for your help.

Hi, I need help on hibernate. how does hibernate work with WSAD5.1 and oracle 9i. Is it possible add hibernate to a struts project in wsad. (I know this way: With Myeclipse and oracle 9i, we can do hibernate). Please guide me. Thanks in advance.

Hi, I canot do like that since my table has more than 12,000 rows and each and every row has diff length strings. If we can cut at the delimeter(/), it would be better. Thanks.

hi, Is there any function to deconcatinate a string. My table has a COLUMN VALUE: SCOTT/TIGER/HEAD/TAIL. I need to extract the string and put into 4 seperate columns. how do we do this. we can concatinate strings(|| or concat function), I donot know the other way. table1 ------ column name...

Hi, How do I import data from a text file to multiple oracle tables. I have table structures. My file has 50 columns and 15,000 records. These data should be loaded into 10 tables. I know how to import into one table, but need to import into multiple tables. some columns go to one table some...

The weird thing is with my original query in work place, I need to add couple of other clauses also. I tried with different combinations putting clauses in inner and outer queries. One of the trial was worked . Thanks . Now, your query is working fine with original table. Still, I did not get...

yes, I forgot to type distinct when I was replying to you. but in my original query I did it. I got it right. work is done. The query which you gave yesterday is working fine for my test table(emp) which I created at home(5 records). but, at work it is giving bad data with the same query. My...

Yes, YOUR query is working good for my emp test table. but,It is giving wrong data with original table(AT MY WORK PLACE). I donot know why. But I did it with selfjoin. then it worked. select A.ename,A.hiredate,A.empno,A.salary from emp A, emp B where A.ename = B.ename and A.hiredate =...

Hi, how to select the duplicate records(entire row is not duplicate, only couple of columns only duplicated) from a table. for ex: emp -------- empno ename hiredate(varchar2) sal 1 first 01-01-1980 5000 2 first 01-01-1980...

It is working since I forgot to put semicolon at the end of the line for spool command in the script file. Thanks Mufasa.

If I execute as a script file, file is creating but empty. SQL>@test.sql Thanks.

Hi, I have a question. I donot want to see the sqlquery in my report. for that I gave set echo off. but still it is giving my sql query with results. how to set that. ex: set echo off; set verify off; set feedback off; spool test.txt select * from emp; spool off; It is showing sql query in my...

Hi, This message is just for your info. I did not reinstall it. First, I did not know how to see whether the utilities are added or not. I used custom and checked. The utilities were not added properly. Added utilities. Now, sqlldr is working fine. Thanks for your help.Closing this thread.

Hi, I only installed client version from networkdrive. I have not remember whether it asked about adding utilities. I remember I clicked all. But, may be, I have not. As you said, I need to reinstall it again the client. Do you have anyidea about how to add utilities without the...

Hi, I understand what you said. But, in my case there is no sqlldr executable file in my system. where should I get a copy of the sqlldr executable for the same operating system and same version of Oracle. Thanks.

Hi, Yes, each time I gave the above command or C:\sqlldr, it is giving the same error. It has 82 files in oracle_home/bin path. Sqlplus is also there. My oracle account is also working at sqlplus. I donot know how sqlldr is missed/not loaded. Is this the problem because of the client...

Hi Mufasa, I searched it. but it is not there. Thanks.