User Profile

tabla · Sep 29 '09, 08:27 AM

Hi,
There is one package UTL_FILE in oracle which read/write/append the data into existing or New .txt or .xls or .csv file.

First have all the data which u want to write in file into cursor.
Then open a file in UTL directory (take help of dba to know the path).
Using UTL_FLIE.PUT_LI NE procedure you can write a data in to FILE.
After reading all records from cursor close the open file.

Tabla

tabla · Sep 29 '09, 07:25 AM

Hi,
Have u tried it with UTL package.check the same it is very fast.

Tabla

tabla · Sep 26 '09, 06:12 AM

Hi balu,
Kindly find the example.
In step 1) Create tables --> the target table for incremental load(MERGE_TEST ) and one for history(MERGE_T EST_HIS)

Step 2) Create trigger to store data which will updat in next day load but already present in table.

step 3) In this cursor will have current data to be loaded. The merge statement will check whether the part_id from cursor is available or...

OraMaster · Sep 24 '09, 08:59 AM

Hi
I am working as a PLSQL developer on Oracle 10g. Yes there are opportunities outside for Oracle PLSQL developer that depends on your yrs of experience.

tabla · Sep 24 '09, 08:43 AM

Hi,

Ok.

Worm Regards
Tabla...

tabla · Sep 24 '09, 08:25 AM

Hi Bhushan,
In which platform u r working. are there any opportunities outside for (plsql developer)

revert if any.

Tabla...

tabla · Sep 24 '09, 06:54 AM

Hi,
Thx for suggestion. can u please suggest the book names for the same.

Worm Regards,
Tabla....

tabla · Sep 24 '09, 06:04 AM

Hi Balu,
You can use merge statement where u can put a Flag for new updated or inserted records and maintain track of updated records using trigger in history table.

Warm regards,
Tabla

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

what happens when a sql query get executed containing joins in it.explain in details