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;

Explain the rollup operator?

0 Answers  

---

What is dbms explain in brief?

0 Answers  

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

---

Explain about xml databases?

0 Answers  

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

Explain about a primary key?

0 Answers  

---

What are the types of database model?

0 Answers  

---

Why does this query return 0?

0 Answers  

---

Explain about the hierarchical model of the database?

0 Answers  

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

Who are naive users?

0 Answers  

---

what is the use of foreginkey

2 Answers  

---