How to reference remote tables in procedures

Describe how to reference remote tables in procedures with an example.

Using SQL statements, remote tables can be accessed in procedures. Database links are specifically used for this purpose. They connect one oracle database to another.
CREATE DATABASE LINK employee.in.india.acme_auto.com ... ;

To access a remote table, the table name can be specified using a SQL statement.
SELECT * FROM salary.employee@employee.in.india.acme_auto.com ;
Significance of Return clause in stored procedure
Return statement in a stored procedure is not to return values.....
What are actual and formal parameters in oracle?
Information in subprograms is passed through parameters. If the parameter declared in a subprogram is referenced in the subprogram body, it is called as a formal parameter..
What are sequences? Explain with syntax
A field in oracle can be kept as auto incremented by using sequence. it can be used to create a number sequence......
Post your comment

Related Content

Follow us

▲