Recent posts under tag sql

+2 votes

1 answer

Oracle: What is nls_date_format?

posted Mar 3, 2015 by Vidhya Sagar

+2 votes

1 answer

Please help me to know if I can use WHERE and HAVING both in same query?

posted Mar 2, 2015 by Anamika

+3 votes

1 answer

how to find common columns in two tables?

posted Feb 23, 2015 by Muskan

+2 votes

1 answer

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

posted Feb 18, 2015 by Sathyasree

+4 votes

1 answer

Do the original table gets updated, if i update a view of that table?

posted Feb 16, 2015 by Merry

+3 votes

0 answers

Oracle: Why is the query not fetching the records for the date I wanted?

posted Feb 13, 2015 by Archana

+2 votes

1 answer

Oracle: What do locks actually do?

posted Feb 13, 2015 by Archana

+1 vote

2 answers

Oracle: What is a dual table and why is it used?

posted Feb 12, 2015 by Archana

+1 vote

2 answers

Oracle: what is an oracle precompiler?

posted Feb 12, 2015 by Archana

+2 votes

1 answer

If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted ?

posted Feb 11, 2015 by Jayshree

+2 votes

1 answer

Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ?

posted Feb 11, 2015 by Jayshree

+1 vote

1 answer

How does Oracle store the DATE datatype internally?

posted Feb 11, 2015 by Suchithra

+2 votes

2 answers

Oracle: How can I retrieve a specified number of highest- or lowest-value columns with a single query?

posted Feb 10, 2015 by Archana

+2 votes

1 answer

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

posted Feb 10, 2015 by Archana

+1 vote

1 answer

What is ROWNUM in Oracle?

posted Feb 9, 2015 by Suchithra

+1 vote

2 answers

Oracle: I want to use a view to update a table. Is it possible?

posted Feb 9, 2015 by Suchithra

0 votes

2 answers

Oracle: Why should I not commit after every record when updating a large table?

posted Feb 6, 2015 by Suchithra

0 votes

1 answer

How long will a variable remain defined in SQL Plus?

posted Feb 6, 2015 by Suchithra

0 votes

1 answer

Oracle: How can I get the difference between two date columns?

posted Feb 4, 2015 by Archana

0 votes

1 answer

What constraints will cause oracle to create default indexes?

posted Feb 4, 2015 by Archana

+1 vote

1 answer

Is there a limit on the size of a PL/SQL block?

posted Feb 3, 2015 by Suchithra

+1 vote

1 answer

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

posted Feb 3, 2015 by Suchithra

0 votes

1 answer

Oracle: "for update clause" and then using using "update?

posted Feb 2, 2015 by Archana

0 votes

1 answer

Can one read/write files from PL/SQL?

posted Feb 2, 2015 by Archana

+2 votes

1 answer

how we can retrieve the unique values for the in a table without using the DISTINCT keyword

posted Feb 1, 2015 by Garima Gupta

+1 vote

1 answer

How we can get nth max salary from Employee Table (EMP_ID, Salary)

posted Feb 1, 2015 by Garima Gupta

+2 votes

0 answers

JSP: What does mean of SQLWarning objects How to Retrieve Warnings?

posted Jan 31, 2015 by Amit Kumar Pandey

+1 vote

1 answer

What is PL/SQL?

posted Jan 30, 2015 by Archana

+2 votes

1 answer

Interview question: Which of the following is not a schema object Oracle?

posted Jan 30, 2015 by Archana

+1 vote

1 answer

What is implicit cursor and how is it used by Oracle?

posted Jan 29, 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

Oracle: insert a row & create another table.

posted Jan 28, 2015 by Suchithra

+1 vote

1 answer

What is a package cursor in oracle?

posted Jan 28, 2015 by Suchithra

0 votes

1 answer

What is fact table?

posted Jan 28, 2015 by anonymous

+2 votes

1 answer

What are various types of joins in Oracle?

posted Jan 27, 2015 by Archana

0 votes

1 answer

Oracle: If I have an execute privilege on a procedure in another users schema?

posted Jan 27, 2015 by Archana

0 votes

1 answer

Oracle: What all important parameters of the init.ora ,....., increase the SGA size?

posted Jan 23, 2015 by Suchithra

0 votes

1 answer

Oracle: What are the types of Notation?

posted Jan 23, 2015 by Suchithra

0 votes

1 answer

Oracle: What are actual and formal parameters?

posted Jan 22, 2015 by Archana

+1 vote

2 answers

What are the advantages of Oracle?

posted Jan 22, 2015 by Archana

0 votes

1 answer

Oracle: What is a forward declaration? What is its use?

posted Jan 21, 2015 by Vidhya Sagar

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

0 votes

1 answer

Oracle: For which relational operators in where clause, index is not used?

posted Jan 20, 2015 by Suchithra

0 votes

1 answer

Oracle: If any other tables same as dual were created would it act similar to dual?

posted Jan 20, 2015 by Suchithra

0 votes

1 answer

Oracle: If content of dual is updated to some value computation takes place or not?

posted Jan 19, 2015 by Archana

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

1 answer

Oracle: What is the difference between foreign key and reference key?

posted Jan 16, 2015 by Suchithra

0 votes

1 answer

Oracle: What's the length of SQL integer?

posted Jan 16, 2015 by Suchithra

+1 vote

1 answer

Oracle: What is the effect of synonym and table name used in same Select statement?

posted Jan 14, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: What is the difference between alias and synonym?

posted Jan 14, 2015 by Vidhya Sagar