What is Public Database Link ?
Answer / orawhiz
Public database link is created for the special user group
PUBLIC.
A public database link can be used when any user in the
associated database specifies a global object name in a SQL
statement or object definition.
Is This Answer Correct ? | 0 Yes | 0 No |
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
What is the difference between an Oracle Schema and an Oracle Instance?
What is the function of Optimizer ?
Explain a private synonyms?
What is an oracle function?
how to get the index id?
Point the difference between translate and replace?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are the tools for Oracle ?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What is bulk collect in oracle?