State all possible different index configurations a table can possibly have?
No Answer is Posted For this Question
Be the First to Post Answer
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
What is the function of Optimizer ?
Explain the use of analyse option in exp command.
How to pass parameters to procedures in oracle?
Explain the use of record length option in exp command.
how to create a new database in oracle?
Explain how are indexes update?
When a form is invoked with call_form, Does oracle forms issues a save point ?
How to call a trigger inside a stored procedure?Give an example.
How do we know whether an index is created on a table ???
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.