Can we relate two different tables from two different users
in ORACLE,PL/SQL?
Answer Posted / sakthi santhanam.a
yes, we can do that... in oracle using GRANT command..
" GRANT select on table_name to nextuser(2nd user)"
this is the query...
wish you all the success
sakthi.A
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is forward declaration in pl sql?
Explain two easy sql optimizations.
What is view? Can we update view
What is the purpose of cursors in pl/sql?
What are the three forms of normalization?
Whis is not false in primary key?
Mention what are different methods to trace the pl/sql code?
Why use stored procedures?
Define tables and fields in a database
Which type of cursor is used to execute the dml statement?
Explain what is a field in a database and record in a database?
What are different types of statements supported by sql?
How run sql*plus commands that are stored in a local file?
What is a pl/sql block?
What is the purpose of normalization?