How to run queries on external tables?

649

Explain what does a control file contain?

692

What is the use of aggregate functions in oracle?

676

What is a subquery?

703

How to clone the database using RMAN back

1704

please explain.. DB architecture ...

1658

what are bind variables?

662

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1680

How will you run ms_batch file in forms?

1

Mention in rac what files should be created on shared storage?

1

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

337

What is the string concatenation operator in oracle?

665

What is a partition in oracle?

639

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

346

What is the data quality?

388