Write a PL/SQL anonymous block with exception handling to print your name 10 times?

Sri

• Feb 7th, 2020

Begin
i varchar2(10) :=xxxxxxx
begin
for x in 1..10 loop
dbms_output.put_line(i);
end loop;
end;
/

Bibhudatta Panda

• Jun 18th, 2019

Code
 

Answer Question  Select Best Answer

 It  is  not  possible.  As  triggers are defined for each table, if you use COMMIT   of    ROLLBACK  in  a  trigger,  it  affects  logical  transaction processing.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

COMMIT, ROLLBACK, and SAVEPOINT statements are not allowed within the trigger body. It is possible to commit or rollback indirectly by calling a procedure, but it is not recommended because of side effects to transactions.

jockey

• Aug 2nd, 2007

Using autonomous_transaction it is possible

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 7th, 2008

Procedures Can have Parameters. But parameters is optional .i.e. we may defined procedures without parameters also.It can take three types of parametersIN , OUT and INOUT.

kanchan Patra

• Aug 7th, 2007

Yes, Procedures can have parameters.

Answer Question  Select Best Answer

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 15th, 2009

Function  having a return type as Boolean ,can't be used in select statement.

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 7th, 2008

In functions we can use all three types of parametershere is a simple exampleCREATE OR REPLACE FUNCTION TEST_FUNC(A IN NUMBER, B IN OUT NUMBER,C  OUT NUMBER)  RETURN NUMBER IS   &n...

Answer Question  Select Best Answer

Amol Bakane

• Apr 2nd, 2018

The following hierarchy is followed when a trigger is fired. 1) BEFORE statement trigger fires first. 2) Next BEFORE row level trigger fires, once for each row affected. 3) Then AFTER row level tr...

Baji Shaik

 Profile Answers by Baji Shaik Questions by Baji Shaik

• Jun 5th, 2011

The orders of triggers execution is like this???? ? 1.before statement level?? 2.before row level?? 3. after row level?? 4 after statement level

Answer Question  Select Best Answer

You have a package called A and one function in that packgae called XYZ.If you need to call that function in second packaged B, How will you call?

Raj_P

 Profile Answers by Raj_P Questions by Raj_P

• Sep 1st, 2010

1) VarName := PackageName.FunctionName(<Parameter List>).2) Select PackageName.FunctionName(<Parameter List>) From <TableName?     You cannot run this statement if y...

shekhar2010

 Profile Answers by shekhar2010 Questions by shekhar2010

• Aug 30th, 2010

Yes we can call a function which is there in a Package 'A' from Package 'B'. And it is very simple as stated belowPackage_Name.Function_Name(Parameter_List);

Answer Question  Select Best Answer

vnraos

 Profile Answers by vnraos Questions by vnraos

• Sep 5th, 2008

First, let us understand why these errors cropup.1) NO_DATA_FOUND - is raised only for "select into" statements when? the where clause of the query does not match any rows.2)TOO_MANY_rows - is raised...

binurajnair

 Profile Answers by binurajnair Questions by binurajnair

• Jul 30th, 2008

If you don't want an excpetion to be raised on a SELECT statement, you can avoid executing the statement by having a count just before the SELECT as shown belowSELECT count(rowid)into v_count from...

Answer Question  Select Best Answer

sandeshshinde000

 Profile Answers by sandeshshinde000 Questions by sandeshshinde000

• Jun 4th, 2011

begin  DML 1  '  '  '  '  '  DML 10exceptionwhen others thandbms_output('error at location '||dbms_utility.format_error_backtrace);e...

BakulPatel

 Profile Answers by BakulPatel Questions by BakulPatel

• May 7th, 2011

To simplify  Remove exception block. Oracle will show line number with error thrownOther method:beginlocation :=1; dml1 location :=2; dml2exception    when others than&nb...

Answer Question  Select Best Answer

RAVI KUMAR BURRI

• Jan 19th, 2020

SET AUTOTRACE ON EXPLAIN

machomanic

 Profile Answers by machomanic Questions by machomanic

• Jul 8th, 2010

You can use the command SQL> SET TIMING ON;This will show how much time your query took for the execution.

Answer Question  Select Best Answer

pankti

• Apr 6th, 2012

Nested table Unbounded ...

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 6th, 2008

A Table is a basic unit of storage in oracle.A nested table is a collection type. The main advantage of collections is instead of processing data sequentially, we may process all the date&nb...

Answer Question  Select Best Answer

How to delete duplicate Keys through PL-SQL in single query.

anonymous

• Sep 27th, 2011

Code
 

Art11

 Profile Answers by Art11 Questions by Art11

• Sep 21st, 2011

Assuming that ename and job is the same or First and Last name...

SELECT * FROM (SELECT empno, ename, job ,RANK() OVER (PARTITION BY ename, job ORDER BY empno) AS SeqNo FROM emp1) WHERE SeqNo > 1

Answer Question  Select Best Answer

Explain what is Simple Cursor and What is Parameterized Cursor? And Difference between both??

sandeep

• Feb 1st, 2018

In real time we are using more than one cursor in PL/SQL block. so in this we are sending one cursor values into another cursor so the receiving cursor must be parameterised cursor

Akash Mohan singh

• Dec 26th, 2017

A parameterized cursor are static cursor that can accept passed in parameter values when they are opened. Parameterized can only reference to its own parameter parameterized cursor cannot reference to local variable.

Answer Question  Select Best Answer

During preparation of report in *.RDF , there are two things on date & to date

on date is the i/p value , but to date = 1st day of this month on date

how ?

pradeep

• Apr 24th, 2015

SELECT TRUNC(SYSDATE,MM) FROM DUAL

Praveen

• Apr 22nd, 2015

SELECT ADD_MONTHS(LAST_DAY(SYSDATE),-1)+1 FROM DUAL;

Answer Question  Select Best Answer

Is Dual Table updatable? If we update, will it impact the health of the database?

Habib Ali

• May 10th, 2016

DUAL table is owned by SYS, and is updatable only under SYS account. But never make any changes to DUAL, as it is frequently used by Oracle optimizer to test Execution Plans.

vishal

• Mar 29th, 2016

No we can't update dual table because it is a dummy table. But it is possible to create a table named dual and you can insert, update and delete that table.

Answer Question  Select Best Answer

Not known yet

ankurlibra

 Profile Answers by ankurlibra Questions by ankurlibra

• Sep 26th, 2010

We are misunderstanding the question and I assume that Abhishek want to say that "How we can hide a table info from user?".To hide table info or as per question make it invisible to other user. A tabl...

pravelu

 Profile Answers by pravelu Questions by pravelu

• Apr 23rd, 2010

It can be done using role grants. Grant view or debug privileges to only the set of users who can see these tables. The other users who are not granted the privilege cannot view this table. Every single user is a Schema in Oracle.It is by default, that the table cannot be seen by others.

Answer Question  Select Best Answer

Sahaja Mallarapu

• Aug 26th, 2011

A Ref Cursor is a variable that points to cursor.A ref cursor allows you to store the result of a "bulk collect" from a table (or any PL/SQL cursor return set) into a PL/SQL table and then reference ...

Sadashiv

• Aug 8th, 2011

REF Cursor OR Dynamic Cursors: Query associated with cursor is not known at the time of compilation. The select statement associated with cursor is changing at the time of running the program Syntax...

Answer Question  Select Best Answer

priya dharan raj

 Profile Answers by priya dharan raj Questions by priya dharan raj

• Nov 14th, 2011

Code
 

Nitesh Srivastava TechM

• Nov 10th, 2011

See the code below

Code
span style="color: #ff0000;">'EMP''EMP'

Answer Question  Select Best Answer

aak

• Sep 15th, 2016

No, You can add the proc in body and not declare it in the spec.. this is ok as it would mean that that proc is a private procedure but visa versa is not possible. It would give compilation error.

Sudhanshu

• Jul 26th, 2016

"oracle8 Create or replace package Test_pkg as 2 procedure Proc1; 3 end; 4 / Package created create or replace package body Test_pkg as 2 3 procedure proc1 is...

Answer Question  Select Best Answer

 Cursor  for loop implicitly declares %ROWTYPE as loop index,opens a cursor, fetches rows of values from active set into fields in the record and closeswhen all the records have been processed.      eg. FOR emp_rec IN C1 LOOP          salary_total := salary_total +emp_rec sal;         ...

vasu

• Oct 20th, 2012

Cursor for loop is the one by using this we need not to perform open, close, fetch operations of a cursor..

PRADEEP

• Oct 17th, 2012

If we use explicit cursor we need to open the cursor and fetching the data and close the cursor.

If we use cursor for loop cursor will open the cursor and fetching data and close the cursor automatically.

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 3rd, 2008

IN :- actual parameter is passed by reference (a pointer to the value is passed in) OUT:- actual parameter is passed by value (a copy of the value is passed out) unless NOCOPY is specified I...

ashwinee2

 Profile Answers by ashwinee2 Questions by ashwinee2

• Apr 11th, 2008

Take this:IN parameters are passed by reference, so the value cannot be changed in the procedure and functions.Out and IN-OUT parameters are passed by value, so the values can be changed inthe procedures and fucnctions.

Answer Question  Select Best Answer