Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a view on a table which does not exists
- 4 Answers
- 21050 Views
- Oracle, TCS, I also Faced
- E-Mail Answers
Answer Posted / senthil
sorry, i am not understand..... emp table is not exit meaning?
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can we write ddl statements in functions?
What is the primary use of normalization?
What is data manipulation language?
Explain the the delete statements in sql?
What is difference between procedure and trigger?
What is foreign key sql?
How do you use collections in procedure to return the resultset?
What is the use of procedures?
how can we know the number of days between two given dates using mysql? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is a field in a database?
Mention what are different methods to trace the pl/sql code?
Why triggers are used?
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 do you understand by pl/sql cursors?
