What are virtual columns?
Answers were Sorted based on User's Feedback
Answer / shanmugavelu
Virtual column or Pseudo Columns like
rowid,rownum,sysdate,nextval,currval,uid,user
Is This Answer Correct ? | 9 Yes | 0 No |
How to create a new table in your schema?
What are the database administrators utilities available?
What is sharded cluster?
what is cartesian product?
What is dynamic proxy?
Where is the export dump file located?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
What are joins, explain all types of joins?
how to we delete a row using varray
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?