What is a nested table?
No Answer is Posted For this Question
Be the First to Post Answer
What is an oracle database table?
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?
waht is the difference between primary key and super key?
What is indexing, and how does it improve performance?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to delete a column in an existing table?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What do you mean by a database transaction & what all tcl statements are available in oracle?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
how to find out second largest value in the table