how can create data base link for tow servers (scott
schema) give examples plz
Answers were Sorted based on User's Feedback
Answer / m haribaskar
Create Database Link <<LinkName>>
Connect to <<USerName>>
Idenitfied By <<PAssword>>
Using <<DATABASE_NAME>>
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / gaurav gupta
CREATE PUBLIC DATABASE LINK remote
USING 'remote';
| Is This Answer Correct ? | 0 Yes | 2 No |
how many ways to get the current time? : Sql dba
How is sql used in oracle?
what are the join types in tsql? : Transact sql
How do I audit the sql sent to the server?
how to run 'mysql' commands from a batch file? : Sql dba
What are triggers, and when would you use them?
When would you denormalize?
8 Answers MBT, Microsoft, MMU,
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
How to use sql*plus built-in timers?
Explain the difference between sql and mysql.
take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...
Why function is used in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)