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 delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id
What are the set operators in sql?
Why do we use procedures?
What are inner outer left and right joins in sql?
What does the file extension accdb stand for?
What are the blocks in stored procedure?
What jobs use sql?
How can you fetch first 5 characters of the string?
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
How do you take the union of two tables in sql?
How does rowid help in running a query faster?
What are the advantages of indexing?