Most voted questions under tag oracle

+8 votes

2 answers

What is Snap shot in Oracle database?

posted Feb 5, 2014 by Neeraj Pandey

+6 votes

2 answers

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

posted Feb 10, 2014 by Prachi Agarwal

+5 votes

1 answer

what are Privileges and Grants in Oracle ??

posted Oct 10, 2014 by Archana

+5 votes

1 answer

When do use we procedure or function in oracle?

posted Feb 5, 2014 by Prasad

+5 votes

1 answer

Do we have any system table in oracle where log on session is maintained for user

posted Jan 4, 2014 by Neeraj Pandey

+4 votes

0 answers

Why one should use materialised view instead of table view?

posted Jul 18, 2016 by Mohammed Hussain

+4 votes

1 answer

What is a Bind Variable in Oracle Reports6i?

posted Feb 4, 2016 by Suchithra

+4 votes

2 answers

Oracle: What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

posted Apr 1, 2015 by Suchithra

+4 votes

1 answer

Oracle: Describe what redo logs are?

posted Mar 30, 2015 by Archana

+4 votes

1 answer

Oracle: How would you determine what sessions are connected and what resources they are waiting for?

posted Mar 30, 2015 by Archana

+4 votes

1 answer

Explain the difference between a data block, an extent and a segment?

posted Jan 23, 2015 by Shivaranjini

+4 votes

2 answers

What is Commit, Rollback and Savepoint in context of SQL/Oracle?

posted Nov 11, 2014 by Archana

+4 votes

1 answer

What are the Pct Free and Pct Used in Oracle?

posted Oct 13, 2014 by Vidhya Sagar

+4 votes

1 answer

Oracle JInitiator version too low. Please install version 1.1.8.2

posted Oct 10, 2014 by Vidhya Sagar

+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

+4 votes

1 answer

Name the three major set of files on disk that compose a database in Oracle ?

posted Feb 1, 2014 by Anuj Yadav

+4 votes

1 answer

What causes the "snapshot too old" error?

posted Jan 4, 2014 by Neeraj Pandey

+3 votes

1 answer

What is a Lexical Parameter in Oracle Report6i?

posted Feb 4, 2016 by Suchithra

+3 votes

1 answer

can we register the table with Application Interface (API) in Oracle Apps?

posted Nov 10, 2015 by Vidhya Sagar

+3 votes

1 answer

what are Steps Required for registering a Table in oracle Apps?

posted Nov 10, 2015 by Vidhya Sagar

+3 votes

1 answer

what are the steps to Register a Report in oracle Apps?

posted Oct 27, 2015 by Vidhya Sagar

+3 votes

1 answer

In what order should a open/fetch/loop ...... %NOTFOUND cursor variable in the exit when statement? Why?

posted Oct 22, 2015 by Shivaranjini

+3 votes

1 answer

What is the use of %ROWTYPE and %TYPE in PL/SQL?

posted Oct 22, 2015 by Shivaranjini

+3 votes

1 answer

What is a mutating table error and how can you get around it?

posted Oct 22, 2015 by Shivaranjini

+3 votes

1 answer

what are Package Specifications in plsql?

posted Oct 9, 2015 by Kunal Kapoor

+3 votes

1 answer

What is the use of NULLIF in Oracle?

posted Aug 10, 2015 by Suchithra

+3 votes

1 answer

What is INDEX and what are the advantages?

posted Jul 17, 2015 by Kunal Kapoor

+3 votes

1 answer

How to display the names of employees in Sql Query?

posted Jun 11, 2015 by Archana

+3 votes

1 answer

what is relations operator in Oracle?

posted May 25, 2015 by Suchithra

+3 votes

2 answers

what logical data Independence rule states?

posted May 15, 2015 by Kunal Kapoor

+3 votes

1 answer

what is PL/SQL Table?

posted Apr 23, 2015 by Viswas Kumar

+3 votes

1 answer

Oracle: You have just compiled a PL/SQL package but got errors, how would you view the errors?

posted Apr 8, 2015 by Kunal Kapoor

+3 votes

1 answer

Oracle: Explain what partitioning is and what its benefit is.

posted Apr 8, 2015 by Kunal Kapoor

+3 votes

1 answer

What is the difference between Rollup ad cube?

posted Apr 3, 2015 by Santosh Kumar Panigrahi

+3 votes

1 answer

oracle: What does coalescing a tablespace do?

posted Apr 1, 2015 by Suchithra

+3 votes

1 answer

Oracle: Give two methods you could use to determine what DDL changes have been made

posted Mar 31, 2015 by Archana

+3 votes

1 answer

Oracle: How would you force a log switch?

posted Mar 31, 2015 by Archana

+3 votes

1 answer

Oracle: how to display Odd/ Even number of records?

posted Mar 16, 2015 by Archana

+3 votes

0 answers

Oracle: Why is the query not fetching the records for the date I wanted?

posted Feb 13, 2015 by Archana

+3 votes

1 answer

Can we define exceptions twice in same block in PLSQL?

posted Dec 1, 2014 by Archana

+3 votes

1 answer

Explain three different rules that apply to NULLs when doing comparisons?

posted Nov 11, 2014 by Archana

+3 votes

1 answer

What special operators does Oracle provide for dealing with NULLs?

posted Nov 11, 2014 by Archana

+3 votes

1 answer

can any one explain about SQL Unions Clause in detail ?

posted Nov 5, 2014 by Archana

+3 votes

1 answer

Difference between TRUNCATE, DELETE and DROP commands?

posted Oct 27, 2014 by anonymous

+3 votes

3 answers

How many columns can table have in Oracle?

posted Oct 21, 2014 by Vidhya Sagar

+3 votes

1 answer

what is Physical Storage of the Data in Oracle?

posted Oct 14, 2014 by Archana

+3 votes

1 answer

What is concurrency in oracle?

posted Oct 9, 2014 by Vidhya Sagar

+3 votes

1 answer

What are the inline and the precompiler directives?

posted Oct 6, 2014 by Vidhya Sagar

+3 votes

1 answer

How many types of Exceptions are there?

posted Oct 3, 2014 by Suchithra

+3 votes

1 answer

How do u implement the If statement in the Select Statement?

posted Oct 3, 2014 by Suchithra