Most answered questions under tag oracle

+1 vote

3 answers

What are the Disadvantages of a CLUSTER?

posted Jul 22, 2015 by Archana

+3 votes

3 answers

How many columns can table have in Oracle?

posted Oct 21, 2014 by Vidhya Sagar

0 votes

3 answers

How to convert Oracle rows to columns?

posted Aug 21, 2014 by Selvimohana

+1 vote

3 answers

What is the main difference between the IN and EXISTS clause in subqueries?

posted Aug 19, 2014 by Joshva

0 votes

2 answers

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

posted Nov 25, 2015 by Archana

+2 votes

2 answers

How the function security works in Oracle Apps?

posted Nov 24, 2015 by Suchithra

+1 vote

2 answers

what is Value Set in Oracle Apps?

posted Nov 16, 2015 by Suchithra

+1 vote

2 answers

What is KFF and How many are supplied with the Package in Oracle Apps?

posted Nov 13, 2015 by Viswas Kumar

0 votes

2 answers

Oracle: What is the difference between a View and Materialized View?

posted Sep 15, 2015 by Suchithra

+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

+2 votes

2 answers

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

posted Aug 12, 2015 by Archana

0 votes

2 answers

How to see what privileges received to user by owner user?

posted Jul 30, 2015 by Viswas Kumar

+1 vote

2 answers

What is the use of CLUSTER?

posted Jul 22, 2015 by Archana

+1 vote

2 answers

What is Deadlock in Oracle?

posted Jul 10, 2015 by Kunal Kapoor

+1 vote

2 answers

What is SQL and where does it come from?

posted Jun 15, 2015 by Suchithra

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

+1 vote

2 answers

What is a CO-RELATED SUBQUERY?

posted Jun 1, 2015 by Suchithra

+3 votes

2 answers

what logical data Independence rule states?

posted May 15, 2015 by Kunal Kapoor

+1 vote

2 answers

how to Alter database archievelog in Oracle?

posted May 5, 2015 by Vidhya Sagar

+4 votes

2 answers

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

posted Apr 1, 2015 by Suchithra

+2 votes

2 answers

Oracle: Any three PL/SQL Exceptions?

posted Mar 17, 2015 by Archana

+1 vote

2 answers

Oracle: What is a Cartesian product?

posted Mar 9, 2015 by Suchithra

+1 vote

2 answers

Oracle: which of the following is better to find the number of rows in a table?

posted Mar 9, 2015 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

+1 vote

2 answers

Oracle: What is a dual table and why is it used?

posted Feb 12, 2015 by Archana

+1 vote

2 answers

Oracle: what is an oracle precompiler?

posted Feb 12, 2015 by Archana

+2 votes

2 answers

Oracle: How can I retrieve a specified number of highest- or lowest-value columns with a single query?

posted Feb 10, 2015 by Archana

+1 vote

2 answers

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

posted Feb 9, 2015 by Suchithra

0 votes

2 answers

Oracle: Why should I not commit after every record when updating a large table?

posted Feb 6, 2015 by Suchithra

+1 vote

2 answers

What are the advantages of Oracle?

posted Jan 22, 2015 by Archana

+1 vote

2 answers

Oracle: When to create indexes?

posted Jan 9, 2015 by Archana

+1 vote

2 answers

Oracle: How can you avoid indexes?

posted Jan 9, 2015 by Archana

+1 vote

2 answers

Oracle: What are the various types of RollBack Segments?

posted Dec 29, 2014 by Archana

+2 votes

2 answers

Oracle: What is the significance of the &, and && operators in PL SQL?

posted Dec 24, 2014 by Archana

+1 vote

2 answers

What is the maximum no. of columns a table can have in Oracle ?

posted Dec 23, 2014 by Suchithra

+1 vote

2 answers

What are the disadvantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+1 vote

2 answers

What are the advantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+1 vote

2 answers

Can some body give me some example of INSTEAD OF trigger?

posted Dec 2, 2014 by Archana

+2 votes

2 answers

What is a Result Set? when is it created?

posted Nov 18, 2014 by Archana

+1 vote

2 answers

Explain Implicit and Explicit cursors.

posted Nov 12, 2014 by Vidhya Sagar

+4 votes

2 answers

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

posted Nov 11, 2014 by Archana

+1 vote

2 answers

can any explain about SQL TRUNCATE TABLE?

posted Nov 5, 2014 by Archana

+1 vote

2 answers

What is Normalization in Oracle?

posted Oct 17, 2014 by Suchithra

+2 votes

2 answers

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

posted Oct 9, 2014 by Suchithra

+1 vote

2 answers

What is a Transaction in Oracle?

posted Sep 29, 2014 by Archana

+1 vote

2 answers

What are the types of framework manager?

posted Sep 28, 2014 by Amit Kumar Pandey

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

+1 vote

2 answers

query to get calender in Oracle SQL

posted Sep 19, 2014 by Archana

+1 vote

2 answers

What is oracle d2k? why we use it?

posted Sep 16, 2014 by Suchithra

+2 votes

2 answers

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

posted Sep 16, 2014 by Archana