top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Question posted by archana

+1 vote
1 answer
What is Over Loading and what are its restrictions?
posted Dec 3, 2014
  • sql
  • oracle
+1 vote
1 answer
How can I get the source code for a function or a procedure or a package from the database?
posted Dec 2, 2014
  • oracle
  • sql
+1 vote
2 answers
Can some body give me some example of INSTEAD OF trigger?
posted Dec 2, 2014
  • sql
  • oracle
+2 votes
1 answer
Can you call a stored function in the constraint of a table?
posted Dec 1, 2014
  • sql
  • oracle
+2 votes
1 answer
What are the various types of parameter modes in a procedure in PLSQL ?
posted Dec 1, 2014
  • sql
  • oracle
  • plsql
+2 votes
1 answer
Can you have two functions with the same name in a PL/SQL block?
posted Dec 1, 2014
  • oracle
  • sql
+3 votes
1 answer
Can we define exceptions twice in same block in PLSQL?
posted Dec 1, 2014
  • sql
  • oracle
  • plsql
+1 vote
1 answer
What DBMS package should I use to manipulate the long column in Oracle 7
posted Nov 24, 2014
  • oracle
  • sql
+1 vote
1 answer
How does one get the value of a sequence into a PL/SQL variable?
posted Nov 24, 2014
  • oracle
  • sql
+1 vote
1 answer
Can one only retreive rows X to Y from a table?
posted Nov 18, 2014
  • oracle
  • sql
+2 votes
2 answers
What is a Result Set? when is it created?
posted Nov 18, 2014
  • sql
  • oracle
+4 votes
2 answers
What is Commit, Rollback and Savepoint in context of SQL/Oracle?
posted Nov 11, 2014
  • oracle
  • sql
+2 votes
1 answer
How does a syntax error differ from a runtime error in Oracle SQL?
posted Nov 11, 2014
  • oracle
  • sql
+1 vote
1 answer
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
posted Nov 11, 2014
  • oracle
+3 votes
1 answer
Explain three different rules that apply to NULLs when doing comparisons?
posted Nov 11, 2014
  • oracle
  • sql
+3 votes
1 answer
What special operators does Oracle provide for dealing with NULLs?
posted Nov 11, 2014
  • oracle
  • sql
+1 vote
1 answer
can anyone tell me about SQL tuning tips?
posted Nov 7, 2014
  • sql
  • oracle
+2 votes
1 answer
unable to connect to the DB using Taod ORA-12571 TNS packet writer failure
posted Nov 7, 2014
  • oracle
  • sql
+1 vote
2 answers
can any explain about SQL TRUNCATE TABLE?
posted Nov 5, 2014
  • oracle
  • sql
+3 votes
1 answer
can any one explain about SQL Unions Clause in detail ?
posted Nov 5, 2014
  • sql
  • oracle
+2 votes
1 answer
Is space acquired in blocks or extents in Oracle?
posted Oct 22, 2014
  • oracle
  • sql
+1 vote
1 answer
What are mutating tables in Oracle?
posted Oct 16, 2014
  • oracle
  • sql
+3 votes
1 answer
what is Physical Storage of the Data in Oracle?
posted Oct 14, 2014
  • oracle
  • sql
+5 votes
1 answer
what are Privileges and Grants in Oracle ??
posted Oct 10, 2014
  • oracle
  • sql
+1 vote
1 answer
How do you use the same lov for 2 columns?
posted Oct 6, 2014
  • oracle
+1 vote
2 answers
What is a Transaction in Oracle?
posted Sep 29, 2014
  • oracle
+1 vote
1 answer
What are the Back ground processes in Oracle and what are they?
posted Sep 29, 2014
  • oracle
+1 vote
1 answer
Tell me the function of Cache fusion in Oracle RAC?
posted Sep 25, 2014
  • oracle
  • oracle apps
+1 vote
1 answer
what are the steps to create new account combinations when dynamic insert option is not enabled in Oracleapps R12?
posted Sep 25, 2014
  • oracle
  • oracle apps
+1 vote
1 answer
How to change Line Size and Page Size and SQL Prompt?
posted Sep 24, 2014
  • sql
  • oracle
+1 vote
1 answer
What is the difference between SQL and SQL*PLUS?
posted Sep 24, 2014
  • sql
  • oracle
0 votes
1 answer
How to create a complex view?
posted Sep 23, 2014
  • sql
  • oracle
+2 votes
1 answer
How to update or insert row using single condition?
posted Sep 23, 2014
  • sql
  • oracle
0 votes
2 answers
how to write a query to select Nth row from a table in Oracle SQL?
posted Sep 22, 2014
  • sql
  • oracle
+3 votes
1 answer
How to write a query to find the weather string is Palindrome or not?
posted Sep 19, 2014
  • oracle
  • sql
+1 vote
2 answers
query to get calender in Oracle SQL
posted Sep 19, 2014
  • oracle
  • sql
+3 votes
1 answer
How long will a variable remain defined in Sql Plus?
posted Sep 17, 2014
  • oracle
  • sql
+2 votes
1 answer
What is difference b/w stored procedures and application procedures, stored function and application function?
posted Sep 17, 2014
  • oracle
  • plsql
+2 votes
2 answers
how to write a query that results an pyramid structure in Oracle SQL
posted Sep 16, 2014
  • oracle
  • sql
+1 vote
2 answers
How to check the Leap Year using Function in Oracle SQL
posted Sep 15, 2014
  • oracle
  • sql
  • plsql
+1 vote
1 answer
how to update table using values of multiple columns from other tables in Oracle SQL
posted Sep 12, 2014
  • oracle
  • plsql
  • sql
+1 vote
2 answers
how to get number of rows updated by an UPDATE statement in Oracle PL/SQL
posted Sep 12, 2014
  • plsql
  • oracle
Page:
...