I.  done using Database triggers.          ii. done using Integarity Constraints. I & ii. Exception :

Srinatha Reddy

 Profile Answers by Srinatha Reddy Questions by Srinatha Reddy

• May 21st, 2008

create table a ( b number, c number check (c >100) );create or replace trigger t1 before insert on a begindbms_output.put_line('this is before insert trigger'); end;create or replace trigge...

prashant

• Jul 6th, 2006

 ii. done using Integarity Constraints

Answer Question  Select Best Answer

 SQLCODE returns the latest code of the error that has occurred.SQLERRM returns the relevant error message of the SQLCODE.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

• SQLCODE: Returns the numeric value for the error code• SQLERRM: Returns the message associated with the error numberSQLCODE Value          &nbs...

acpsrinivas

 Profile Answers by acpsrinivas Questions by acpsrinivas

• Feb 25th, 2006

Pl / Sql Provides Error Information via two Built-in functions, SQLCODE & SQLERRM.SQLCODE Returns the Current Error Code.            &nb...

Answer Question  Select Best Answer

 Function is called as part of an expression.   sal := calculate_sal ('a822');   procedure is called as a PL/SQL statement   calculate_bonus ('A822');

idonknowyou

 Profile Answers by idonknowyou Questions by idonknowyou

• May 22nd, 2007

Procedure can be called in the following waysa) CALL <procedure name> direcb) EXCECUTE <procedure name> from calling environmentc) <Procedure name> from other procedures or functions...

M.KUMARAN

• Nov 13th, 2005

Function is called as part of an expression.   sal := calculate_sal ('a822');   procedure is called as a PL/SQL statement   calculate_bonus ('A822');KKK

Answer Question  Select Best Answer

 The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema.Package  Body  contains  actual  procedures  and  local  declaration of the procedures and cursor declarations.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

A package usually has a specification and a body, stored separately in the database.The specification is the interface to your applications. It declares the types, variables, constants, exceptions, cu...

Mahesh Argade

• Jun 28th, 2006

In addition to this Both Package Spec and Package Body are stored separately in the Data basePackage specifications act as an interface for the Package

Answer Question  Select Best Answer

 User_objects, User_Source and User_error. 

idonknowyou

 Profile Answers by idonknowyou Questions by idonknowyou

• May 22nd, 2007

The Data dictionary tables/ Views where the characteristics of subprograms and Packages are stored are mentioned belowa) USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTSb) USER_SOURCE, ALL_SOURCE, DBA_SOURCEc) USER_DEPENCENCIESd) USER_ERRORS, ALL_ERRORS, DBA_ERRORS

vinod kumar

• Nov 16th, 2005

User_source , user_object , user_errors

Answer Question  Select Best Answer

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 15th, 2009

Sure, you can write plsql block inside exception.

Rupjit Roy

• Feb 23rd, 2006

Yes you can write PL/SQL block inside exception section. Suppose you want to insert the exception detail into your error log table, that time you can write insert into statement in exception part. To ...

Answer Question  Select Best Answer

Showstopper

 Profile Answers by Showstopper Questions by Showstopper

• Jun 21st, 2010

Begin for loopcounter in 1..10 loop dbms_output.put_line(loopcounter); end loop; end; / This piece of code will display the loopcounter in a PL/SQL loop on the screen

mekshi_2kk

 Profile Answers by mekshi_2kk Questions by mekshi_2kk

• Mar 6th, 2006

Using dbms_output.put_line(loop counter variable);

Answer Question  Select Best Answer

BASAVARAJ KOLUR

• Mar 9th, 2007

plsql supports mainly 3 types of collections    1> index by binary_integer    2> nested table    3>varrays index by binary_integer and nested...

Gupta

• Aug 7th, 2006

Types are Index -by- table, Nested Tables and Varray!

Answer Question  Select Best Answer

RoulRaj

• May 9th, 2007

Dear Rajeswaran,Please give one example(application) where one can use force view.Thanks & regards

Rajeshwaran

• Jun 3rd, 2006

usually the views are created from the basetable if only the basetable exists.The purpose of FORCE keyword is to create a view if the underlying base table doesnot exists.ex : create or replace FORCE ...

Answer Question  Select Best Answer

kamala kanta Parhi

• Oct 14th, 2006

select text from user_sourcewhere name='procedure_name';

D. Madhu

• Jun 29th, 2006

select * from user_objects where type='procedure' and name='function or procedure name'

Answer Question  Select Best Answer

sunflower

• Feb 22nd, 2007

