Most answered questions under tag sql

+2 votes

3 answers

What is use for SQL Injection?

posted Jun 30, 2018 by Puneet Batra

+1 vote

3 answers

What is the use for CHECK constraint in SQL?

posted Jun 30, 2018 by anonymous

+2 votes

3 answers

Can we have two primary keys in one table?

posted May 17, 2017 by Rohini Agarwal

+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

+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

3 answers

what is the difference between char , varchar and nvarchar in sql?

posted Jul 17, 2014 by Sanjay

0 votes

3 answers

How to get Second Maximum Salary in an Organization?

posted Jul 16, 2014 by Amanpreet Kaur

+2 votes

3 answers

What is the difference between Primary Key and Unique Key?

posted May 5, 2014 by Sachin Dahda

+2 votes

2 answers

What’re the differences between SQL, MySQL, SQLite and mSQL?

posted Sep 10, 2018 by anonymous

0 votes

2 answers

What is difference between self join vs inner join?

posted Jun 29, 2018 by anonymous

+1 vote

2 answers

What is difference between java.util.Date and java.sql.Date?

posted Sep 19, 2017 by Pankaj Singh

+1 vote

2 answers

What do you understand by DDL and DML statements?

posted Aug 22, 2017 by Kumar Neeraj

+2 votes

2 answers

What is the difference between the RANK() and DENSE_RANK() functions?

posted May 20, 2017 by Kushal S

0 votes

2 answers

What does UNION do? What is the difference between UNION and UNION ALL?

posted May 20, 2017 by Kushal S

+1 vote

2 answers

Write a query to get max salary and second max salary in order in one query?

posted May 12, 2017 by Jdk

0 votes

2 answers

How to find the repeated rows in a SQL table?

posted Mar 12, 2016 by Aditi

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

0 votes

2 answers

What is main feature of NULLIF Function in SQL?

posted Jul 1, 2015 by Amit Kumar Pandey

+4 votes

2 answers

How sql server know when a query has to compile or not?

posted Jun 23, 2015 by Mohammed Hussain

+2 votes

2 answers

Deleting duplicate rows from a table.

posted Jun 16, 2015 by Manikandan J

+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

+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

+4 votes

2 answers

What is the difference between SQL, MySql, Sqlite, Sqlite3

posted Mar 10, 2015 by anonymous

+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

+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

how to truncate a whole database(tables with too many referential keys) in sqlserver?

posted Dec 19, 2014 by Muthumani