Most viewed questions under tag sql

+3 votes

1 answer

can any one explain about SQL Unions Clause in detail ?

posted Nov 5, 2014 by Archana

+1 vote

1 answer

Oracle: How many rows will the following SQL return?

posted Dec 31, 2014 by Archana

+1 vote

1 answer

what are the Applications Storages Tables in Oracle Apps?

posted Nov 13, 2015 by Kunal Kapoor

+2 votes

1 answer

What is database link?

posted Jul 7, 2015 by Vidhya Sagar

+3 votes

1 answer

SQL Server - Update column from data in the same table

posted Jun 19, 2015 by Manikandan J

0 votes

1 answer

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

posted Jul 29, 2015 by Archana

+2 votes

1 answer

What is Change Data Capture (CDC) in SQL Server 2008?

posted Sep 10, 2014 by Muskan

0 votes

1 answer

Oracle: Assume that there are multiple databases running on one machine. How can you switch from one to another?

posted Jan 21, 2015 by Vidhya Sagar

+1 vote

1 answer

What command would you use to encrypt a PL/SQL application?

posted Mar 24, 2015 by Vidhya Sagar

+2 votes

1 answer

What are various types of joins in Oracle?

posted Jan 27, 2015 by Archana

+1 vote

2 answers

What are the advantages of Oracle?

posted Jan 22, 2015 by Archana

+2 votes

1 answer

what is clustered index in Oracle?

posted Oct 22, 2014 by Vidhya Sagar

+1 vote

1 answer

What is the Code Combination ID of KFF is GGC_GM_VS1_1 in Oracle Apps?

posted Nov 16, 2015 by Suchithra

+2 votes

1 answer

Oracle:If a transaction is very large..will the transaction span across different rollback segments

posted Dec 30, 2014 by Arun Gowda

+2 votes

2 answers

How to wite an update query with table joins?

posted Aug 8, 2014 by Khusboo

+1 vote

1 answer

SQL: Need help with Multiple Joins of Tables?

posted Jun 16, 2015 by Shivaranjini

+2 votes

1 answer

what is PL/SQL Record?

posted Apr 22, 2015 by Archana

+2 votes

1 answer

How can one drop a column from a table in Oracle 8i?

posted Jun 24, 2015 by Archana

0 votes

1 answer

Can null keys be entered in cluster index, normal index in Oracle?

posted Dec 18, 2014 by Archana

0 votes

1 answer

How can we count and identify duplicate records in a table?

posted Sep 5, 2014 by Amit Kumar Pandey

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

+2 votes

1 answer

What is use of EXCEPT clause? How it differs from NOT IN clause?

posted Oct 27, 2015 by Shivaranjini

+3 votes

1 answer

what are Package Specifications in plsql?

posted Oct 9, 2015 by Kunal Kapoor

+2 votes

1 answer

What is difference between Index Seek vs. Index Scan?

posted Oct 27, 2015 by Shivaranjini

+2 votes

1 answer

Oracle: How do you resize a data file?

posted Apr 3, 2015 by Suchithra

0 votes

1 answer

How to create and load oracle tables from Excel sheet?

posted Aug 19, 2014 by Joshva

+1 vote

1 answer

Oracle: What are the Limitations of sub query?

posted Aug 17, 2015 by Suchithra

+1 vote

1 answer

What are the various types of queries in SQL?

posted Jan 29, 2015 by Suchithra

+1 vote

1 answer

How an Implicit cursor works?

posted Nov 12, 2014 by Vidhya Sagar

+2 votes

1 answer

What is the use of EXTRACT in Oracle?

posted Aug 5, 2015 by Archana

+4 votes

1 answer

Oracle: Describe what redo logs are?

posted Mar 30, 2015 by Archana

+1 vote

1 answer

Oracle:Special operators used for sub query?

posted Aug 18, 2015 by Vidhya Sagar

+3 votes

1 answer

What special operators does Oracle provide for dealing with NULLs?

posted Nov 11, 2014 by Archana

+1 vote

1 answer

Update MySql values with it's current value in php?

posted Jun 15, 2014 by Vrije Mani Upadhyay

+2 votes

1 answer

CTE vs Temp Tables

posted Jul 5, 2014 by Khusboo

+1 vote

1 answer

How does one put a database into ARCHIVELOG mode (for Oracle)?

posted May 10, 2014 by Kali Mishra

+1 vote

1 answer

How to see current user name and to Change SQL prompt name in Oracle?

posted Mar 10, 2015 by Archana

0 votes

2 answers

How to Delete a Table using Join?

posted Jul 18, 2014 by Karamjeet Singh

+4 votes

1 answer

Please let me know the query to update this

posted Jun 18, 2015 by Shivaranjini

+2 votes

1 answer

What is lock escalation?

posted Oct 29, 2014 by Vidhya Sagar

+1 vote

1 answer

Oracle: How many rows will the following SQL return?

posted Dec 31, 2014 by Archana

0 votes

1 answer

SQL code generation from table-free boolean queries?

posted Jun 26, 2013 by anonymous

+1 vote

1 answer

How to Create a User and what are the tables that the information in Oracle Apps?

posted Nov 6, 2015 by Kunal Kapoor

+1 vote

1 answer

How can I do an UPDATE statement with JOIN in SQL?

posted Jun 30, 2015 by Shivaranjini

+1 vote

1 answer

What are the min. extents allocated to a rollback extent in Oracle?

posted Dec 19, 2014 by Suchithra

+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 tables that captures the information of all the flex fields structures and Segments in Oracle Apps?

posted Nov 17, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: Can you create index on view?

posted Jan 13, 2015 by Suchithra

+3 votes

1 answer

Search Informatica for text in SQL override

posted Oct 7, 2014 by Amit Sharma

+1 vote

0 answers

When we call the Built‐In, it will first searches at User Level in Oracle Apps?

posted Dec 2, 2015 by Archana