How to see the table columns used in an index?
What is Rollback Segment ?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
Is java required for oracle client?
What is the parameter mode that can be passed to a procedure?
what is query and types of query
What is SQL access advisor in Oracle?
What is Index Cluster ?
What is a Database instance ? Explain?
Explain the use of full option in exp command.
How would you design a database for an e-commerce website?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
what are bitmap indexes? How does they work?