how to produce numbers from 1 to 10 using dual table
Answer Posted / ml
select level from dual connect by level < 11;
Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
What is oracle open database communication (odbc)?
how the indexes are stored in the Oracle Database?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Hi Can any one tell me what are the API's used in requisition import.
How to commit the current transaction in oracle?
How to use "startup" command to start default instance?
How to view the tablespaces in the current database?
Write a syntax for update query in oracle?
Whether any commands are used for months calculation? If so, what are they?
What is Virtual Private Database in Oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain do view contain data?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?