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

       FUNCTION name (argument list .....) Return datatype is     local variable declarations     Begin          executable statements     Exception          execution handlers     End;

bavani

• Oct 23rd, 2006

create or replace function function_name(formal parameters list with only IN mode) return datatypeislocal variable declarationsbegin executable statments; return value;end function_name;

Answer Question  Select Best Answer

pankaj_gauba

 Profile Answers by pankaj_gauba Questions by pankaj_gauba

• Jan 11th, 2006

In reference cursor but we have option of giving the where clause in the body ,We cann't write cursor without select statement.

Answer Question  Select Best Answer

SANCHITA SARKAR

• Feb 2nd, 2006

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.

Answer Question  Select Best Answer

tm1966_muthu

 Profile Answers by tm1966_muthu Questions by tm1966_muthu

• Feb 17th, 2006

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.

Answer Question  Select Best Answer

praveen.pinisetti

 Profile Answers by praveen.pinisetti Questions by praveen.pinisetti

• Apr 6th, 2006

After compiling procedures,functions and triggers(in new versions only),Those will be stored in the form of p-code(after parsing) in SGA(System Global Area).The advantage of p-code is Since it wa...

Answer Question  Select Best Answer

Navin

• Mar 2nd, 2006

A ref cursor is a type that you can define in the declare section of your PL/SQL program. You can then open this cursor for any SQL statement that you construct dynamically in your program.For your ot...

Answer Question  Select Best Answer

Rajesh Ramanan

• Mar 2nd, 2006

SELECT dbms_rowid.rowid_block_number(rowid)FROM bowie_stuff;SELECT dbms_rowid.rowid_object(rowid)FROM bowie_stuff; 

Answer Question  Select Best Answer