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 |
What is the difference between 10g OEM and 11g OEM?
What is the difference between translate and replace?
What is an Integrity Constrains ?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is the usage of analyze command in oracle?
how to make an oracle object
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Explain the use of control file?
How to retrieve data from an explicit cursor?
How do I uninstall oracle client from windows?
can anyody please send me the dump for Oracle 10g certifications for DBA path?