Tar Command
For detailed information on TAR command read the below article
Article
Madhusmita Biswal
Last Activity: Mar 11 '10, 01:05 PM
Joined: Feb 25 '10
Location:
-
Leave a comment:
-
materialized view
You can use on prebuilt table clause when you create a materialized view
Follow the linkLeave a comment:
-
Poor performance - Issue
Depending on how much data is in the tables, you may need to place indexes on the columns that are being joined against. Often slow querying speed comes down to lack of an index in the right place.
The issue mainly is in the multiple join statment. If possible try to avoid join
Read these articleLeave a comment:
-
Use UTL_File and follow the steps
Follow the steps
1) First try to create a directory and in the directory create a file with txt and keep all ur data 000000001234567 801012010085
2) These directory is basically for using UTL_FILE concept.
3) Use UTL_FILE.fopen and UTL_FILE.get_li ne
4) After you get the data 000000001234567 801012010085 use substr to get first 16 as barcode ,2nd 8 as date and last...Leave a comment:
-
in order to know the primary key column name and forign key column in a table just execute the query :=
SELECT * FROM ALL_CONS_COLUMN S A JOIN ALL_CONSTRAINTS C ON A.CONSTRAINT_NA ME = C.CONSTRAINT_NA ME
WHERE C.TABLE_NAME = <table_name>
AND C.CONSTRAINT_TY PE in ('P','R')
and a.owner=<owner_ name>
and c.owner=<owner_ name>Leave a comment:
No activity results to display
Leave a comment: