Abhirup Roy

• Oct 27th, 2015

Hi.. Good question. Both the usage of standalone procedure or a packaged procedure have their own advantages and disadvantages. We generally create packaged procedure only when the other members of pa...

vinay

• Aug 11th, 2011

Use interfaces

Answer Question  Select Best Answer

Abhirup Roy

• Oct 27th, 2015

Yes, we can use any composite data type (record or collection) type inside a procedure as any other data types. However if the procedure is supposed to return values, we need to pass according to the procedure signature.

Answer Question  Select Best Answer

How to declare a variable with FLOAT (2 DECIMAL PLACES) in table creation in oracle?

Abhirup Roy

• Oct 27th, 2015

In PL/SQL, unlike other programming language like C, we do not have a FLOAT data type. Instead we have NUMBER(precision,scale) data type, which can be used for both INTEGER and FLOATING NUMBERS. Howev...

Answer Question  Select Best Answer

A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table. A  trigger  does  not  apply  to  data  loaded before the definition of the trigger,  therefore,  it does not guarantee all data in a table conforms to the rules established...

Chankey007

 Profile Answers by Chankey007 Questions by Chankey007

• Oct 26th, 2010

An integrity constraint defines a business rule for a table column which automatically takes care by Oracle internally. Intefrity Constraints are NOT NULL, UNIQUE, CHECK, PRIMARY KEY, FOREIGN KEY.?...

samiksc

 Profile Answers by samiksc Questions by samiksc

• Jan 19th, 2006

A trigger is a piece of code which gets automatically executed upon occurrence of an event. It may not be meant for enforcing integrity. For example you may want to save the user info as soon as he ma...

Answer Question  Select Best Answer

A Function returns a value to the caller where as a Procedure does not.

RPush

 Profile Answers by RPush Questions by RPush

• Aug 5th, 2010

Procedure executes as a part of PL/SQL block wherein Function invoked as part of expression.Function must have RETURN keyword in the header , which is not applicable for Procedure.Function must return...

sameer rokde

 Profile Answers by sameer rokde Questions by sameer rokde

• Aug 3rd, 2010

Procedure is to do specific task where as function is to compute values.Procedure may or may not return value at all, but function must return value.Function can be used in SQL statement but Procedure is not used.

Answer Question  Select Best Answer

sriatit

 Profile Answers by sriatit Questions by sriatit

• Oct 12th, 2009

You can check this by using translate function. If the return value is NULL then the input is a number else it  is character or alpha numeric.Ex:select ('abcd', '~0123456789', ...

PratikshaD

 Profile Answers by PratikshaD Questions by PratikshaD

• Jun 12th, 2009

You can use translate function.translate(,'~0123456789','~') will return null if the input is numeric. Not null if the input is alphanumeric.

Answer Question  Select Best Answer

Increased  functionality  (for  example,global  package  variables  can  be declared  and  used  by  any proecdure in the package) and performance (for example  all  objects  of  the package are parsed compiled, and loaded into memory once)

laxma823

 Profile Answers by laxma823 Questions by laxma823

• Jul 25th, 2008

Pakage having more advantages1)Modularity2)Easily application dision

Pankaj Gauba

• Sep 13th, 2006

Main advantage is OVERLOADING of function and procedures

Answer Question  Select Best Answer

A  Procedure consist of a set of SQL and PL/SQL statements that are grouped together  as a unit to solve a specific problem or perform a set of related tasks.  

Shubhra

• Sep 11th, 2007

Procedure is a named PL/SQL block?and a reusable database object which can accept multiple arguments, execute?PL/SQL statements, do exception handling?and return multiple results. Procedures?are stored and executed in the database.

Answer Question  Select Best Answer

hongynj

• Feb 28th, 2007

A forms trigger may do nothing more than change the focus to a new item or show a new canvas

Answer Question  Select Best Answer

Procedures and Functions,Packages and Database Triggers.  

A  Package  is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.

A Database Trigger is procedure (set of SQL  and PL/SQL statements) that is automatically  executed  as  a  result of an insert in,update to, or delete from a table.

Database  triggers  can  be  used  to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.