DBMS_TRACE package can be used to keep track of the calls between the subprograms and trace of execution by sub-program, procedures, functions or an exception. It gives a large amount of trace da...

Jian Zhang

• Oct 10th, 2006

When you want to see the execute plan of a SQL statement, you need to use TRACE function of Oracle.

Answer Question  Select Best Answer

manish dudhe

• Oct 15th, 2007

Hi,User Ref cursor as out parameter in procand execute as belowsql>var s refcursorsql>exec demo_proc('manish',:s);sql>print s

Rama Krishna,TCS

• Aug 9th, 2006

Hi Mukund!!       You have to return the selected cursor as OUT parameter and again you have to fetch the data from that OUT cursor..Thanks&RegdsRamki

Answer Question  Select Best Answer

How to schedule an email in oracle reports?

KARI

• Oct 29th, 2011

UTL_MAIL: type procedure in UTL_MAIL 1)SEND (send the message without attachment) "plsql Begin UTL_MAIL.SEND(sender =>'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com'...

zahar

 Profile Answers by zahar Questions by zahar

• Jun 7th, 2011

Using utl_mail

Answer Question  Select Best Answer

How to know the current database name in PL/SQL?

Saravanan Govindan

• Jul 20th, 2011

Select name from v$database;

Code
SELECT name FROM v$database;

Saravanan Govindan

• Jul 20th, 2011

Select name from v$database;

Answer Question  Select Best Answer

 WHERE  CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

When referencing the current row from an explicit cursor, use the WHERE CURRENT OF clause. This allows you to apply updates and deletes to the row currently being addressed, without the need to explic...

Shefali

• Aug 16th, 2006

"WHERE CURRENT OF" clause is used for updating or deleting rows selected by the cursor with FOR UPDATE cluase.It explicitily locks the row for updating or deleting.

Answer Question  Select Best Answer

 The table columns are referred as OLD.column_name and NEW.column_name.For triggers related to INSERT only NEW.column_name values only available.For  triggers related to UPDATE only OLD.column_name NEW.column_name values only available.For triggers related to DELETE only OLD.column_name values only available.

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 6th, 2008

OLD and NEW are two virtual tables available during database trigger execution.UPDATE statement has access to  both old and new values.INSERT  statement has access only to new...

bambino_chakma

 Profile Answers by bambino_chakma Questions by bambino_chakma

• Jul 15th, 2007

The two virtual table available are old and new.

Answer Question  Select Best Answer

 The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error.      e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

Devendra Tawar

 Profile Answers by Devendra Tawar Questions by Devendra Tawar

• Apr 27th, 2011

Use for handle user defined exception.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

PRAGMA EXCEPTION_INIT statement associate the declared exception with the standard Oracle server error number. PRAGMA EXCEPTION_INIT tells the compiler to associate an exception name with an Oracle er...

Answer Question  Select Best Answer

       PROCEDURE name (parameter list.....)     is     local variable declarations      BEGIN          Executable statements.     Exception.     exception handlers      end;

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 6th, 2008

[CREATE [OR REPLACE]] PROCEDURE procedure_name[(Optional Parameters)] {IS | AS} [PRAGMA AUTONOMOUS_TRANSACTION;] [local declarations] BEGIN executable statements [EXCEPTION exception handlers] END [name];

KiranKW

 Profile Answers by KiranKW Questions by KiranKW

• May 3rd, 2007

Create or replace procedure proc_name (optional parameters)as beginexecutable statements;exception handlingend;end proc_name;

Answer Question  Select Best Answer

psingla

 Profile Answers by psingla Questions by psingla

• Apr 28th, 2010

PL/SQL is procedural language.It is built upon sql with extra added functionalities.It is used by ORACLE.robust and consistentexception handling is great the concept of package is greatdisallow bad co...

Yaseen

• May 12th, 2007

SQL (Structures Query Language)PL/SQL (Procedure Language / SQL) is the Oracle's version with lots of additional proprietary functions.T-SQL : Transact-SQL is Microsoft's proprietary version of SQL.

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

Application trigger: Fires whenever an event occurs with a particular application  Database trigger: Fires whenever a data event (such as DML) or system event (such as logon or shutdown) occurs on a schema or database

Sumit Tiwary

• May 2nd, 2007

Database triggers are backend triggeres and perform as any event occurs on databse level (ex. Inset,update,Delete e.t.c) wheras application triggers are froentend triggers and perform as any event taken on application level (Ex. Button Pressed, New Form Instance e.t.c)Rgds,Sumit Tiwary.

Answer Question  Select Best Answer