What are the types of collection in PL/SQL? What is the advantage of nested tables?

pawan

• Nov 6th, 2012

Varrays,nested tables,index by tables are oracle collection.Index by tables also known as associative array similar to hashtables in java. Varrays are like arrays in java static in nature need to d...

Answer Question  Select Best Answer

Can a type body be dropped without dropping the type specification?

ramya

• Oct 31st, 2012

When you drop a type body, the object type specification still exists, and you can re-create the type body. Prior to re-creating the body, you can still use the object type, although you cannot call the member functions.

Answer Question  Select Best Answer

How can we find out the dependencies on a table?

srikanth goduru

• Oct 10th, 2012

Check the table dba_dependencies and see what other tables are affected.

Answer Question  Select Best Answer

With what ways can we find out instance locks?

Jose George

• Oct 22nd, 2012

V$lock contains details of locks

Answer Question  Select Best Answer

While testing a website, an image that is supposed to appear on a page does not load (for example in IE, you would see an empty box with a small red cross icon). What type of investigation could you carry out to find out what the cause of the problem is? What information would you include when raising the defect

harmeet rehal

• Oct 13th, 2014

Web testing is the name given to software testing that focuses on web applications. Complete testing of a web-based system before going live can help address issues before the system is revealed to th...

Answer Question  Select Best Answer

Create a query using “ group by” that shows maximum salary for each department?

lviswanath

 Profile Answers by lviswanath Questions by lviswanath

• Jul 17th, 2013

Code
 

Answer Question  Select Best Answer

Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?

vishal.bhadange

 Profile Answers by vishal.bhadange Questions by vishal.bhadange

• Aug 24th, 2013

CASE 1 (If you are not handling exception in Procedure B, none of the table gets updated) "sql PROCEDURE A BEGIN UPDATE TABLE t1; UPDATE TABLE t2; CALL PROCEDURE ...

Answer Question  Select Best Answer

How do you reference a (updated) table from procedure A which is being updated by another procedure B?

Lalit

• Sep 15th, 2013

By taking help of global temporary table.

Answer Question  Select Best Answer

What is function purity level and why we need it in PL/SQL function?

chaitanya

• Sep 19th, 2014

Any function called from an sql query will have certain side effects on database state and package variables..these side effects are classified as purity levels. there are different purity levels like 1. read no database package state 2. write no database package state e.t.c

Answer Question  Select Best Answer

sandeep

• Nov 22nd, 2014

This was used when you are going to use the cursor in more than one place with different values for the same where clause.

Answer Question  Select Best Answer

Hi ,can any one tel pls what is use ofprocedures and packages? why we use can anyone tell me with one real time example

HEMA NAGARAJU

• Dec 20th, 2014

Procedures are dataobjects which are stored in a database. We can define an operation in procedure and we call the procedure many times in the application. Packages are collection of subprograms, pro...

Answer Question  Select Best Answer

Guys can you please help me in realtime scenario?

Abhijit Musale

• Feb 18th, 2015

Whenever you want to perform some operation on a set of result of rows , then we use the cursor.Cursor is nothing but a work space allocated on the memory. When u fire a query that set of rows is stored in the cursor temporarily.

Answer Question  Select Best Answer

Abhijit Musale

• Feb 18th, 2015

To make the operations faster. When we need to do any operation on data like some calculations and when u need to fetch the data repetitively , in that case we can use the collections like PLSQL table.

Answer Question  Select Best Answer

vivek

• Feb 23rd, 2016

1. Install ords.war (Download from Oracle site)
2. Configure Oracle rest data services. Using ords.war file. $ ords.war install advanced. (It will ask for database credentials)
3. Copy the images under i.war file.
4. Deploy the war files in weblogic.
5. Access the application

Answer Question  Select Best Answer

Anjani Kumar

• Aug 9th, 2015

We can use oracle supplied package DBMS_HPROF(New in 11g) to see which procedure and inside that which sql is taking taking more time to execute.DBMS_HPROF Package profiles subprogram calls also with ...

Answer Question  Select Best Answer

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

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

Write a PLSQL function that accepts some text and validates that the text has only Alphanumeic characters and returns true else returns false

Priya

• Oct 25th, 2018

LENGTH(TRIM(TRANSLATE(string1, abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ+-.0123456789, )))

This function will return a null value if string1 is alphanumeric. It will return a value "greater than 0" if string1 contains any non-alphanumeric characters.

Answer Question  Select Best Answer

 Some  scalar  data  types  such  as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN.Some composite data types such as RECORD & TABLE.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 16th, 2008

ScalarCHARVARCHAR2 LONGLONG RAWNUMBER [(precision, scale)]BINARY_INTEGERPLS_INTEGERBOOLEAN Composite TypesRECORDTABLEVARRAYLOB TypesBFILEBLOBCLOBNCLOBReference TypesREF CURSORREF object_type

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Oct 26th, 2006

Following are the datatype supported in oracle PLSQLScalar TypesBINARY_INTEGERDECDECIMALDOUBLE PRECISIONFLOATINTINTEGERNATURALNATURALNNUMBERNUMERICPLS_INTEGERPOSITIVEPOSITIVENREALSIGNTYPESMALLINTCHARC...

Answer Question  Select Best Answer

 Mutation of table occurs.

rudra pratap

• Jul 5th, 2007

In order to avoid mutation table error we need to have a row level as well as a statment level trigger.

Sunil Yadav

• Oct 26th, 2005

To avoid the mutation table error ,the procedure should be declared as an AUTONOMOUS TRANSACTION.By this the procedure will be treated as an separate identity.

Answer Question  Select Best Answer