How many types of database triggers exist?
how to retrieve 1st and last row of table without using group functions??
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
Explain the use of online redo log files in oracle.
What is a nested table?
What are the factors causing the reparsing of SQL statements in SGA?
What is a database schema in oracle?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
What is transport network substrate (tns) in oracle?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
Is there any function in oracle similar like group_concat of mysql?
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 do paging with oracle?