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, 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...

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...

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...

hello, I am working on oracle 9.2.0.5.0 client version for windows xp.I have text data and try to load it into the oracle database.I created a control file. when I am trying to give the sqlldr at dos prompt, C:\sqlldr username/password@connectstring control=filename.ctl it is giving the...

Hi, I am having a problem with oracle designer access. I installed oracle9i designer(9ids) on windows xp. When I am logging into it , it is giving the error message saying that "Invalid user(not a valid repository user)".But, I am able to access to sqlplus,forms and reports. I did not...

Hi, What is the difference between webserver and application server. I feel both act like webserver. Thanks in advance.

Hi, I am planning to learn WSAD. I know java and jdbc(manually). which book is good for learing "websphere studio application developer". What are the things that I need to download and where to download. Please guide me. Thanks.

Hi, I got the error "unique constraint violation" when I am updating a table. The table has a unique key with muti columns. I am trying to the update a unique key column. If I change this the uniqueness will be gone. None of the columns are primary key. How Can I update? I searched in the...

Hi , I have a problem.I have a mastertable and child table.I need to update a column in mastertable which has a foreign key in child table. When I am updating it is giving error 'unique constraint violated'. How to update the child table column automatically when I update master table column...

Hello, How do we convert data from c-base conetic to oracle. I understood like this. c-base data is stored files. By using sql * loader( flat file stored as .csc file. call the .csc file from a control file. then use sqlldr username/password@connectstring .ctrl filename ). That way we can...

Hi, What is the purpus of using ref-cursors than using regular cursors in pl/sql.What is the diff between them. At what circumstances we use them. Thanks.

Hi, Could any body tell me what is business objects? when I search in the google, that link went to business objects site and showing about crystal reports. I heard business objects is come under dataware housing reporting tool. Is both are different. when anybody talks about business objects, I...

hi, I installed oracle9ids windows version. When I was running my oracle form, I am not able to see the form because some web related problems.but my form is client/server. I donot want to run in web mode. Cannot I run my form(not webform) in client/server mode? Is web is default mode? Iam...

Hello, I am a learner. do we use commit/rollback in pl/sql programs. If yes , how often we use these for security point of view. and one more thing I want to know. can we return more than one value in functions. as per my knowledge we can't since a function can return only one value. Please...