Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 4305 Views
- I also Faced
- E-Mail Answers
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 alias?
How to find out what oracle odbc drivers are installed?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to define a procedure inside another procedure?
How can I see all tables in oracle?
How to synchronize 2 schema's objects?
How to use an explicit cursor without open statements?
Give the advantages and disadvantages of clusters.
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
What privilege is needed for a user to query tables in another schema?
what is the syntax of update command?
Oracle General 
