Answer Posted / kavitha
select ename,sal
from employees
where rownum <=1
order by sal desc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is use of term?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How do I view a table in sql?
How do you update a table in sql?
What is a common use of group by in sql?
what happens if null values are involved in expressions? : Sql dba
What is auto increment in sql?
Can we use two order by clause in query?
what is the different between now() and current_date()? : Sql dba
Which is better join or inner query?
Can ddl statements be used in pl/sql?
What is tuple in 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 bdb (berkeleydb)? : Sql dba
What is the largest value that can be stored in a byte data field?
