Answer Posted / brajesh kumar
SELECT *FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP)
| Is This Answer Correct ? | 5 Yes | 25 No |
Post New Answer View All Answers
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 difference between sql plus and sql*plus? (not sql and sql plus).
Is java required for oracle client?
How to write a query with an inner join in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
What is the quickest way to fetch the data from a table?
What are the major difference between truncate and delete?
How to rename a column in an existing table?
Explain the difference between a procedure and a function?
How to convert times to characters in oracle?
Explain a private synonyms?
What is the database name in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is a subquery in oracle?
Name the three major set of files on disk that compose a database in Oracle?