Most viewed questions under tag sql

+5 votes

1 answer

How to create a CSV file of any table by sql query in sql server?

posted Aug 3, 2015 by Mohammed Hussain

+1 vote

1 answer

How to display name and salary for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+2 votes

1 answer

How can we change the data type of a column of a table in SQL?

posted Mar 13, 2015 by Amit Kumar Pandey

+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

+2 votes

1 answer

How can I query parent to child with two child values and no other child values?

posted Mar 13, 2016 by Shivam Kumar Pandey

+1 vote

2 answers

how to Alter database archievelog in Oracle?

posted May 5, 2015 by Vidhya Sagar

0 votes

1 answer

What is SQL Trace and what are the steps for generating Trace file?

posted Oct 7, 2015 by Archana

+2 votes

1 answer

Update from one table to another table using SQL Server 2008

posted Jun 19, 2015 by Shivaranjini

+1 vote

2 answers

Oracle: What are the various types of RollBack Segments?

posted Dec 29, 2014 by Archana

0 votes

3 answers

How to get Second Maximum Salary in an Organization?

posted Jul 16, 2014 by Amanpreet Kaur

0 votes

1 answer

I want to install SQL Server database in my system and add this database to Informatica which has oracle already

posted Apr 28, 2014 by Pooja Bhanout

+3 votes

1 answer

Is it possible to get the SQL that would be generated, without running the mapping?

posted Mar 12, 2014 by Rohini Agarwal

+1 vote

1 answer

Oracle: Can you pass parameters in packages? If yes then how?

posted Dec 5, 2014 by Archana

+2 votes

1 answer

SQL: What is the use of CASCADE CONSTRAINTS?

posted Mar 25, 2014 by Deepak Chitragar

+3 votes

1 answer

What is the difference between Rollup ad cube?

posted Apr 3, 2015 by Santosh Kumar Panigrahi

+1 vote

1 answer

Explain materialized views and how they are used in Oracle?

posted Mar 26, 2015 by Archana

0 votes

1 answer

Oracle:Can database trigger written on synonym of a table?

posted Jan 12, 2015 by Suchithra

+2 votes

1 answer

How to read data in a table with "SELECT" statements ?

posted Feb 2, 2014 by Mona Sharma

+1 vote

2 answers

what is Value Set in Oracle Apps?

posted Nov 16, 2015 by Suchithra

+3 votes

1 answer

How long will a variable remain defined in Sql Plus?

posted Sep 17, 2014 by Archana

+2 votes

1 answer

ORACLE: What is created implicitly for every UNIQUE and PRIMARY KEY column?

posted Aug 27, 2015 by Viswas Kumar

0 votes

1 answer

Can Check constraint be used for self referential integrity? if Yes, How? In Oracle

posted Dec 19, 2014 by Suchithra

+2 votes

1 answer

How to list the tables from Schema with more than X rows in Oracle PLSQL

posted Sep 15, 2014 by Vidhya Sagar

0 votes

1 answer

what are the steps Required To Invoke Descriptive Flex Fields (DFF) in Oracle Apps?

posted Dec 1, 2015 by Vidhya Sagar

+3 votes

1 answer

what are Steps Required for registering a Table in oracle Apps?

posted Nov 10, 2015 by Vidhya Sagar

+1 vote

1 answer

Difference between PRIMARY KEY, UNIQUE KEY, CANDIDATE KEY? Where I have to use this?

posted Apr 30, 2015 by Nagaraj

+4 votes

1 answer

How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements ?

posted Feb 2, 2014 by Mona Sharma

+1 vote

2 answers

What do you understand by DDL and DML statements?

posted Aug 22, 2017 by Kumar Neeraj

+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

+2 votes

1 answer

Oracle: When a user process fails, what background process cleans up after it?

posted Mar 27, 2015 by Suchithra

+2 votes

2 answers

How to insert more than one record using a single insert statement?

posted Oct 7, 2014 by Amit Kumar Pandey

+1 vote

1 answer

What is the full form of SQL?

posted Mar 16, 2018 by Prasad Eksambekar

+1 vote

1 answer

How to escape special characters when building SQL queries?

posted Jun 15, 2015 by Suchithra

+1 vote

1 answer

Oracle: how to find out 9th highest salary from emp table?

posted Mar 13, 2015 by Suchithra

+1 vote

1 answer

Is there a PL/SQL Engine in SQL*Plus?

posted Feb 3, 2015 by Suchithra

+3 votes

1 answer

How to display the names of employees in Sql Query?

posted Jun 11, 2015 by Archana

+2 votes

1 answer

what are the Predefined Exceptions in plsql?

posted Oct 9, 2015 by Kunal Kapoor

+1 vote

1 answer

Find out nth highest salary from emp table in Oracle?

posted May 29, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: what is the command switch to DOS prompt from sql ?

posted Mar 12, 2015 by Suchithra

+4 votes

1 answer

Oracle: How would you determine what sessions are connected and what resources they are waiting for?

posted Mar 30, 2015 by Archana

+6 votes

1 answer

What is exact_abort in SQL Server?

posted Jan 4, 2014 by Atul Mishra

+1 vote

1 answer

When we set the Profile Options at all the 4 level in Oracle Apps?

posted Dec 1, 2015 by Suchithra

+2 votes

1 answer

Can 2 functions have same name & input parameters but differ only by Return data type?

posted Dec 4, 2014 by Suchithra

+1 vote

1 answer

What are the various types of Indexes in SQL/MySQL?

posted Sep 28, 2014 by anonymous

0 votes

2 answers

What is main feature of NULLIF Function in SQL?

posted Jul 1, 2015 by Amit Kumar Pandey

+2 votes

1 answer

Oracle: What view would you use to look at the size of a data file?

posted Apr 6, 2015 by Vidhya Sagar

+1 vote

2 answers

Oracle: What is a Cartesian product?

posted Mar 9, 2015 by Suchithra

+2 votes

1 answer

how to update table from select statement in sql server?

posted Jun 19, 2015 by Shivaranjini

+2 votes

1 answer

Oracle: How can i change the password for my username?

posted Feb 10, 2015 by Archana

+2 votes

1 answer

How to Kill a session in Oracle?

posted May 5, 2015 by Kunal Kapoor