Recent content by mesuj

I was trying to port an existing ORACLE to another setup. In this I faced this problem. In the new setup I was not able to see the other tables where as in the old I could see.If I can see the objects in other tablespace then why am not able to see the same in the new environment.I checked the...

thanks jee.that was a very useful info.

The in paramenters alone can be different. You cannot have overloaded methods with various return type alone. Method overload basically talks about only the in parameters to the method. mesuj

All When i say select * from view , will the select query used to frame view be executed.Then why view is faster than the actual qry?. Can a view be created on a transaction table?. Is there any concept called rebuilding the view?. Thanks mesuj

All Have some basic clarification. I have ORACLE installed and i Connect with one SID say test.I have 4 Table space and 4 users. I login as user1 and get the table space1 by default. But if i say Select from a table which is available in tablespace2 i'm able to get the results.I don't even...

you should write a control file(.ctl file). This file would be say LoadScript.ctl as LOAD DATA INFILE DatFileName INTO TABLE TableName FIELDS TERMINATED BY delimiter (line_data) Then type the following sqlldr userid=userid/password control=LoadScript.ctl This would read from the data file and...

I think it takes the whole String and tries to convert it in the given format. Did you check the parsing of the String?.May be thats where you need to revisit.

It would be WHEN DUP_VAL_ON_INDEX ----do something

to use your own date format use insert into datetest values ( to_date('1999-12-12','YYYY-MM-DD') )

are you using unix. If so run the procedure thro shellscript. and at the end it use the unix mv command.I'm using it that way.

But you forgot the most important between clause. Thats where i'm struck.Thanks for the pains

try this Create OR REPLACE Package OnDemand_CC As End OnDemand_CC; / CREATE OR REPLACE PACKAGE BODY OnDemand_CC AS End OnDemand_CC; That / is a must if you are creating the package & body together.

You have to use GET_LINE to read from the file right. That will automatically exit from the loop at the end of the file. i.e IF ( FILE_HANDLE.IS_OPEN(filename)) THEN LOOP GET_LINE(FILE_HANDLE , variable_x); --> This reads line by line --> Other operations END LOOP...

But this solutions works only in 8.1 version and not in 8.0.

thanks...i'll check that