Create an anonymous PL/SQL block to enroll a student in a particular class. You will use the ENROLLMENTS table. Accept a STU_ID and CLASS_ID as input parameters. Use "today's date" for the ENROLLMENT_DATE and the string "Enrolled" for the STATUS.

Mohana Thangavelu

• Sep 9th, 2017

Begin
Insert into enrollments values(&stud_Id,&class_Id,sysdate);
Commit;
End;

Answer Question  Select Best Answer

Nand Kumar Sahu

• Jul 13th, 2017

Bulk binding is very useful in performance tunning scenarios. BULK COLLECT and FORALL are tow main key of bulk binding. in bulk binding any DML operation is performed in a single execute so context swiching is not going to happening.

Rajan

• Mar 17th, 2017

Within a PL SQL code if there is any DML statement, it involves context switching. Every time there is a context switch, the cost is more. To handle this we have a functionality called bulk binding w...

Answer Question  Select Best Answer

How do you find the impact for the change and how to find the tables which are connected to this procedure or package?

Nand Kumar Sahu

• Jul 13th, 2017

You can check any object which is going to referred by any other objects using dba_dependency data dictionary.

SELECT * FROM dba_dependencies WHERE refereced_name = OBJECT_NAME;

Arundhati

• Apr 20th, 2017

You can check ALL_DEPENDENCIES, DBA_DEPENDENCIES, user_DEPENDENCIES

Answer Question  Select Best Answer

gauravy

• Jul 5th, 2017

Use pipeline functions

durgadas.menon

 Profile Answers by durgadas.menon Questions by durgadas.menon

• Aug 13th, 2008

Unlike tables ref cursors do not store data. They act like mold to hold data during the execution of the piece of code so proper coding and use of bind variables can help decrease the burden of proces...

Answer Question  Select Best Answer

If have 5 procedures in my specification part and used 4 in my body part while compiling will it throw error or not?

Shridevi Bhat

• Jun 30th, 2017

Yes it will throw error. all the declared procedures and functions must be there in package body with implementation.

Error(15,22): PLS-00323: subprogram or cursor GET_REPORT_URL1 is declared in a package specification and must be defined in the package body

vishal pathak

• Jun 7th, 2017

Yes, If procedure declared in specification not defined in body will through compilation error saying:- "procedure declared in package specification must defined in body". but vice-versa will not throw any error

Answer Question  Select Best Answer

How many types of PL/SQL Triggers are there? What are they?

Chandra sekhar

• Jun 23rd, 2017

Two types
ROW LEVEL
STATEMENT LEVEL

Yogesh

• Jun 2nd, 2017

Basically the are 5 type of trigger on basis of triggering events
1. DML
2. DDL
3. System or schema level
4. Compound
5. Instead of

Answer Question  Select Best Answer

adarh katiyar

• Jun 17th, 2017

Use PRAGMA AUTONOMOUS_TRANSACTION in trigger block,
issue never comes ...

Amit Bhardwaj

• Feb 9th, 2017

If you are trying to access or modify the triggering table into the same trigger and that too for a row level trigger then Mutating Trigger error occurred.

Answer Question  Select Best Answer

 A set of related declarations and procedural statements is called block.

Read Best Answer

Editorial / Best Answer

Answered by: Chandra Shekhar

• Oct 3rd, 2005

---

PL/SQL Block contains :

Declare : optional

Variable declaration

Begin  : Manadatory

Procedural statements.

Exception : Optional

any errors to be trapped

End :  Mandatory

So only begin and end keywords are required, as needed, to process a pl/sql block.

vamsi

• Jun 8th, 2017

Cursors
collections
procedures
functions
triggers

Kevin Korir

• Dec 10th, 2016

Declare: optional
Begin:mandatory-program logic of SQL&plsql statements
Exception: optional (error handling)
End:mandatory
(Forward slash / terminates)

Improve Answer

Which is faster, Drop or Truncate? Explain

masthan

• May 30th, 2017

Truncate is faster compared to Drop

Rajan

• Mar 17th, 2017

1. TRUNCATE is a DDL command whereas DELETE is a DML command. 2. TRUNCATE is much faster than DELETE. Reason:When you type DELETE.all the data get copied into the Rollback Tablespace first, then del...

Answer Question  Select Best Answer

tejascool

• May 23rd, 2017

A unique key constraint can be applied to single field or combination of fields which uniquely identifies a record.
unique key constraint allows null values as null !=null. so multiple null values are allowed

Piyush Kumar Sharma

• Dec 28th, 2016

We can insert multiple NULL values in Unique key constraints.

Answer Question  Select Best Answer

Atiqur Rahman

• May 18th, 2017

There is a tables called ALL_TRIGGERS which contains column STATUS (ENABLE/DISABLE). This column tells us that whether a trigger is enable or disable. Also current user can modify these values if user have CREATE ANY TRIGGER privilege.

Kumar Prateek

• May 4th, 2017

To know weather the Trigger status is Active/Inactive AND which trigger is used on which Table, SELECT T.[name] as TableName, TR.[Name] as TriggerName, CASE WHEN 1=OBJECTPROPERTY(TR.[id], ExecIsTri...

Answer Question  Select Best Answer

What is Private Procedure in Oracle PL/SQL?

Atiqur Rahman

• May 18th, 2017

Private Procedure: If a procedure is declared and defined within the package body known as private procedures. Also this cannot be executed by other procs of the package. Public Procedure: If a proce...

arundhati

• Apr 20th, 2017

A procedure define only in package body is a private procedure this is not available for external calls

Answer Question  Select Best Answer

ANIL KUMAR PASUPULETI

• Mar 27th, 2017

Use SQL%NOTFOUND to check whether the update is success or not and then take the action accordingly

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Mar 7th, 2007

Question was not clearsorrythis is my questionupdate a table A using cursor if it updated then insert into another table B.if not insert into same table A and insert into B.handle every exceptions in the code.nikhil ok

Answer Question  Select Best Answer

Can you invoke a Procedure inside Package P1 from the other package P2 in the same schema? Explain

Tanvi Singh

• Mar 24th, 2017

Yes we can invoke a procedure from another package if the procedure is of type public.

Answer Question  Select Best Answer

If amount s transfers from one account to another in banking, how will you update it with packages?

Where will the Procedure have is memory and location?

Can we use nested procedures? What is the limit?

Ram

• Mar 15th, 2017

Yes, we can use and the limit is 255

Raghabendra Sahoo

• Feb 6th, 2017

Yes , We can Use

Answer Question  Select Best Answer

How will you check performance of the query, if the query was running earlier but today its taking time to run?

inamdnik

 Profile Answers by inamdnik Questions by inamdnik

• Feb 10th, 2017

There are various ways to check performance of query. 1. Use EXPLAIN PLAN if you want to check execution plan used by oracle optimizer to run a query(This is more session specific.) 2. Use AUTOTRACE...

Subhapratim

• Feb 9th, 2017

We can check from AWR report

Answer Question  Select Best Answer

Abdul

• Oct 1st, 2016

We can use DBMS_job.isubmit procedure to schedule the job automatically..

Pran

• Jul 12th, 2016

I am trying this, but it says that procedure name is already exist.

Answer Question  Select Best Answer

Can we keep trigger name same as table name? Explain

Manisha

• Sep 21st, 2016

Trigger names must be unique with respect to other triggers in the same schema. Trigger names need not be unique with respect to other schema objects, such as tables, views, and subprograms. For examp...

Govind

• Sep 13th, 2016

No. Object Names should be unique.

Answer Question  Select Best Answer