What privilege is needed for a user to create views in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How to enter a new row into a table interactively?
Can we write insert statement in function in oracle?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
How do you find current date and time in oracle?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
What are Clusters ?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain rename?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
how to create a new database in oracle?
When can Hash Cluster used ?
Can we create trigger on materialized view in oracle?