i want to display 1 to 10 numbers using one select statement.
Answer Posted / rashmi raju
select 1,2,3,4,5,6,7,8,9,10 from dual;
| Is This Answer Correct ? | 3 Yes | 20 No |
Post New Answer View All Answers
Is trigger a stored procedure?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is the difference between numeric and autonumber?
What are all the different types of indexes?
Explain the difference in execution of triggers and stored procedures?
Is sql better than excel?
what is a materialized view? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
How to Execute a Package in PL/SQL.?
what is a cursor? : Sql dba
What sql does db2 use?
What is dynamic sql in pl sql?
What are all the ddl commands?
Is inner join same as self join?
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...