i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 42550 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 sql scripting?
Can a varchar be a primary key?
What is execute immediate?
What is record in pl sql?
What is indexing oracle sql?
What are the different set operators available in sql?
How would you pass hints to the sql processor?
What is on delete restrict?
Why indexing is needed?
Why is there a need for sqlcode and sqlerrm variables?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
what is blob? : Sql dba
Write the command to remove all players named sachin from the players table.
What is sql server and ase?
Can there be more than one function with a similar name in a pl/sql block?
