How to create a table index?
No Answer is Posted For this Question
Be the First to Post Answer
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
How to see the table columns used in an index?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
what is difference between foreign key and reference key
What is transport network substrate (tns) in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How does Oracle guarantee data integrity of data changes?
How to get a list of all user accounts in the database?
what is candidate key & super key
How many types of segments in Oracle?
Is rowid unique in oracle?