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 ? | 2 Yes | 2 No |
Post New Answer View All Answers
what are all different types of collation sensitivity? : Sql dba
What are the three pl sql block types?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Is a view faster than a stored procedure?
Is primary key is clustered index?
What is the difference between having and a where in sql?
What is program debugging?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Which table is left in join?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is the use of non clustered index?
Show how functions and procedures are called in a pl/sql block.
How do you exit in sql?
What are the types of queries in sql?
Why sql query is slow?