when a grant option is encountered for a table EMP to a
peer sitting beside you who has already having the table of
that name (EMP), then what is the result?
Answers were Sorted based on User's Feedback
Answer / devraj
He will have the rights on both tables. But on query the
first result will be fetched from his schema table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Explain the use of grant option in imp command.
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
Compare and contrast between sql and sql server and explain its various functions?
how to store only time in a data base table
Explain the use of analyse option in exp command.
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
What exactly do quotation marks around the table name do?
How to execute the package in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to convert numbers to characters in oracle?
What different of iner joint & outer joint with example
Difference between pre-select and pre-query