Most viewed questions under tag sql

0 votes

1 answer

Oracle: What is the difference between alias and synonym?

posted Jan 14, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: What background process refreshes materialized views?

posted Mar 27, 2015 by Suchithra

+2 votes

2 answers

What’re the differences between SQL, MySQL, SQLite and mSQL?

posted Sep 10, 2018 by anonymous

+2 votes

1 answer

what are the Oracle database's physical and logical structure?

posted Jul 7, 2015 by Vidhya Sagar

+3 votes

1 answer

What is the difference between CAST and CONVERT in sql server?

posted Apr 28, 2014 by Muskan

0 votes

1 answer

what is PROFILES and its Option in Oracle Apps?

posted Dec 1, 2015 by Suchithra

+1 vote

1 answer

How to add Comments on table and columns in Oracle?

posted May 11, 2015 by Suchithra

+1 vote

3 answers

What are the Disadvantages of a CLUSTER?

posted Jul 22, 2015 by Archana

+3 votes

1 answer

How to write a query to find the weather string is Palindrome or not?

posted Sep 19, 2014 by Archana

+1 vote

2 answers

How to call DDL statements in Oracle PL/SQL

posted Sep 15, 2014 by Suchithra

+5 votes

1 answer

How to Inserting data to ENUM type column in MySql

posted Mar 5, 2016 by Atindra Kumar Nath

0 votes

1 answer

oracle: How does one code a matrix report in SQL?

posted Jun 22, 2015 by Suchithra

+1 vote

1 answer

how to update table using values of multiple columns from other tables in Oracle SQL

posted Sep 12, 2014 by Archana

+2 votes

2 answers

What Is Transact-SQL Language?

posted Feb 2, 2014 by Mona Sharma

+1 vote

2 answers

What is Deadlock in Oracle?

posted Jul 10, 2015 by Kunal Kapoor

+1 vote

1 answer

How joiners will work without primary Key in MYSQL?

posted Mar 15, 2016 by Karthik Surya

+3 votes

1 answer

Oracle: Give two methods you could use to determine what DDL changes have been made

posted Mar 31, 2015 by Archana

+1 vote

1 answer

what is DESCRIPTIVE FLEX FIELDS (DFF) and its types in Oracle Apps?

posted Nov 17, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: Can dual table be deleted, dropped or altered or updated or inserted?

posted Jan 19, 2015 by Archana

0 votes

3 answers

what is the difference between char , varchar and nvarchar in sql?

posted Jul 17, 2014 by Sanjay

+2 votes

1 answer

What is the Difference between a post query and a pre query?

posted Oct 20, 2014 by Suchithra

+2 votes

1 answer

Oracle: What are the limitations for CHECK constraint?

posted Aug 27, 2015 by Viswas Kumar

+1 vote

1 answer

How to delete duplicate records in MySQL or SQL?

posted Sep 5, 2014 by anonymous

+2 votes

1 answer

what are the constructs of a procedure, function or a package?

posted Dec 4, 2014 by Suchithra

+2 votes

1 answer

How to find the number of records in a table without using count function?

posted Oct 6, 2015 by anonymous

+1 vote

1 answer

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

posted Dec 2, 2015 by Archana

+2 votes

1 answer

How to delete duplicate rows from a table using a single query?

posted Aug 7, 2014 by Karamjeet Singh

+1 vote

2 answers

What are the advantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+1 vote

1 answer

what are Functions and its type in Oracle apps?

posted Nov 4, 2015 by Archana

+2 votes

3 answers

Can we have two primary keys in one table?

posted May 17, 2017 by Rohini Agarwal

+2 votes

1 answer

Oracle: What view would you use to determine free space in a tablespace?

posted Apr 6, 2015 by Vidhya Sagar

0 votes

0 answers

PL/SQL block which will populate the RESULTS table

posted Jun 27, 2014 by anonymous

+1 vote

1 answer

Oracle: Can a trigger written for a view?

posted Sep 17, 2015 by Viswas Kumar

+1 vote

2 answers

Oracle: which of the following is better to find the number of rows in a table?

posted Mar 9, 2015 by Suchithra

+4 votes

1 answer

how to check if table exist and if it doesnt exist create table in sql server 2008

posted May 9, 2014 by Muskan

+1 vote

1 answer

How does one Loop through tables in Oracle PL/SQL

posted Sep 15, 2014 by Suchithra

+1 vote

1 answer

What are constraining triggers in Oracle?

posted Dec 12, 2014 by Archana

0 votes

0 answers

Converting multiple rows to multiple columns in in informatica

posted Oct 18, 2017 by anonymous

0 votes

1 answer

What is the difference Rename and Alias in context of SQL/Oracle?

posted Jul 29, 2015 by Archana

+4 votes

1 answer

Debug a Stored Procedure..!!

posted Apr 1, 2014 by Khusboo

+3 votes

0 answers

How to convert c # inline queries into stored procedure written in transact sql?

posted May 8, 2014 by Khusboo

+3 votes

1 answer

can we register the table with Application Interface (API) in Oracle Apps?

posted Nov 10, 2015 by Vidhya Sagar

+2 votes

2 answers

What is the difference between the RANK() and DENSE_RANK() functions?

posted May 20, 2017 by Kushal S

+2 votes

1 answer

Oracle: What is the difference between snap shots and materialized views?

posted Sep 18, 2015 by Kunal Kapoor

+1 vote

1 answer

How does one select the TOP N rows from a table in Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

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

posted Aug 17, 2017 by Kumar Neeraj

+2 votes

1 answer

Oracle: Which date function returns number value?

posted Mar 17, 2015 by Archana

0 votes

1 answer

what is the Anonymous Block in PL/SQL?

posted Oct 8, 2015 by Viswas Kumar

+1 vote

1 answer

how to escape the ampersand character in Oracle PLSQL

posted Sep 12, 2014 by Vidhya Sagar

0 votes

2 answers

What is difference between self join vs inner join?

posted Jun 29, 2018 by anonymous