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
- 7453 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
Why do we use procedures in sql?
Does db2 use sql?
What will you get by the cursor attribute sql%rowcount?
What is difference between pls_integer and integer?
How do I run sql profiler?
Which table is left in join?
How can you know that statistics should be updated?
Explian rowid, rownum?
How do sql databases work?
What is the difference between function and procedure in pl/sql?
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...
What is bind variable in pl sql?
What are different types of keys?
How do I view a sql trace file?
How do I delete a trigger?
