Most voted questions under tag sql

+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

What is cache in SSRS? What are types of SSRS?

posted Nov 4, 2015 by Amit Kumar Pandey

+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

How to find the number of records in a table without using count function?

posted Oct 6, 2015 by anonymous

+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

What are SQL Isolation levels and what is best for concurrency and avoiding deadlocks.

posted Jul 23, 2015 by Vrije Mani Upadhyay

+2 votes

0 answers

How SQL database stores Rows, Data pages, extents, in disk and memory?

posted Jul 23, 2015 by Vrije Mani Upadhyay

+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 default database in MangoDB?

posted Jul 13, 2015 by Amit Kumar Pandey

+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

please explain the Properties of adhoc query?

posted Jun 23, 2015 by Mohammed Hussain

+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

SQL Server Transactions and Error Handling

posted Jun 23, 2015 by Manikandan J

+2 votes

1 answer

What is the difference between SQL, PL-SQL and T-SQL?

posted Jun 23, 2015 by Manikandan J

+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

Update from one table to another table using SQL Server 2008

posted Jun 19, 2015 by Shivaranjini

+2 votes

1 answer

how to update table from select statement in sql server?

posted Jun 19, 2015 by Shivaranjini

+2 votes

2 answers

Deleting duplicate rows from a table.

posted Jun 16, 2015 by Manikandan J

+2 votes

1 answer

Finding TOP X records from each group.

posted Jun 16, 2015 by Manikandan J

+2 votes

1 answer

What is the default size of SQL Server Database

posted Jun 15, 2015 by Shivaranjini

+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

Difference between SQL(RDBMS) and mongoDB ?

posted Jun 2, 2015 by Alok

+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