orajit
Last Activity: Jun 12 '09, 06:06 AM
Joined: Nov 12 '07
Location:
-
any updates on this ... still have no idea? Please help me out ...thanks -
Hi madankarmukta,
We canot call truncate statement directly in Plsql code. So I used dynamic sql for calling truncate statement ..thanks...Leave a comment:
-
Please any updates on that ..thanksLeave a comment:
-
Thanks . If I fired only truncate it works faster than delete. My Procedure contains many select statements and one truncate command (i used dynamic sql there ). I have ran DBMS_PROFILER and found that my truncate command which I have used in dynamic sql took more time to execute . Then I replaced the truncate with normal delete command. It executed in minimum time. Also thr are no such index on my table .Leave a comment:
-
Thanks for your reply ..that dml operation performed in every day. There are total 6000000 rows in table.Leave a comment:
-
delete and truncate
Hello,
I have one concern , I have one table that contains huge data. I have created one procedure inside that procedure I am truncating that table . It takes very long time to execute that. When I saw the Dbms_profiler report I have observed that truncate statement took long time to execute around 20 minutes . Then I replace the truncate with delete . It executed within fraction of time with proper result. May I know why it happened... -
Thank you very much ...Leave a comment:
-
Can anybody please send me that sample code for Long datatype.Leave a comment:
-
Long datatype
Hi ,
Can anybody send me sample code for selecting data from column which has long datatype
Example
I have table test123, which has 2 colunn id number and data long
the data column which has long datatype contains
DOCSTART_1 |
DOCTYPE|
VERSION 5.4|
BILLST 1|
BILLTY 1|
BILLTEM 1|
BILLSEQ 4|
BVERSION 1|
PRECISIO T|
BILLHANDLINGCOD E... -
Hi Debasis,
Can u please replace the dbms_sql to Execute immediate and resend to me,
I am using oracle 10g. dbms_sql is old way of writting the code and it has been replace by execute immediate, Thats why I wanted to use the
execute immediate into my code,
Can u please rewrite the code into execute immediate and send it to me
Thanks for ur help ..Leave a comment:
-
can u please send me the updated code . Thanks in advanceLeave a comment:
-
Can anybody rewrite the above code in execute immediate format..
ThanksLeave a comment:
-
Dynamic Sql
I have written code in Dbms_sql form
Can anybody tell me how to use dynamic sql for below code ,..
If possible please rewriie below code in dynamic sql form and resend it
Thanks in advance ,,,,
...Code:create or replace function utlfile_gen ( p_query in VARCHAR2, p_separator in VARCHAR2 default '~', -
Thank you fr ur helpLeave a comment:
-
No that havenot work out ,, please giv me any other alternative method .Leave a comment:
-
Archiving the data
Hi
I would like to run a a script automatically everyday that removes the data from say EMP table and put into another file that is over 6 months old
. How would I go about doing this?
Is there any query or method for that? -
can u plz update my code and show me thatLeave a comment:
-
Thanks for ur reply ..But I am using SQLplus . Could u tell me is there any other method to get that .Leave a comment:
-
Comma seperated column
Hi,
I wanted to list the all columns of a emp table .
The output should be comma seperated and list of column should come in brakets like (enam,sal,jdate ,job). The below code gives me proper result.
But I am facing problem with last column name .It comes with coma and then braket . I dont want that comma with last column name .
Can u tell me how to achieve that .
Please refer below code ..
... -
Broken Pipe
I am getting broken Pipe error ?
Can Anybody tell me what is that error in brief and also how to avoid this type of error...
Thanks in advance
No activity results to display
Leave a comment: