top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Question posted by archana

+2 votes
2 answers
Oracle: Any three PL/SQL Exceptions?
posted Mar 17, 2015
  • oracle
  • plsql
+2 votes
1 answer
Oracle: Which date function returns number value?
posted Mar 17, 2015
  • oracle
  • sql
+3 votes
1 answer
Oracle: how to display Odd/ Even number of records?
posted Mar 16, 2015
  • oracle
  • sql
+2 votes
1 answer
Oracle: How to display the number value in Words ?
posted Mar 16, 2015
  • oracle
  • sql
+1 vote
1 answer
How to display the records between two range of rownum in Oracle?
posted Mar 11, 2015
  • oracle
  • sql
+1 vote
1 answer
How do I display row number with records in Oracle?
posted Mar 11, 2015
  • oracle
  • sql
+1 vote
1 answer
How do I eliminate the duplicate rows in Oracle?
posted Mar 10, 2015
  • oracle
  • sql
+1 vote
1 answer
How to see current user name and to Change SQL prompt name in Oracle?
posted Mar 10, 2015
  • oracle
  • sql
+3 votes
0 answers
Oracle: Why is the query not fetching the records for the date I wanted?
posted Feb 13, 2015
  • oracle
  • sql
+2 votes
1 answer
Oracle: What do locks actually do?
posted Feb 13, 2015
  • oracle
  • sql
+1 vote
2 answers
Oracle: What is a dual table and why is it used?
posted Feb 12, 2015
  • sql
  • oracle
+1 vote
2 answers
Oracle: what is an oracle precompiler?
posted Feb 12, 2015
  • oracle
  • sql
+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
  • oracle
  • sql
+2 votes
1 answer
Oracle: How can i change the password for my username?
posted Feb 10, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: How can I get the difference between two date columns?
posted Feb 4, 2015
  • oracle
  • sql
0 votes
1 answer
What constraints will cause oracle to create default indexes?
posted Feb 4, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: "for update clause" and then using using "update?
posted Feb 2, 2015
  • sql
  • oracle
0 votes
1 answer
Can one read/write files from PL/SQL?
posted Feb 2, 2015
  • oracle
  • sql
+1 vote
1 answer
What is PL/SQL?
posted Jan 30, 2015
  • oracle
  • plsql
  • sql
+2 votes
1 answer
Interview question: Which of the following is not a schema object Oracle?
posted Jan 30, 2015
  • oracle
  • sql
+2 votes
1 answer
What are various types of joins in Oracle?
posted Jan 27, 2015
  • sql
  • oracle
0 votes
1 answer
Oracle: If I have an execute privilege on a procedure in another users schema?
posted Jan 27, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: What are actual and formal parameters?
posted Jan 22, 2015
  • sql
  • oracle
+1 vote
2 answers
What are the advantages of Oracle?
posted Jan 22, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: If content of dual is updated to some value computation takes place or not?
posted Jan 19, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: Can dual table be deleted, dropped or altered or updated or inserted?
posted Jan 19, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: What is the difference between a view and a synonym?
posted Jan 13, 2015
  • oracle
  • sql
+1 vote
2 answers
Oracle: When to create indexes?
posted Jan 9, 2015
  • oracle
  • sql
+1 vote
2 answers
Oracle: How can you avoid indexes?
posted Jan 9, 2015
  • oracle
  • sql
0 votes
1 answer
What are the disadvantages of SQL?
posted Jan 8, 2015
  • sql
  • oracle
0 votes
1 answer
Oracle: While designing in client/server what are the 2 imp. Things to be considered?
posted Jan 8, 2015
  • oracle
  • sql
0 votes
1 answer
RDBMS: What is Multi Threaded Server (MTA)?
posted Jan 6, 2015
  • rdbms
  • dbms
  • oracle
+1 vote
1 answer
Oracle: Definition of relational Database by Dr. Codd (IBM)?
posted Jan 6, 2015
  • oracle
  • sql
  • rdbms
0 votes
1 answer
Oracle: sequence, currval and nextval ?
posted Jan 5, 2015
  • oracle
  • sql
+1 vote
1 answer
Oracle: Is Sysdate a system variable or a system function?
posted Jan 5, 2015
  • oracle
  • sql
+1 vote
1 answer
Oracle: How many rows will the following SQL return?
posted Dec 31, 2014
  • oracle
  • sql
+1 vote
1 answer
Oracle: How many rows will the following SQL return?
posted Dec 31, 2014
  • oracle
  • sql
0 votes
1 answer
Oracle: Can you use %row count as a parameter to a cursor?
posted Dec 29, 2014
  • oracle
+1 vote
2 answers
Oracle: What are the various types of RollBack Segments?
posted Dec 29, 2014
  • sql
  • oracle
+2 votes
2 answers
Oracle: What is the significance of the &, and && operators in PL SQL?
posted Dec 24, 2014
  • oracle
  • sql
+2 votes
1 answer
Oracle: Is it possible to pass a parameter to a cursor?
posted Dec 24, 2014
  • sql
  • oracle
+1 vote
1 answer
When we use insert statement followd by a create table statement followed by rollback?
posted Dec 22, 2014
  • sql
  • oracle
+1 vote
1 answer
What are the states of a rollback segment? What is the difference between partly available and needs recovery in Oracle?
posted Dec 22, 2014
  • oracle
  • sql
0 votes
1 answer
Can null keys be entered in cluster index, normal index in Oracle?
posted Dec 18, 2014
  • oracle
  • sql
0 votes
1 answer
Can Long/Long RAW be clustered in Oracle?
posted Dec 18, 2014
  • oracle
  • sql
+1 vote
1 answer
What are constraining triggers in Oracle?
posted Dec 12, 2014
  • oracle
  • sql
+1 vote
1 answer
What are mutating triggers?
posted Dec 12, 2014
  • oracle
  • sql
+1 vote
1 answer
Oracle: Can you pass parameters in packages? If yes then how?
posted Dec 5, 2014
  • oracle
  • sql
+1 vote
1 answer
Why "create or Replace" but not the "drop and recreate" while creating procedures?
posted Dec 5, 2014
  • oracle
  • sql
+1 vote
1 answer
Can functions be over loaded?
posted Dec 3, 2014
  • oracle
  • sql
Page:
...