Most viewed questions under tag sql

+1 vote

1 answer

What's the difference between materialized and dynamic view?

posted Nov 16, 2015 by anonymous

0 votes

1 answer

Oracle: What is the difference between a view and a synonym?

posted Jan 13, 2015 by Archana

+3 votes

3 answers

How many columns can table have in Oracle?

posted Oct 21, 2014 by Vidhya Sagar

+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

+1 vote

1 answer

Oracle: What is the difference between view and Snapshot?

posted Sep 24, 2015 by Viswas Kumar

+2 votes

2 answers

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

posted Dec 24, 2014 by Archana

+1 vote

1 answer

What are the states of a rollback segment? What is the difference between partly available and needs recovery in Oracle?

posted Dec 22, 2014 by Archana

+6 votes

1 answer

How to change multiple column datatype in SQL Server single query.

posted Apr 1, 2015 by Khusboo

0 votes

1 answer

how to write a query to get the matrix report in Oracle SQL?

posted Sep 22, 2014 by Vidhya Sagar

0 votes

1 answer

What is the difference between PRIVATE AND PUBLIC SYNONYM?

posted Oct 5, 2015 by Suchithra

+2 votes

2 answers

How the function security works in Oracle Apps?

posted Nov 24, 2015 by Suchithra

0 votes

1 answer

Oracle: What is a forward declaration? What is its use?

posted Jan 21, 2015 by Vidhya Sagar

+1 vote

1 answer

what are the Steps required to defining the Calendar in Oracle Apps?

posted Nov 20, 2015 by Kunal Kapoor

+2 votes

1 answer

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

posted Nov 18, 2015 by Archana

+1 vote

1 answer

How to write a sql statement to find the first occurrence of a non zero value?

posted Jun 17, 2014 by Rajni

+1 vote

1 answer

If we delete the base table whether the synonym will exists or not?

posted Oct 5, 2015 by Suchithra

+1 vote

1 answer

How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

posted Jul 14, 2015 by Vidhya Sagar

+3 votes

1 answer

Difference between TRUNCATE, DELETE and DROP commands?

posted Oct 27, 2014 by anonymous

0 votes

2 answers

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

posted Sep 15, 2015 by Suchithra

+2 votes

1 answer

What is the maximum number of triggers, can apply to a single table in Oracle?

posted Mar 20, 2015 by Archana

+1 vote

1 answer

Oracle: What is the difference between view and table?

posted Sep 15, 2015 by Suchithra

+4 votes

2 answers

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

posted Apr 1, 2015 by Suchithra

+3 votes

1 answer

Oracle: how to display Odd/ Even number of records?

posted Mar 16, 2015 by Archana

+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

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

posted Sep 19, 2017 by Pankaj Singh

+2 votes

1 answer

Oracle: Name three advisory statistics you can collect.

posted Mar 25, 2015 by Suchithra

+1 vote

2 answers

How to add column in existing oracle table with not null constraint

posted Sep 11, 2014 by Arun Gowda

+1 vote

2 answers

What are the disadvantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

0 votes

0 answers

How to call sql server stored procedure in codeigniter?

posted Jun 21, 2016 by anonymous

+3 votes

1 answer

Explain three different rules that apply to NULLs when doing comparisons?

posted Nov 11, 2014 by Archana

+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

+1 vote

1 answer

Oracle: A table has the following data : [5, Null, 10]. What will the average function return?

posted Jan 2, 2015 by Suchithra

+2 votes

1 answer

What are the various types of parameter modes in a procedure in PLSQL ?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

What is the difference between static and dynamic LOV?

posted Oct 7, 2014 by Vidhya Sagar

+1 vote

1 answer

Converting the time column SQL server to timestamp column in oracle using Informatica

posted Jun 18, 2014 by anonymous

+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

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

3 answers

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

posted Aug 19, 2014 by Joshva

+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

1 answer

How to take SQLite dump ?

posted Nov 30, 2018 by anonymous

+1 vote

1 answer

Is there a limit on the size of a PL/SQL block?

posted Feb 3, 2015 by Suchithra

+1 vote

1 answer

How to display data Page Wise in SQL?

posted Jul 3, 2015 by Kunal Kapoor

+2 votes

1 answer

Joining null in SQL Server, Oracle and informatica?

posted Mar 21, 2014 by Madhavi Kumari

+1 vote

1 answer

How to display the name and job for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: What is the difference between the SQL*Loader and IMPORT utilities?

posted Apr 13, 2015 by Viswas Kumar

+1 vote

1 answer

Display employee number and total salary for each employee in Oracle?

posted Jun 9, 2015 by Suchithra

+3 votes

1 answer

Oracle: You have just compiled a PL/SQL package but got errors, how would you view the errors?

posted Apr 8, 2015 by Kunal Kapoor

+2 votes

1 answer

Difference between SQL(RDBMS) and mongoDB ?

posted Jun 2, 2015 by Alok

+1 vote

2 answers

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

posted Dec 19, 2014 by Muthumani

+1 vote

1 answer

Oracle: How would you determine who has added a row to a table?

posted Apr 7, 2015 by Viswas Kumar