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 are triggers and its uses?
Which data dictionary views have the information on the triggers that are available in the database?
How delete all records from table in sql?
How do I find duplicates in sql?
What is %type in sql?
How many types of relationship are there?
How do you delete data from a table?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
what is a unique key ? : Sql dba
Can %notfound return null after a fetch?
Why is sql better than hql?
Explain polymorphism in pl/sql.
What is the difference between the conventional and direct path loader? : aql loader
Explain the insert into statements in sql?
What is embedded sql in db2?