Interested to Buy Any Domain ? << Click Here >> for more details...
i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 46999 Views
- HCL, Nyros, Oracle, I also Faced
- E-Mail Answers
Answer Posted / srikanth
select rownum from user_objects where rownum <= 10 order by
rownum ASC
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
What is the difference between function and procedure in pl/sql?
What is the benefit of foreign key?
what are ddl statements in mysql? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
what are tables and fields? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
what is the syntax used for partition in tsql? : Transact sql
Mention what plvcmt and plvrb does in pl/sql?
How to return multiple rows from the stored procedure?
Can we insert data in view?
What's the procedure?
How does stored procedure reduce network traffic?
What do you understand by case manipulation functions?
How is use pl and sql?
What is a join?
