Interested to Buy Any Domain ? << Click Here >> for more details...
How can u find column name from a table which have max value
in a row.( not max value)
- 5 Answers
- 7655 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahalakshmi s
select case when col1>col2 then 'col1' else 'col2' end, greatest(col1,col2) end from table_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is input buffer in sql*plus?
Can we call dml statement in function?
what is sp_pkeys? : Transact sql
what is the bond code in materialized view?
What do you know by pl/sql cursors?
How do I audit the sql sent to the server?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Can we use commit inside a trigger?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What do you understand by pl/sql packages?
explain the difference between delete , truncate and drop commands? : Sql dba
What is the difference between rename and alias?
what is the stuff function and how does it differ from the replace function? : Sql dba
How many commands are there in sql?
What is pl sql in oracle?
