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

Inline the values in PL/SQL, what does it mean.?

851


Which operator is used in query for pattern matching?

831


How do you delete a table?

759


Does mysql_real_escape_string prevent sql injection?

684


what are the non-standard sql commands supported by 'mysql'? : Sql dba

770






What is dynamic query?

729


Explain raise_application_error.

828


Explain character-manipulation functions?

834


what is an index? : Sql dba

716


What is the best free sql database?

760


what is the difference between delete and truncate statement in sql? : Sql dba

757


How do I write a cron which will run a sql query and mail the results to agroup?

713


What are basic techniques of indexing?

1066


How many sql databases can you have on one server?

754


What are inner and outer joins examples of both?

689