Most viewed questions under tag sql

+2 votes

1 answer

how to Create a User in oracle apps?

posted Oct 28, 2015 by Archana

0 votes

1 answer

What does TOP Operator Do in SQL?

posted Oct 1, 2015 by Sathyasree

+1 vote

1 answer

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

posted Aug 20, 2015 by Viswas Kumar

+2 votes

1 answer

How to create composite primary key in oracle/SQL?

posted Mar 7, 2015 by Varun Kumar

0 votes

1 answer

Oracle: Can views be specified in a trigger statement?

posted Dec 10, 2014 by Suchithra

+1 vote

1 answer

Why are joins used in Sql ? And what are the different types of joins in Sql ?

posted Apr 5, 2017 by Kushal S

+3 votes

1 answer

What is the use of %ROWTYPE and %TYPE in PL/SQL?

posted Oct 22, 2015 by Shivaranjini

0 votes

1 answer

Oracle: How can you find out View is updatable or not?

posted Sep 9, 2015 by Archana

+3 votes

1 answer

oracle: What does coalescing a tablespace do?

posted Apr 1, 2015 by Suchithra

+3 votes

1 answer

What is Diff between primary index and primary key in sql server

posted Dec 4, 2013 by Anuj Mishra

+2 votes

1 answer

Is it possbile to write files with MySQL via SQL injection?

posted Apr 27, 2016 by Shivam Kumar Pandey

+4 votes

1 answer

What is a Bind Variable in Oracle Reports6i?

posted Feb 4, 2016 by Suchithra

0 votes

2 answers

How to see what privileges received to user by owner user?

posted Jul 30, 2015 by Viswas Kumar

+2 votes

1 answer

Oracle: How to display the number value in Words ?

posted Mar 16, 2015 by Archana

+1 vote

1 answer

Oracle: How can you gather statistics on a table?

posted Apr 9, 2015 by Kunal Kapoor

+2 votes

1 answer

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

posted Jun 19, 2015 by Kunal Kapoor

0 votes

1 answer

Oracle: How can I get the time difference between two date columns?

posted Jun 17, 2015 by Archana

+4 votes

1 answer

How to fetch values from xml into table in sql

posted Mar 27, 2015 by Muskan

+1 vote

2 answers

Oracle: How can you avoid indexes?

posted Jan 9, 2015 by Archana

+1 vote

1 answer

Oracle: Can we create index on view?

posted Sep 17, 2015 by Viswas Kumar

0 votes

1 answer

Oracle: For which relational operators in where clause, index is not used?

posted Jan 20, 2015 by Suchithra

0 votes

1 answer

How we can delete duplicate rows in a table with no unique key in SQL server ?

posted Apr 6, 2017 by Snehal Raikar

+2 votes

1 answer

What is the use of NVL2 in Oracle?

posted Aug 10, 2015 by Suchithra

+1 vote

1 answer

How to display the records between two range of rownum in Oracle?

posted Mar 11, 2015 by Archana

+1 vote

1 answer

How does one code a matrix report in SQL using SUM & DECODE function?

posted May 29, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: How can I use a large rollback segment ( rblarge )to avoid the snapshot too old error ?

posted Mar 4, 2015 by Vidhya Sagar

0 votes

1 answer

Can you increase the size of a table space in Oracle? If yes then How?

posted Dec 15, 2014 by Suchithra

+1 vote

1 answer

Oracle: What is the difference b/w sub query and correlated sub query?

posted Aug 18, 2015 by Vidhya Sagar

+1 vote

1 answer

what are UTLBSTAT and UTLESTAT in Oracle?

posted Apr 30, 2015 by Viswas Kumar

+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

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

1 answer

How to change Line Size and Page Size and SQL Prompt?

posted Sep 24, 2014 by Archana

0 votes

1 answer

How to access SQL Server database in one host from informatica pc in another box

posted Jul 17, 2014 by Amit Sharma

+2 votes

1 answer

ORACLE: What is CROSS JOIN?

posted Aug 19, 2015 by Archana

+2 votes

1 answer

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

posted Jul 27, 2015 by Suchithra

0 votes

1 answer

Informatica using Oracle database

posted Apr 28, 2014 by Madhavi Kumari

+5 votes

1 answer

What is the meaning of Redo Log file mirroring in SQL?

posted Oct 19, 2015 by Shivaranjini

+2 votes

1 answer

how we can retrieve the unique values for the in a table without using the DISTINCT keyword

posted Feb 1, 2015 by Garima Gupta

+3 votes

1 answer

How can we restore a database when it showed as read only/suspect

posted May 24, 2014 by Neeraj Pandey

+2 votes

1 answer

How to access excel sheet data in Oracle database?

posted May 13, 2014 by Rakesh Singh

+1 vote

1 answer

Update a single table based on data from multiple tables SQL Server 2005,2008

posted Jun 30, 2015 by Shivaranjini

+3 votes

1 answer

SQL update from one Table to another based on a ID match

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

What is mixed mode authentication in sql server???

posted Mar 11, 2015 by Muskan

+1 vote

1 answer

Where in the Oracle directory tree structure are audit traces placed?

posted Mar 26, 2015 by Archana

+1 vote

2 answers

What is the use of CLUSTER?

posted Jul 22, 2015 by Archana

+2 votes

1 answer

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

posted Jun 23, 2015 by Manikandan J

+1 vote

1 answer

How do I eliminate the duplicate rows in Oracle?

posted Mar 10, 2015 by Archana

+2 votes

1 answer

Oracle: Below were the interview questions which was held by IBM.

posted Jan 2, 2015 by Suchithra

0 votes

1 answer

Oracle: Can a view be updated/inserted/deleted?

posted Sep 9, 2015 by Archana

+1 vote

1 answer

What are mutating triggers?

posted Dec 12, 2014 by Archana