How to create a stored function in oracle?
Can you use a commit statement within a database trigger?
Is there any function in oracle similar like group_concat of mysql?
Why do you create or replace procedures rather that drop and recreate.
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
What do you understand by database schema and what does it hold?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
How to get last row id?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
can you explain performance tunning in oracle(sql,PL/SQL)
Is oracle a programming language?
How to add a new column to an existing table with a default value?