Explain can a view based on another view?
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.
How to sort the query output in oracle?
What is self-referential integrity constraint ?
Can we commit inside a function in oracle?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
How to rebuild an index in oracle?
What do you mean by merge in oracle?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What is the use of aggregate functions in oracle?
How to create tables for odbc connection testing?
What are the set operators union, union all, minus & intersect meant to do?