What is schema?
Answer Posted / ashutosh
Schema is a collection of user defined objects such as
(table,view,procudure,etc..)
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How would you go about verifying the network name that the local_listener is currently using?
Explain the use of inctype option in exp command.
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.
What is a procedure in oracle?
Is oracle the best database?
How to use group functions in the select clause using oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is literal?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is the recommended interval at which to run statspack snapshots, and why?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is an oracle user account?
How to retrieve data from an explicit cursor?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?