Explain a synonym?
No Answer is Posted For this Question
Be the First to Post Answer
How to insert a record into a table?
Write a syntax for update query in oracle?
Explain the function of optimizer in oracle?
Is oracle a programming language?
Can objects of the same Schema reside in different tablespaces.?
How many data types are supported?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to convert characters to numbers in oracle?
What are the differences between char and varchar2 in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how do u know the total no of rows in a table?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?