Savepoints in 9i

Title: Savepoints in 9i Hi Friends , In my application , we are having a program written in C which executes the sql command that is passed as an argument to it. When I call the procedure to Create a savepoint SP1 and then to rollback to the named savepoint , it throws an oracle error

ORA 6501

Hi Friends , I have a procedure which inserts around 6 million records dynamically from one table to another . During the insertion process the oracle throwed ora 6501 program error . There is enough table space available and enough rollback segments are also available. Can you please

RE: Week - Date function!

Hi Begun , I am very eager to know the reason why 27th Nov is taken as the base for each year. Can you please explain me the reasons. This query is really helpful for me . Thanks Regards, Shankar -Original Message- Sent: Saturday, March 29, 2003 11:39 AM To: Multiple

RE: Week - Date function!

I have found out the reasons. Thanks for your information. -Original Message- Sent: Monday, March 31, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Hi Begun , I am very eager to know the reason why 27th Nov is taken as the base for each year. Can you please explain me

RE: TRANSLATE

Hi, select translate(string,',''','XYZ') from Dual Only for single quote you need the escape character (another single quote).The above query changes the comma character to X , Double quote character to Y and single quote character to Z. Regards, Shankar This e-mail and any files

SQL Query

Hi Friends, I just need a help in a sql . I am having rows in a table as follows Field1(ID)Field2(NAME) -- 1 RAM 1 SHAM 1 PAT 2 MAN 2 JOHN Now i want the output to be as follows

Oracle Error - 1467

Hi Friends, I am having a sql statement where select field1,field2.. field15, sum(fieldx1), sum(fieldx2).. sum(fieldx200) from t1 group by field1,field2.. field15; when i execute this statement , i am getting error - 1467 which says sort key too long Cause Mentioned in the document :

Internal error code problem

Hi friends, I am running a package in my application and i got the following error message . ORA-00600: internal error code, arguments: [kcbgtcr_4], [], [], [], [], [], [], [] Can anyone throw up some points on this , basically what would have went wrong. Thanks in advance Shankar

RE: Function

Hi Divya, you have to use dynamicsql for calling the function . First step select the function name into a variable say ls_fn_name from the table func .Then create a dynamic statement 'Select' || ls_fn_name || ' from dual ' and cpature the return value into another variable . If u

RE: Query

Hi, If u are having a index on xmas_id then change the query as follows delete from olsr10.op_orders where (xmas_id = 193 or xmas_id = 207 or xmas_id = 245 or xmas_id = 300) and order_total = 0 and status_timestamp to_date ('01-aug-2001','dd-mon-') When u use in in where condition

RE: How to find the current instance name?

select * from global_name; -Original Message- Sent: Thursday, September 20, 2001 4:25 PM To: Multiple recipients of list ORACLE-L List, How to find the current instance name for the session?. From svrmgrl, i can using SELECT name FROM v$database. What is the equivalant from the