I have 2 Databases. How can create a table in particular
database? How can i know the list of tables presented each
database?( in oracle 10g)

Answer Posted / vishnu

you can also use the database links to get the data from
other database tables. syntax is table_name@db_link.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What problem one might face while writing log information to a data-base table in pl/sql?

557


What is sql used for?

646


What is serial sql?

523


What are the different schemas objects that can be created using pl/sql?

526


difference between anonymous blocks and sub-programs.

622






What is nvarchar max in sql?

581


What are sql functions? Describe in brief different types of sql functions?

486


How do I write a sql query in pgadmin 4?

557


what are sequences

1091


What is cartesian join in sql?

558


What are primary key and foreign key and how they work?

553


How do you write a subquery?

521


What is index example?

557


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

598


What is sql and how does it work?

548