How to call a PL/SQL function in another PL/SQL function? Is it possible? Give example?

Jirange

 Profile Answers by Jirange Questions by Jirange

• Nov 7th, 2008

Eg,create or replace fun_1 return varchar2asddmmyy varchar2;beginselect sysdate into ddmmyy from dual;end fun1;in above example function fun_1 calling another function (i.e. sysdate) thro' select statement. this way you can call any function in pl/sql function

Answer Question  Select Best Answer

How to send Email via PL/SQL Procedure?

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Nov 24th, 2008

rem -----------------------------------------------------------------------rem Filename:   smtp.sqlrem Purpose:    Send e-mail messages from PL/SQLrem Notes:   ...

Answer Question  Select Best Answer

While tuning SQL query what should be taken into consideration?

edarasatish

 Profile Answers by edarasatish Questions by edarasatish

• Jun 23rd, 2009

During the SQL tuning, there couple of things need to be considered1. If it is below Oracle 9i we need make sure about the driving table concept (Since it uses RBO - Rule Based Optimization), which im...

Answer Question  Select Best Answer

What Is BulkBind? When it is used?

saishradha

 Profile Answers by saishradha Questions by saishradha

• Nov 27th, 2008

Bulk Bind is the facilty through which we can INSERT, UPDATE, DELETE or SELECT from records from a table in bulk rather than multiple individual statments..Suppose you have 10 inserts to be made so yo...

Answer Question  Select Best Answer

When we insert new values into the table using loops. Is it going to be auto commit or do we need to commit manually?

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Mar 19th, 2009

All the DML statement requires manual commit where as DDL statements are autocommitted.

Answer Question  Select Best Answer

How to call a Procedure in Trigger and if any exception occurs in trigger then How do we rollback it?

Ayaz Uddin

• Nov 20th, 2014

Create or replace trigger trg
after insert on emp
for each row
begin
myproc(:new.empno, :new.ename);
end;

Answer Question  Select Best Answer

How to access cursor output from web application and present the record set in tabular form?

ace1234567

 Profile Answers by ace1234567 Questions by ace1234567

• Mar 4th, 2015

Using ref cursor and returning output in the plsql table we can return the result in tabular format.

Answer Question  Select Best Answer

How to select multiple data from different tables which do not have related constraints?

bhagavatula

 Profile Answers by bhagavatula Questions by bhagavatula

• Dec 10th, 2009

It is not necessary to have 'related constraints' between tables to retrieve data from multiple tables.  However, there should be a logic to associate data between the tables (related data) based on which you can select information from multiple tables

Answer Question  Select Best Answer

If you have to call same piece of code at many places in a package, How do you achieve this without calling the function many times?

kanchanG

 Profile Answers by kanchanG Questions by kanchanG

• Jul 7th, 2010

We can use 'Go To' statement in this case.

Answer Question  Select Best Answer

How to query nested table column of a table without using table function?

Pooja

• Sep 3rd, 2012

There are two general ways to query a table that contains a collection type as a column or attribute. Nest the collections in the result rows that contain them. Distribute or unnest collections so t...

Answer Question  Select Best Answer

What are the advantage of Synonym in PL/SQL

mukesh1009

 Profile Answers by mukesh1009 Questions by mukesh1009

• Jul 9th, 2010

Dear Kanchan Maheshwari There are two categories of synonyms, public and private. A public synonym can be accessed by any system user. The individual creating a public synonym does not own the sy...

Answer Question  Select Best Answer

What is the use of a package without body?

Gaurav_Vashishtha

 Profile Answers by Gaurav_Vashishtha Questions by Gaurav_Vashishtha

• Jul 27th, 2010

Package without body is used to declare global cursors and constants which can be used by other function, procedures or packages

Answer Question  Select Best Answer

How does index work? How to check whether Index is pickup?

z_ashwini

 Profile Answers by z_ashwini Questions by z_ashwini

• Jan 13th, 2012

Indexes are created for better performance of the DB ; for faster retrival of data from DB. There are diffierent types of indexes... (1) B tree index (2) Bitmap map index (3) Function based index (4) ...

Answer Question  Select Best Answer

Suppose a programmer creates a user defined exception handler Invalid_Number in declare block with type EXCEPTION and raise this exception in begin block. Then how will you access the user defined exception and same system defined exception (i.e Inavlid_Number)

promisinganuj

 Profile Answers by promisinganuj Questions by promisinganuj

• Feb 10th, 2011

The system defined exceptions in Oracle are tied to Oracle error codes. For this case, system defined error INVALID_NUMBER is tied with error code -01722.Now, when a user defines the sa...

Answer Question  Select Best Answer

How to call an external-procedure from a package?

manju_kambar

 Profile Answers by manju_kambar Questions by manju_kambar

• Sep 13th, 2014

Calling procedure from other package should have following format

package_name.procedure_name;

if you are calling package in other schema, you need to create synonyms for that particular

Answer Question  Select Best Answer

mailtonagaraja

 Profile Answers by mailtonagaraja Questions by mailtonagaraja

• Mar 24th, 2011

Hi ,   1) In Package we can combile all related objects into one component, whenever you refer or call any object in the package , full package will be copied to the memory , so that next ti...

Answer Question  Select Best Answer

bhanu priya

• Jul 4th, 2014

1. function result cache : stores the retured value in a cache and can b used again n again instead of storing it in memory.
2. continue statement : passes controle from one iteration to other rather than exiting it.
3.regexp.count is introduced.
4.dbms_parallel_execute is introduced.

Answer Question  Select Best Answer

DEPARTMENT_ID EMP_COUNT DEPT_PERCENTAGE

lviswanath

 Profile Answers by lviswanath Questions by lviswanath

• Jul 23rd, 2013

Ask the question clearly

what is DEPT_PERCENTAGE

on what basis we have to calculate DEPT_PERCENTAGE?

Answer Question  Select Best Answer

If there are 2 overloaded procedure, one among then have 1 IN parameter and another have 2 parameters. Both procedures parameters are of default type.

What will happen when you will call package.procedure without any parameter?

Khamar

• Jul 22nd, 2013

You will get an error message "PLS-0037: too many declarations of procedure_name match this call"

Answer Question  Select Best Answer

pavankumar_greek

 Profile Answers by pavankumar_greek Questions by pavankumar_greek

• Sep 15th, 2011

Using packages we can run concurrently two programs .
place the programs in two files and create a package which is having the code can open those two files. next we have to register this package to apps.

Answer Question  Select Best Answer