How many types of synonyms in Oracle?
No Answer is Posted For this Question
Be the First to Post Answer
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
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is an Index ? How it is implemented in Oracle Database ?
What is ASM (Automatic Storage Management) in Oracle?
How to shutdown your 10g xe server?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the exact use of Collections?
what is kernel?
Explain compound trigger in oracle?
How to resolve name conflicts between variables and columns?