Answer Posted / ravi satyadarshi
//1st of all create a directory to store ur external table
CREATE DIRECORY EMP_DIR AS '/FLAT_FILES' ;
// now write the following line of code to create an
external table at that directory
CREATE TABLE OLDEMP(ENO NUMBER,ENAME CHAR(20),DOB DATE,)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY EMP_DIR
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
BADFILE 'BAD_EMP')
LOGFILE 'LOG_EMP'
FIELDS TERMINATED BY ','
(ENO CHAR , ENAME CHAR DOB CHAR DATE_FORMAT
DATE MASK "DD-MON-YYYY"
)
)
LOCATION ('EMP1.TXT')
)
PARALLEL 5
REJECT LIMIT 200;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How is data stored in dbms?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
How can you fix a poorly performing query?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What are the 18 schemas?
Explain the process of the user request and data generating?
What are the three types of database design?
What is a database development?
Explain the cube operator?
Explain about relational operator join?
How long can an error message be in raiseerror function?
State the acid rules?
How to customize error conditions.
Explain about xml databases?
