Answer / 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;

What is a database development?

0 Answers  

---

How to generate OIDS

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

What are the key features of dbms?

0 Answers  

---

What is DB Development software?

0 Answers  

---

Why does this query return 0?

0 Answers  

---

What is a join and explain different types of joins?

2 Answers  

---

Which data type cannot be used as a parameter in a udf?

0 Answers  

---

how to find the first two highest salaries in deptno in emp table

2 Answers  

---

What is the maximum length of an extended property?

0 Answers  

---

fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

Explain the rollup operator?

0 Answers  

---