Most viewed questions under tag oracle

+3 votes

1 answer

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

posted Nov 10, 2015 by Vidhya Sagar

0 votes

1 answer

what are the steps Required To Invoke Descriptive Flex Fields (DFF) in Oracle Apps?

posted Dec 1, 2015 by Vidhya Sagar

+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

+1 vote

1 answer

Difference between PRIMARY KEY, UNIQUE KEY, CANDIDATE KEY? Where I have to use this?

posted Apr 30, 2015 by Nagaraj

+2 votes

1 answer

Oracle: When a user process fails, what background process cleans up after it?

posted Mar 27, 2015 by Suchithra

+1 vote

1 answer

Oracle: how to find out 9th highest salary from emp table?

posted Mar 13, 2015 by Suchithra

+1 vote

1 answer

Is there a PL/SQL Engine in SQL*Plus?

posted Feb 3, 2015 by Suchithra

+1 vote

1 answer

How to escape special characters when building SQL queries?

posted Jun 15, 2015 by Suchithra

+3 votes

1 answer

How to display the names of employees in Sql Query?

posted Jun 11, 2015 by Archana

+1 vote

1 answer

Find out nth highest salary from emp table in Oracle?

posted May 29, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: what is the command switch to DOS prompt from sql ?

posted Mar 12, 2015 by Suchithra

+2 votes

1 answer

what are the Predefined Exceptions in plsql?

posted Oct 9, 2015 by Kunal Kapoor

+1 vote

1 answer

Can we disable database trigger in Oracle, if yes then how?

posted Oct 20, 2014 by Vidhya Sagar

+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

+2 votes

1 answer

Can 2 functions have same name & input parameters but differ only by Return data type?

posted Dec 4, 2014 by Suchithra

0 votes

1 answer

Oracle materialized view - Daily Auto Refresh

posted Dec 14, 2015 by Sathaybama

+1 vote

1 answer

What is Save Points in Oracle database?

posted May 5, 2014 by Avinash Shukla

+2 votes

1 answer

Oracle: What view would you use to look at the size of a data file?

posted Apr 6, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: How can i change the password for my username?

posted Feb 10, 2015 by Archana

+1 vote

1 answer

OBIEE: What is a bridge table?

posted Aug 9, 2016 by Harsh Mayar

+2 votes

1 answer

How to Kill a session in Oracle?

posted May 5, 2015 by Kunal Kapoor

+1 vote

2 answers

Oracle: What is a Cartesian product?

posted Mar 9, 2015 by Suchithra

+2 votes

1 answer

oracle: Name a tablespace automatically created when you create a database

posted Apr 2, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: How can I get the difference between two date columns?

posted Feb 4, 2015 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

1 answer

How can one rename a column in a table in Oracle 8i?

posted Jun 24, 2015 by Archana

+2 votes

1 answer

Oracle: Name two files used for network connection to a database.

posted Apr 13, 2015 by Viswas Kumar

+2 votes

1 answer

How does a syntax error differ from a runtime error in Oracle SQL?

posted Nov 11, 2014 by Archana

+2 votes

1 answer

What is the difference between view and materalized view oracle?

posted Feb 14, 2014 by Prasad

+1 vote

1 answer

What are the types of Locks in Oracle SQL?

posted Sep 26, 2014 by Vidhya Sagar

+1 vote

1 answer

which table captures the information of all the Key FlexFields in Oracle Apps?

posted Nov 16, 2015 by Suchithra

+1 vote

1 answer

What is 1nf, 2nf and 3nf in oracle?

posted Aug 10, 2014 by anonymous

0 votes

1 answer

Oracle: can you alter synonym of view or view?

posted Jan 12, 2015 by Suchithra

0 votes

1 answer

What is Database Management System (DBMS) Package?

posted Sep 24, 2014 by Vidhya Sagar

+1 vote

2 answers

query to get calender in Oracle SQL

posted Sep 19, 2014 by Archana

+1 vote

1 answer

SQL & Pl/SQL are used in which of the following products SQL*plus, Oracle Forms and Oracle reports?

posted May 22, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: How do you add a data file to a tablespace?

posted Apr 3, 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

0 votes

1 answer

Oracle: sequence, currval and nextval ?

posted Jan 5, 2015 by Archana

+1 vote

2 answers

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

posted Feb 12, 2015 by Archana

0 votes

1 answer

Can database trigger written on synonym of a table?

posted Oct 6, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: What are CYCLE/NO CYCLE in a sequence?

posted Sep 3, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What are the advantages of VIEW?

posted Sep 7, 2015 by Suchithra

0 votes

1 answer

Oracle: How does one eliminate duplicates rows from a table with different methods?

posted Jun 17, 2015 by Vidhya Sagar

+2 votes

1 answer

How would you determine the time zone under which a database was operating In Oracle?

posted Mar 20, 2015 by Archana

0 votes

1 answer

Oracle: What are the pre-requisites to (i) modify data type of a column (ii) add a column with NOT NULL constraint?

posted Aug 31, 2015 by Suchithra

+1 vote

1 answer

what are Pre‐Defined Responsibilities in oracle apps?

posted Nov 5, 2015 by Viswas Kumar

+1 vote

1 answer

How you will avoid your query from using indexes in Oracle?

posted Jun 2, 2015 by Vidhya Sagar

0 votes

1 answer

How to create a complex view?

posted Sep 23, 2014 by Archana

0 votes

1 answer

what is different between ROWNUM and ROWID in oracle?

posted Aug 20, 2014 by Rathi