top button
Flag Notify
    Connect to us
      Site Registration

Post under tag plsql
Site Registration

Recent posts under tag plsql

+3 votes
1 answer
In what order should a open/fetch/loop ...... %NOTFOUND cursor variable in the exit when statement? Why?
posted Oct 22, 2015 by Shivaranjini
  • sql
  • oracle
  • plsql
+3 votes
1 answer
What is the use of %ROWTYPE and %TYPE in PL/SQL?
posted Oct 22, 2015 by Shivaranjini
  • sql
  • oracle
  • plsql
+3 votes
1 answer
what are Package Specifications in plsql?
posted Oct 9, 2015 by Kunal Kapoor
  • plsql
  • sql
  • oracle
+2 votes
1 answer
what are the Predefined Exceptions in plsql?
posted Oct 9, 2015 by Kunal Kapoor
  • plsql
  • oracle
  • sql
+1 vote
1 answer
what are the Processing Explicit Cursors in plsql?
posted Oct 8, 2015 by Viswas Kumar
  • sql
  • oracle
  • plsql
0 votes
1 answer
what is the Anonymous Block in PL/SQL?
posted Oct 8, 2015 by Viswas Kumar
  • sql
  • oracle
  • plsql
+1 vote
1 answer
why Oracle’s procedural language is used for?
posted May 26, 2015 by Vidhya Sagar
  • sql
  • oracle
  • plsql
+1 vote
1 answer
which are the tools that allows direct and interactive use of the SQL language to access the Oracle server ?
posted May 22, 2015 by Kunal Kapoor
  • sql
  • oracle
  • plsql
+1 vote
1 answer
SQL & Pl/SQL are used in which of the following products SQL*plus, Oracle Forms and Oracle reports?
posted May 22, 2015 by Kunal Kapoor
  • oracle
  • sql
  • plsql
+2 votes
1 answer
Is SQL is Procedural language?
posted May 21, 2015 by Viswas Kumar
  • sql
  • oracle
  • plsql
+1 vote
1 answer
how to trap error in Plsql code?
posted Apr 28, 2015 by Vidhya Sagar
  • oracle
  • plsql
+3 votes
1 answer
what is PL/SQL Table?
posted Apr 23, 2015 by Viswas Kumar
  • plsql
  • oracle
+2 votes
1 answer
what is PL/SQL Record?
posted Apr 22, 2015 by Archana
  • oracle
  • sql
  • plsql
+3 votes
1 answer
Oracle: You have just compiled a PL/SQL package but got errors, how would you view the errors?
posted Apr 8, 2015 by Kunal Kapoor
  • sql
  • oracle
  • plsql
0 votes
Associate Software Engineer at Fidelity
posted Mar 23, 2015 by anonymous
+1 vote
1 answer
What are PL/SQL Cursor Exceptions?
posted Mar 18, 2015 by Vidhya Sagar
  • oracle
  • plsql
  • sql
+2 votes
2 answers
Oracle: Any three PL/SQL Exceptions?
posted Mar 17, 2015 by Archana
  • oracle
  • plsql
0 votes
Programmer Analyst at Oracle Corporation
posted Mar 2, 2015 by anonymous
+1 vote
1 answer
How can I protect my PL/SQL source code?
posted Feb 11, 2015 by Jayshree
  • plsql
+1 vote
1 answer
Is there a limit on the size of a PL/SQL block?
posted Feb 3, 2015 by Suchithra
  • sql
  • oracle
  • plsql
+1 vote
1 answer
Is there a PL/SQL Engine in SQL*Plus?
posted Feb 3, 2015 by Suchithra
  • sql
  • oracle
  • plsql
+1 vote
1 answer
What is PL/SQL?
posted Jan 30, 2015 by Archana
  • oracle
  • plsql
  • sql
0 votes
1 answer
What is Cursor ? Explain With Example?
posted Dec 4, 2014 by Amer
  • plsql
+2 votes
1 answer
What are the various types of parameter modes in a procedure in PLSQL ?
posted Dec 1, 2014 by Archana
  • sql
  • oracle
  • plsql
+3 votes
1 answer
Can we define exceptions twice in same block in PLSQL?
posted Dec 1, 2014 by Archana
  • sql
  • oracle
  • plsql
+1 vote
Java Developer at Oracle Corporation
posted Oct 8, 2014 by anonymous
+1 vote
1 answer
How we can create folders in SQLReport server dynamically?
posted Oct 3, 2014 by Amit Kumar Pandey
  • plsql
  • sql
+1 vote
1 answer
How we can use double quotes in dynamic SQL statements?
posted Oct 3, 2014 by Amit Kumar Pandey
  • plsql
  • sql
+3 votes
1 answer
How many types of Exceptions are there?
posted Oct 3, 2014 by Suchithra
  • oracle
  • plsql
+2 votes
1 answer
What is difference b/w stored procedures and application procedures, stored function and application function?
posted Sep 17, 2014 by Archana
  • oracle
  • plsql
+3 votes
1 answer
How to send data into file.txt from the database using W mode Oracle PLSQL
posted Sep 15, 2014 by Suchithra
  • sql
  • oracle
  • plsql
+1 vote
2 answers
How to call DDL statements in Oracle PL/SQL
posted Sep 15, 2014 by Suchithra
  • oracle
  • plsql
  • sql
+1 vote
1 answer
How does one Loop through tables in Oracle PL/SQL
posted Sep 15, 2014 by Suchithra
  • oracle
  • plsql
  • sql
+1 vote
2 answers
How to check the Leap Year using Function in Oracle SQL
posted Sep 15, 2014 by Archana
  • oracle
  • sql
  • plsql
+2 votes
1 answer
How to list the tables from Schema with more than X rows in Oracle PLSQL
posted Sep 15, 2014 by Vidhya Sagar
  • oracle
  • plsql
  • sql
+1 vote
1 answer
how to escape the ampersand character in Oracle PLSQL
posted Sep 12, 2014 by Vidhya Sagar
  • oracle
  • plsql
  • sql
+1 vote
1 answer
how to update table using values of multiple columns from other tables in Oracle SQL
posted Sep 12, 2014 by Archana
  • 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 by Archana
  • plsql
  • oracle
0 votes
1 answer
How we can create a table in PL/SQL block. insert records into it?
posted Aug 21, 2014 by Selvimohana
  • plsql
0 votes
1 answer
What is PRAGMA in PLSQL?
posted Aug 20, 2014 by Joshva
  • plsql
0 votes
1 answer
What will be the O/P for this coding?
posted Aug 20, 2014 by Rathi
  • plsql
+2 votes
Trigent is Looking for PLSQL developer.
posted Jun 19, 2014 by anonymous
+1 vote
1 answer
HOW PL/SQL GETS EXECUTED
posted Jun 17, 2014 by Swati Arora
  • plsql
+1 vote
1 answer
How can one see if somebody modified any code in pl sql?
posted Apr 6, 2014 by Neeraj Pandey
  • plsql
...