Recent posts under tag sql

0 votes

1 answer

What does TOP Operator Do in SQL?

posted Oct 1, 2015 by Sathyasree

0 votes

1 answer

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

posted Sep 30, 2015 by Sathaybama

0 votes

1 answer

What is a Scheduled Jobs or What is a Scheduled Tasks?

posted Sep 30, 2015 by Sathaybama

0 votes

1 answer

Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

posted Sep 30, 2015 by Sathaybama

+1 vote

1 answer

Oracle: What is a SYNONYM?

posted Sep 24, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is the difference between view and Snapshot?

posted Sep 24, 2015 by Viswas Kumar

+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

Oracle: What is a SNAPSHOT?

posted Sep 18, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: Can we create index on view?

posted Sep 17, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: Can a trigger written for a view?

posted Sep 17, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is the difference between view and table?

posted Sep 15, 2015 by Suchithra

0 votes

2 answers

Oracle: What is the difference between a View and Materialized View?

posted Sep 15, 2015 by Suchithra

+1 vote

1 answer

What is the function of 'force' in view?

posted Sep 10, 2015 by Viswas Kumar

0 votes

1 answer

If a View on a single base table is manipulated will the changes be reflected on the base table?

posted Sep 10, 2015 by Viswas Kumar

0 votes

1 answer

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

posted Sep 9, 2015 by Archana

0 votes

1 answer

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

posted Sep 9, 2015 by Archana

+1 vote

1 answer

Oracle: How to update COMPLEX VIEW?

posted Sep 8, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: What is the difference between SIMPLE and COMPLEX VIEWS?

posted Sep 8, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: What are the advantages of VIEW?

posted Sep 7, 2015 by Suchithra

0 votes

1 answer

Oracle: What is a view?

posted Sep 7, 2015 by Suchithra

0 votes

1 answer

Oracle: Consider a sequence whose currval is 1?

posted Sep 3, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What are CYCLE/NO CYCLE in a sequence?

posted Sep 3, 2015 by Viswas Kumar

0 votes

1 answer

oracle: What are the parameters in SEQUENCE?

posted Sep 1, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: What is a sequence?

posted Sep 1, 2015 by Vidhya Sagar

+1 vote

1 answer

What is the fastest way of accessing a row in a table?

posted Aug 31, 2015 by Suchithra

0 votes

1 answer

Oracle: What are the pre-requisites to (i) modify data type of a column (ii) add a column with NOT NULL constraint?

posted Aug 31, 2015 by Suchithra

+2 votes

1 answer

Oracle: What are the limitations for CHECK constraint?

posted Aug 27, 2015 by Viswas Kumar

+2 votes

1 answer

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

posted Aug 27, 2015 by Viswas Kumar

+2 votes

2 answers

Oracle: If a unique key constraint on DATE column is created, will it validate the rows that are inserted with sysdate?

posted Aug 21, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: Where the integrity constraints are stored in Data Dictionary?

posted Aug 21, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: What is ON DELETE CASCADE?

posted Aug 20, 2015 by Viswas Kumar

+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

ORACLE: What is CROSS JOIN?

posted Aug 19, 2015 by Archana

+1 vote

1 answer

Oracle: What is the difference between IN & Exist?

posted Aug 19, 2015 by Archana

+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

Oracle:Special operators used for sub query?

posted Aug 18, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: What are the Limitations of sub query?

posted Aug 17, 2015 by Suchithra

+1 vote

1 answer

What are set operator in oracle?

posted Aug 17, 2015 by Suchithra

+1 vote

1 answer

What is MERGE statement (9i)?

posted Aug 13, 2015 by Viswas Kumar

+1 vote

1 answer

What is the use of CUBE in Oracle?

posted Aug 13, 2015 by Viswas Kumar

+1 vote

EMS Developer at Airspan

posted Aug 13, 2015 by Sapna Mehta

+2 votes

2 answers

What is the difference between MAX () and GREATEST () Functions in Oracle?

posted Aug 12, 2015 by Archana

0 votes

1 answer

What is the use of CASE in Oracle?

posted Aug 12, 2015 by Archana

0 votes

1 answer

How do I write the query?

posted Aug 11, 2015 by Vidhya Sagar

0 votes

1 answer

What is the use of DECODE?

posted Aug 11, 2015 by Vidhya Sagar

+3 votes

1 answer

How will you log current collection’s SQL query?

posted Aug 11, 2015 by Vrije Mani Upadhyay

+3 votes

1 answer

What is the use of NULLIF in Oracle?

posted Aug 10, 2015 by Suchithra

+2 votes

1 answer

What is the use of NVL2 in Oracle?

posted Aug 10, 2015 by Suchithra

+2 votes

1 answer

What is the use of EXTRACT in Oracle?

posted Aug 5, 2015 by Archana

+2 votes

1 answer

What is the difference between COUNT (), COUNT (*) Functions in SQL?

posted Aug 5, 2015 by Archana