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 to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.
Mention what are the benefits of pl/sql packages?
what is 'mysqladmin' in mysql? : Sql dba
what is commit? : Sql dba
how to calcuate the second highest salary of he employee
How run sql*plus commands that are stored in a local file?
How do you create a db file?
What is mutating table error?
What is the difference between mdf and ndf files?
Cite the differences between execution of triggers and stored procedures?
Define select, insert, create, delete, update, drop keywords
Sql technical questions
Oracle (3253)
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)