Most viewed questions under tag oracle

+6 votes

2 answers

What is the difference between decode and case statement in Oracle?

posted Feb 10, 2014 by Prachi Agarwal

+1 vote

1 answer

Oracle: How to update COMPLEX VIEW?

posted Sep 8, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: How display the names of employees who are working in the company for the past 5 years?

posted Jun 12, 2015 by Kunal Kapoor

+2 votes

2 answers

What is the difference between MAX () and GREATEST () Functions in Oracle?

posted Aug 12, 2015 by Archana

+2 votes

1 answer

What is difference between Update and Alter commands?

posted Jul 27, 2015 by Suchithra

+4 votes

1 answer

What is the difference between Row_Number and Rank in Oracle and in which place we can use them

posted Feb 18, 2014 by Neeraj Pandey

+1 vote

2 answers

How to check the Leap Year using Function in Oracle SQL

posted Sep 15, 2014 by Archana

+2 votes

1 answer

Database driver error when loading data with Informatica into Oracle XE 10 g

posted Oct 13, 2014 by Sunil

+2 votes

0 answers

Oracle session is waiting on event : rdbms ipc message.

posted Dec 12, 2013 by Gaurav Sisodia

+2 votes

2 answers

how to write a query that results an pyramid structure in Oracle SQL

posted Sep 16, 2014 by Archana

+2 votes

1 answer

difference between analytic and aggregate function?

posted Mar 17, 2015 by Santosh Kumar Panigrahi

+1 vote

1 answer

How does one select EVERY Nth row from a table In Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is the difference between SIMPLE and COMPLEX VIEWS?

posted Sep 8, 2015 by Vidhya Sagar

+1 vote

1 answer

what are the steps Required to Developing a New Form in oracle Apps?

posted Nov 20, 2015 by Kunal Kapoor

+1 vote

1 answer

What is the link between sales order and purchase order in Oracle R12

posted Sep 16, 2014 by Vidhya Sagar

+2 votes

1 answer

Interview question: Which of the following is not a schema object Oracle?

posted Jan 30, 2015 by Archana

0 votes

1 answer

OBI-SEC-00004: unable to initialize oracle.bi.security.service.URIdentityStoreProvider

posted Aug 18, 2014 by Ela

+1 vote

1 answer

How to display employee name and annual salary for all employees?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

Oracle: What is the maximum no. of statements that can be specified in a trigger statement?

posted Dec 10, 2014 by Suchithra

+2 votes

2 answers

Which of the following is not a schema object : Indexes, tables, public synonyms, triggers and packages ?

posted Feb 23, 2015 by Latha

+2 votes

1 answer

how to avoid NaN error in XML?

posted Sep 17, 2014 by Suchithra

+1 vote

1 answer

Trigger Infa workflow based on the status column in oracle table

posted Nov 7, 2014 by anonymous

+2 votes

1 answer

How to display names of employees who do not earn any commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+2 votes

1 answer

Can you have two functions with the same name in a PL/SQL block?

posted Dec 1, 2014 by Archana

0 votes

1 answer

Oracle: What is the difference between foreign key and reference key?

posted Jan 16, 2015 by Suchithra

+1 vote

1 answer

What is the difference between Transaction and a Query?

posted Aug 4, 2015 by Suchithra

+1 vote

1 answer

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

posted Nov 11, 2014 by Archana

+2 votes

1 answer

Message: User-Defined Exception in Package Oe_Config_Util Procedure Process_Included_Items

posted Sep 18, 2014 by Suchithra

+1 vote

1 answer

What is the difference between SQL and SQL*PLUS commands?

posted Jun 30, 2015 by Vidhya Sagar

+2 votes

2 answers

What is the difference between candidate key, unique key and primary key in Oracle?

posted Oct 9, 2014 by Suchithra

0 votes

1 answer

what are the steps Required To Create a FIND WINDOW in Oracle Apps?

posted Nov 25, 2015 by Archana

+3 votes

1 answer

Can we define exceptions twice in same block in PLSQL?

posted Dec 1, 2014 by Archana

+2 votes

2 answers

Oracle: If a unique key constraint on DATE column is created, will it validate the rows that are inserted with sysdate?

posted Aug 21, 2015 by Kunal Kapoor

+1 vote

1 answer

How to encrypt a PL/SQL application in oracle

posted Apr 6, 2014 by Neeraj Pandey

+2 votes

1 answer

What are the difference between DDL, DML, DQL, TCL and DCL commands?

posted Jul 15, 2015 by Archana

+2 votes

1 answer

what is Positional and Named Notation in Oracle?

posted Apr 29, 2015 by Archana

+1 vote

1 answer

How we can get nth max salary from Employee Table (EMP_ID, Salary)

posted Feb 1, 2015 by Garima Gupta

+1 vote

1 answer

What is bulk copy or BCP in oracle?

posted May 5, 2014 by Avinash Shukla

+2 votes

1 answer

Please explain about Forward Declaration in Oracle?

posted Apr 22, 2015 by Archana

+1 vote

1 answer

Oracle: What is the effect of synonym and table name used in same Select statement?

posted Jan 14, 2015 by Vidhya Sagar

+1 vote

1 answer

What is the difference between deleting and truncating of tables in Oracle?

posted Oct 15, 2014 by Suchithra

+3 votes

1 answer

What is the use of NULLIF in Oracle?

posted Aug 10, 2015 by Suchithra

+1 vote

1 answer

Oracle: What is the maximum number of triggers, can apply to a single table?

posted Mar 23, 2015 by Suchithra

+1 vote

2 answers

Oracle: I want to use a view to update a table. Is it possible?

posted Feb 9, 2015 by Suchithra

+1 vote

1 answer

What is the difference between SQL and SQL*PLUS?

posted Sep 24, 2014 by Archana

0 votes

2 answers

How to display the names of all employees who are working in department number 10 in Oracle?

posted Jun 9, 2015 by Vidhya Sagar

+2 votes

1 answer

What is the difference between COUNT (), COUNT (*) Functions in SQL?

posted Aug 5, 2015 by Archana

+2 votes

0 answers

Why select * from dba_users shows total number of rows selected but for normal table it won't shows the count of rows?

posted Feb 21, 2017 by Chinmoy Padhi

0 votes

2 answers

how to write a query to select Nth row from a table in Oracle SQL?

posted Sep 22, 2014 by Archana

0 votes

2 answers

what are the steps Required to Implement ROW LOV in Oracle Apps?

posted Nov 25, 2015 by Archana