Most voted questions under tag oracle

+3 votes

1 answer

How to write a query to find the weather string is Palindrome or not?

posted Sep 19, 2014 by Archana

+3 votes

1 answer

How long will a variable remain defined in Sql Plus?

posted Sep 17, 2014 by Archana

+3 votes

1 answer

How to send data into file.txt from the database using W mode Oracle PLSQL

posted Sep 15, 2014 by Suchithra

+3 votes

1 answer

what are the SQL REPORTING COMMANDS in Oracle sql

posted Sep 15, 2014 by Arun Gowda

+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

+2 votes

0 answers

What is the relation among database, tablespace and datafile?

posted Jul 18, 2016 by Mohammed Hussain

+2 votes

2 answers

How the function security works in Oracle Apps?

posted Nov 24, 2015 by Suchithra

+2 votes

1 answer

what are the naming Conventions to be followed in the Forms Development in Oracle Apps?

posted Nov 18, 2015 by Archana

+2 votes

1 answer

what is APPCORE.PLL and CUSTOM.PLL in oracle Apps?

posted Nov 18, 2015 by Archana

+2 votes

1 answer

what are the steps to develop the NEW MODULE DEVELOPMENT in oracle Apps?

posted Nov 6, 2015 by Kunal Kapoor

+2 votes

1 answer

how to Create a User in oracle apps?

posted Oct 28, 2015 by Archana

+2 votes

1 answer

what is the File Architecture Oracle Apps?

posted Oct 28, 2015 by Archana

+2 votes

1 answer

What is difference between Index Seek vs. Index Scan?

posted Oct 27, 2015 by Shivaranjini

+2 votes

1 answer

What is use of EXCEPT clause? How it differs from NOT IN clause?

posted Oct 27, 2015 by Shivaranjini

+2 votes

1 answer

what are the Types of Docs in Oracle Apps?

posted Oct 27, 2015 by Vidhya Sagar

+2 votes

1 answer

what are the Predefined Exceptions in plsql?

posted Oct 9, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: What is the difference between snap shots and materialized views?

posted Sep 18, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: What are the limitations for CHECK constraint?

posted Aug 27, 2015 by Viswas Kumar

+2 votes

1 answer

ORACLE: What is created implicitly for every UNIQUE and PRIMARY KEY column?

posted Aug 27, 2015 by Viswas Kumar

+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

1 answer

Oracle: Where the integrity constraints are stored in Data Dictionary?

posted Aug 21, 2015 by Kunal Kapoor

+2 votes

1 answer

ORACLE: What is CROSS JOIN?

posted Aug 19, 2015 by Archana

+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 the use of NVL2 in Oracle?

posted Aug 10, 2015 by Suchithra

+2 votes

1 answer

What is the use of EXTRACT in Oracle?

posted Aug 5, 2015 by Archana

+2 votes

1 answer

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

posted Aug 5, 2015 by Archana

+2 votes

1 answer

What is the GRANT command with "WITH GRANT OPTION"?

posted Jul 31, 2015 by Kunal Kapoor

+2 votes

1 answer

What are the System and Object Privileges?

posted Jul 31, 2015 by Kunal Kapoor

+2 votes

1 answer

What is the use of INSERT ALL in SQL/Oracle?

posted Jul 27, 2015 by Suchithra

+2 votes

1 answer

What is difference between Update and Alter commands?

posted Jul 27, 2015 by Suchithra

+2 votes

1 answer

How Oracle identifies each record of Table uniquely?

posted Jul 17, 2015 by Kunal Kapoor

+2 votes

1 answer

What is a dynamic SQL?

posted Jul 16, 2015 by Viswas Kumar

+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 database link?

posted Jul 7, 2015 by Vidhya Sagar

+2 votes

1 answer

what are the Oracle database's physical and logical structure?

posted Jul 7, 2015 by Vidhya Sagar

+2 votes

1 answer

How can one drop a column from a table in Oracle 8i?

posted Jun 24, 2015 by Archana

+2 votes

1 answer

How does one implement IF-THEN-ELSE in a select statement?

posted Jun 23, 2015 by Vidhya Sagar

+2 votes

1 answer

How does one count different data values in a column In Oracle?

posted Jun 19, 2015 by Kunal Kapoor

+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

How to display employee number and names for employees who earn commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+2 votes

1 answer

How to display the names of all employees working as clerks and drawing a salary more than 3000?

posted Jun 9, 2015 by Vidhya Sagar

+2 votes

1 answer

Will non-procedural language specify what to do? or not how to do?

posted May 25, 2015 by Suchithra

+2 votes

1 answer

Is SQL is Procedural language?

posted May 21, 2015 by Viswas Kumar

+2 votes

1 answer

what is the advantages of partitioning in Oracle?

posted May 20, 2015 by Archana

+2 votes

1 answer

who found the principles of the relational model of database?

posted May 15, 2015 by Kunal Kapoor

+2 votes

1 answer

How to Kill a session in Oracle?

posted May 5, 2015 by Kunal Kapoor

+2 votes

1 answer

how to determine who is logged into Oracle?

posted May 5, 2015 by Kunal Kapoor

+2 votes

1 answer

How to determine the shared Pool Performance in Oracle?

posted May 5, 2015 by Vidhya Sagar

+2 votes

1 answer

What is SQL Language Extension?

posted Apr 29, 2015 by Archana

+2 votes

1 answer

what is Positional and Named Notation in Oracle?

posted Apr 29, 2015 by Archana