Most answered questions under tag sql

+1 vote

2 answers

What are the disadvantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+1 vote

2 answers

What are the advantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+1 vote

2 answers

Can some body give me some example of INSTEAD OF trigger?

posted Dec 2, 2014 by Archana

+2 votes

2 answers

What is a Result Set? when is it created?

posted Nov 18, 2014 by Archana

+1 vote

2 answers

Explain Implicit and Explicit cursors.

posted Nov 12, 2014 by Vidhya Sagar

+2 votes

2 answers

What is a primary key and why it is used?

posted Nov 12, 2014 by anonymous

+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

can any explain about SQL TRUNCATE TABLE?

posted Nov 5, 2014 by Archana

+1 vote

2 answers

What is Normalization in Oracle?

posted Oct 17, 2014 by Suchithra

+2 votes

2 answers

What is the difference between candidate key, unique key and primary key in Oracle?

posted Oct 9, 2014 by Suchithra

+1 vote

2 answers

In SQL how to INSERT, UPDATE or DELETE record in one statement

posted Oct 7, 2014 by Amit Kumar Pandey

+2 votes

2 answers

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

posted Oct 7, 2014 by Amit Kumar Pandey

0 votes

2 answers

how to write a query to select Nth row from a table in Oracle SQL?

posted Sep 22, 2014 by Archana

+1 vote

2 answers

query to get calender in Oracle SQL

posted Sep 19, 2014 by Archana

+2 votes

2 answers

how to write a query that results an pyramid structure in Oracle SQL

posted Sep 16, 2014 by Archana

+1 vote

2 answers

How to call DDL statements in Oracle PL/SQL

posted Sep 15, 2014 by Suchithra

+1 vote

2 answers

How to check the Leap Year using Function in Oracle SQL

posted Sep 15, 2014 by Archana

+2 votes

2 answers

What are the different types of JOINS in SQL and MYSQL?

posted Sep 14, 2014 by Nimish

+1 vote

2 answers

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

posted Sep 11, 2014 by Arun Gowda

0 votes

2 answers

How to search the '%' in a table?

posted Aug 18, 2014 by Ela

+2 votes

2 answers

How to wite an update query with table joins?

posted Aug 8, 2014 by Khusboo

0 votes

2 answers

What are SQL Views? How we can create them?

posted Aug 1, 2014 by Rahul Mahajan

0 votes

2 answers

How to Delete a Table using Join?

posted Jul 18, 2014 by Karamjeet Singh

+3 votes

2 answers

What is the difference between GROUP BY and ORDER BY in Sql/MySql?

posted May 7, 2014 by Sachin Dahda

+2 votes

2 answers

What Is Transact-SQL Language?

posted Feb 2, 2014 by Mona Sharma

+2 votes

1 answer

How to take SQLite dump ?

posted Nov 30, 2018 by anonymous

+2 votes

1 answer

How is natural join on table with itself is done, please explain with examples?

posted Jun 26, 2018 by anonymous

0 votes

1 answer

SQL: Display the list of employee who have joined the company before 30-jun-90 or 31-dec-90?

posted Jun 4, 2018 by Deepika Goutam

+1 vote

1 answer

What is the full form of SQL?

posted Mar 16, 2018 by Prasad Eksambekar

+1 vote

1 answer

What is SQL Warning? How to retrieve SQL warnings in the JDBC program?

posted Aug 17, 2017 by Kumar Neeraj

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

+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

+2 votes

1 answer

SQL database for android

posted Aug 16, 2016 by Akshay

+2 votes

1 answer

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

posted Apr 27, 2016 by Shivam Kumar Pandey

+1 vote

1 answer

How joiners will work without primary Key in MYSQL?

posted Mar 15, 2016 by Karthik Surya

+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

+2 votes

1 answer

Can someone explain how to write a SOQL query to get child custom object?

posted Mar 13, 2016 by Shivam Kumar Pandey

+5 votes

1 answer

How to Inserting data to ENUM type column in MySql

posted Mar 5, 2016 by Atindra Kumar Nath

+4 votes

1 answer

What is a Bind Variable in Oracle Reports6i?

posted Feb 4, 2016 by Suchithra

+3 votes

1 answer

What is a Lexical Parameter in Oracle Report6i?

posted Feb 4, 2016 by Suchithra

+1 vote

1 answer

How to set the values for existing Profile Options in Oracle Apps?

posted Dec 2, 2015 by Archana

+1 vote

1 answer

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

posted Dec 1, 2015 by Suchithra

0 votes

1 answer

what is PROFILES and its Option in Oracle Apps?

posted Dec 1, 2015 by Suchithra

0 votes

1 answer

what are the steps Required Invoke Key Flex Fields from the Form in oracle Apss?

posted Dec 1, 2015 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

0 votes

1 answer

what are the steps Required To Create a FIND WINDOW in Oracle Apps?

posted Nov 25, 2015 by Archana

+1 vote

1 answer

what are the SEARCH METHODS in Oracle Apps?

posted Nov 24, 2015 by Vidhya Sagar

+1 vote

1 answer

what are steps Required For Coding Non‐Form functions in Oracle Apps?

posted Nov 24, 2015 by Vidhya Sagar

+1 vote

1 answer

What are the steps required to Track WHO Information in our form in Oracle?

posted Nov 24, 2015 by Suchithra

+1 vote

1 answer

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

posted Nov 20, 2015 by Kunal Kapoor