Answer Posted / prabha
consider database DB1 and table TB1
we can able to access TB1 from another Database
Ex . select * from TB1@LINK1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which sql statement is used to return only different values?
What is difference between inner join and self join?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
what is a control file ? : Sql dba
Can a procedure in a package be overloaded?
What is a crud api?
What is a sql statement?
What are the types of index in sql?
What is meant by user defined function?
Can we commit inside a trigger?
What sql database should I use?
How to change the order of columns in Oracle SQL Plus ?
What is nested table in pl sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is materialized view in sql?