How Can You Reference Remote Tables In Procedures?

Category: QuestionsHow Can You Reference Remote Tables In Procedures?
Editor">Editor Staff asked 2 years ago

How Can You Reference Remote Tables In Procedures?

1 Answers
Editor">Editor Staff answered 2 years ago

Remote tables can be referenced within procedures through SQL statements. A remote table can be queried through a database link in the procedure. The following code inserts a record in the STUDENT_MARKS table, which is in another schema, using the CONNECT_STUDENT database link: