PL/SQL Interview Questions

Hi.. We can change the elements of listitems at runtime with the help of Record Group

create or replace function function_name(formal parameters list with only IN mode)

return datatype

is

local variable declarations

begin

 executable statments;

 return value;

end function_name;

we can use Ref cursor as an IN OUT parameter .

Normal cursor is used to process more than one record in plsql.

Refcusor is a type which is going to hold set of records which can be sent out through the procedure or function out variables.

select text from user_source

where name='procedure_name';

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

define is use for predefine variable

its depends on user. You can use char or number

CHAR

Dear Maria...

   I traied with the DBA previlage but... again the same prob.. proc created but table is not thea... ok I tried u r proc and mail back to you...

You are right Maria Antony, but the question is, why is it not possible to create the table thru the procedure while you can create the sametable using create table SQL command.The answer is, to creat...

by making use of sql%rowfound.

Hi,You could do the same as given under below for emp table.....CREATE OR REPLACE procedure procasbegindeclarev_empno emp.empno%type;v_ename emp.ename%type;cursor c_emp isselect empno,ename from emp;b...

During bulk collect you can save the exception and then you can process the exception.Look at the below given example:DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,1...

DECLARE TYPE NumList IS TABLE OF NUMBER; num_tab NumList := NumList(10,0,11,12,30,0,20,199,2,0,9,1); errors NUMBER;BEGIN FORALL i IN num_tab.FIRST..num_tab.LAST SAVE EXCEPTIONS DELETE *...

Its Binary Integer

Ramki,TCS,HYD

9989018508

is it number or binary integer?

Its depend upon the query. If the two queries are firing on the table it is not possible. If the queries are firing on different different tables then it is possible.

Thanks & Regards

Madhu D.

As Distributed database system based on 2 phase commit,one query is independent of 2 nd query so of course we can run.

manoj

Internally the Oracle database supports two procedural languages, namely PL/SQL and Java. This leads to questions like "Which of the two is the best?" and "Will Oracle ever desupport PL/SQL in favour ...

DECLARE   TYPE EmpCurTyp IS REF CURSOR;   // Reference Cursor - weak    TYPE NumList IS TABLE OF NUMBER;  // Table of Number   TYPE NameList IS TABLE OF VA...

Pl/Sql Table  is  like C Array .

Cursor variable doesn't store with pl/sql Table .

IT is a pointer to cursor & it is not item, It is dynamic.

types of triggers

create table src_table(col1 varchar2(10),col2 varchar2(10),col3 varchar2(10),col4 varchar2(10),col5 varchar2(10));insert into src_table values ('A', 'B', 'C', null, null);insert into src_table values ...

to create a result set where the rows need to be columns, or vice versa. You need to "pivot" rows into columns, or vice versa. this is where you need to look at a pivot (or crosstab) query.

LogMiner is a powerful audit tool for Oracle databases, allowing administrators to easily locate changes in the database, enabling sophisticated data analyses, and providing undo capabilities to rollback logical data corruptions or user errors.

when a package is initialised that is called for the first time the entire package is loaded into SGA and any variable declared in the package is initialises.