Recent posts under tag oracle

+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

1 answer

Oracle: What is difference between SUBSTR and INSTR?

posted Feb 12, 2015 by Kali Mishra

+1 vote

1 answer

Oracle: How can we licence a Oracle product after installation?

posted Feb 12, 2015 by Amit Kumar Pandey

+2 votes

1 answer

Oracle: What is dev60cgi and f60cgi?

posted Feb 12, 2015 by Amit Kumar Pandey

+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

+1 vote

1 answer

How does Oracle store the DATE datatype internally?

posted Feb 11, 2015 by Suchithra

0 votes

1 answer

Oracle: What is a ROWID and Why do we need that?

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

+1 vote

1 answer

How Can i Store Image in Binary Format using Oracle 11g Database

posted Feb 3, 2015 by anonymous

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

+1 vote

1 answer

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

posted Feb 1, 2015 by Garima Gupta

+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

+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

+4 votes

1 answer

Explain the difference between a data block, an extent and a segment?

posted Jan 23, 2015 by Shivaranjini

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

0 votes

1 answer

Oracle: What is the difference between a view and a synonym?

posted Jan 13, 2015 by Archana

0 votes

1 answer

Oracle: Can you create index on view?

posted Jan 13, 2015 by Suchithra

0 votes

1 answer

Oracle: can you alter synonym of view or view?

posted Jan 12, 2015 by Suchithra

0 votes

1 answer

Oracle:Can database trigger written on synonym of a table?

posted Jan 12, 2015 by Suchithra