Most viewed questions under tag sql

+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

1 answer

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

posted Jun 24, 2015 by Archana

+1 vote

1 answer

What are the types of Locks in Oracle SQL?

posted Sep 26, 2014 by Vidhya Sagar

+2 votes

1 answer

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

posted Apr 13, 2015 by Viswas Kumar

+1 vote

2 answers

What is the maximum no. of columns a table can have in Oracle ?

posted Dec 23, 2014 by Suchithra

+2 votes

1 answer

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

posted Nov 11, 2014 by Archana

+1 vote

1 answer

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

posted Nov 16, 2015 by Suchithra

+2 votes

1 answer

What Are the Differences between CHAR and VARCHAR ?

posted Feb 2, 2014 by Mona Sharma

0 votes

1 answer

Oracle: can you alter synonym of view or view?

posted Jan 12, 2015 by Suchithra

0 votes

2 answers

How to find the repeated rows in a SQL table?

posted Mar 12, 2016 by Aditi

+1 vote

2 answers

query to get calender in Oracle SQL

posted Sep 19, 2014 by Archana

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

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

+3 votes

1 answer

How do I install the MySQLdb under python programming?

posted Mar 26, 2015 by Amit Kumar Pandey

0 votes

1 answer

Oracle: sequence, currval and nextval ?

posted Jan 5, 2015 by Archana

0 votes

1 answer

What are the types of SQL GROUP BY Clause?

posted Sep 14, 2014 by Nimish

+2 votes

2 answers

Deleting duplicate rows from a table.

posted Jun 16, 2015 by Manikandan J

+3 votes

1 answer

What is open query in sql server?

posted Apr 8, 2015 by Muskan

0 votes

2 answers

What are SQL Views? How we can create them?

posted Aug 1, 2014 by Rahul Mahajan

+1 vote

1 answer

Oracle: What are the advantages of VIEW?

posted Sep 7, 2015 by Suchithra

+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

+1 vote

2 answers

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

posted Feb 12, 2015 by Archana

+2 votes

1 answer

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

posted Nov 4, 2015 by Amit Kumar Pandey

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

+3 votes

1 answer

What is the difference between CHAR, VARCHAR, VARCHAR2 data types?

posted Jul 15, 2015 by Archana

+1 vote

1 answer

What are PL/SQL Cursor Exceptions?

posted Mar 18, 2015 by Vidhya Sagar

+1 vote

1 answer

what are Pre‐Defined Responsibilities in oracle apps?

posted Nov 5, 2015 by Viswas Kumar

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

0 votes

1 answer

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

posted Jun 17, 2015 by Vidhya Sagar

0 votes

1 answer

How to create a complex view?

posted Sep 23, 2014 by Archana

+1 vote

1 answer

what are the type of table Suffixes and their meaning in Oracle Apps?

posted Nov 13, 2015 by Kunal Kapoor

+1 vote

1 answer

How to Create a Responsibility and in which it stores the data in Oracle Apps?

posted Nov 5, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: How does one count/sum RANGES of data values in a column?

posted Jun 19, 2015 by Kunal Kapoor

+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

What is RESPONSIBILITIES in Oracle apps?

posted Nov 4, 2015 by Archana

+2 votes

1 answer

Please explain CTE (Common Table Expressions) with a simple example?

posted Jun 23, 2014 by Muskan

+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

+1 vote

1 answer

Oracle: What is a SYNONYM?

posted Sep 24, 2015 by Viswas Kumar

0 votes

1 answer

How long will a variable remain defined in SQL Plus?

posted Feb 6, 2015 by Suchithra

0 votes

1 answer

What is a Scheduled Jobs or What is a Scheduled Tasks?

posted Sep 30, 2015 by Sathaybama

+1 vote

1 answer

Oracle: How does one add a day/hour/minute/second to a date value?

posted Jun 17, 2015 by Archana

+1 vote

1 answer

How can I view the dependencies of a PL/SQL block?

posted Nov 19, 2014 by Suchithra

+1 vote

1 answer

What is database link in Oracle SQL?

posted Sep 26, 2014 by Vidhya Sagar

0 votes

1 answer

Oracle: What are actual and formal parameters?

posted Jan 22, 2015 by Archana

+1 vote

1 answer

what is FLEXFIELDS in Oracle Apps?

posted Nov 13, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is a CONSTRAINT? What are its various levels?

posted Aug 20, 2015 by Viswas Kumar