Search results for query: *

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

Hi I just want to know if i can send a mail from backend on an event. say from a trigger. thanks

why do you want to create a trigger that is disabled. check it like a normal SP for business logic. then when you close down for maintenance you can create and disable it. seriuous i don't understand the need for a disabled trigger

karluk - that query did work. Thanks for u r help. Steve - Did you try executing the SELECT * FROM ( SELECT x, rownum record_num FROM table1 ORDER BY x ) WHERE record_num BETWEEN 2 AND 4; query. This doesn't work. The results which you have is...

Hi My requirement is i need to fetch rows between 2 given rownum like say 10 to 20 , 30 to 40 etc. The query which i used is select * from( select x , rownum record_num from table1 )result_table where record_num between 10 and 20 The problem now is i want to sort by x and then pick records...

Hi I have a data file which has some multi lingual charachter. when read using UTL_FILE.GET_LINE the character is replaced by a ? and also the next charater is lost in the String. Can I use a NVARCHAR2 in the GET_LINE procedure. How do i read the special char . My database charaterset is UTF8...