what's query optimization and without use of IN AND Exist can
we get another way data from query
No Answer is Posted For this Question
Be the First to Post Answer
What are the benefits of ordbms?
What is a trace file and how is it created in oracle?
What is oracle rowcount?
Explain the use of constraints option in exp command.
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is proxy method?
What is the difference between truncate & delete command?
what is the use of system.effective.date variable in oracle?
How to create an oracle testing table?