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 about relational database management systems?

0 Answers  

---

What is data modeling with example?

0 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

Explain about post-relational databases?

0 Answers  

---

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?

0 Answers  

---

How to generate OIDS

0 Answers  

---

State the acid rules?

0 Answers  

---

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

0 Answers  

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

0 Answers   IBM,

---

Who are naive users?

0 Answers  

---