PRADEEP

• Oct 16th, 2012

Ref cursor is having return type where as cursor does not have .
syntax of ref cursor:- type ref_type_name is ref cursor [return return_type].

syntax of cursor:- declare
cursor cursor name select statement..

pradeep

• Jan 8th, 2012

Normal cursors do have a return type. ex:

Code
 

Answer Question  Select Best Answer

PRADEEP

• Oct 16th, 2012

Rowid is octal decimal values it is stored permanently in a oracle database. It will created while creating a table.

rownum is also octal decimal number but it is for only specific time span it will arise after completed a task.

Dilip

• Sep 3rd, 2012

Here I am providing all the psudo columns of Oracle ROWNUM, ROWID,NEXTVAL, CURRVAL, SYSDATE, USER, LEVEL

Answer Question  Select Best Answer

What is a global temporary table?

Aijaz

• Oct 14th, 2012

Global temporary tables are the permanently created tables for a timed session.
Only the data in the table is temporary but the table is permanent in the Oracle database.

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

How do we do mass updates in Oracle PL SQL?

shivigupta

 Profile Answers by shivigupta Questions by shivigupta

• Oct 9th, 2012

Code
 

GeekQA123

 Profile Answers by GeekQA123 Questions by GeekQA123

• Aug 15th, 2012

Use Bulk Update stmt.

Answer Question  Select Best Answer

 Raise_application_error  is  a  procedure  of  package  DBMS_STANDARD which allows  to  issue an user_defined error messages from stored sub-program or database trigger.

Ashutosh

• Oct 8th, 2012

Their classes of errors and diff. errors are divided among these classes simply because of ease in classification, For defining errors and error message with raise_application_error procedure by users...

SARANYA

• Jul 25th, 2011

I know that the error no in raise_application_error are non standard but tell me on what basis we are giving those numbers? is that simply a number or it some implicit meaning ?

Answer Question  Select Best Answer

hi
I have to write a query to fetch 5 columns from the data. columns are title,description,msgs_count,alerts and severity.
msgs_count is count(title) over (partition by ) and alerts is sum(title partition by) over.

in case the duplicates of title are present in data. I want the title to come only once in the output but the msgs_count and alerts must not be affected. is it...

raghavender

• Oct 7th, 2012

Analytic functions are used to fetch all rows with the required aggregate data, if duplicates are needed, then you can use distinct or you can use group by clause instead of analytic functions which will have better performance.

Answer Question  Select Best Answer

HI all
table contain some 1000 records, today I inserted 100 records into table, so I want first 10 records data from 100 records
how can I retrieve

kapil joshi

• Sep 15th, 2012

Select * from employees where rownum

Manoj Kumar

• Aug 28th, 2012

Code
 

Answer Question  Select Best Answer

How to query nested table column of a table without using table function?

Pooja

• Sep 3rd, 2012

There are two general ways to query a table that contains a collection type as a column or attribute. Nest the collections in the result rows that contain them. Distribute or unnest collections so t...

Answer Question  Select Best Answer

Vishal R Bhadange

• Aug 12th, 2012

Yes.
Yes we can truncate some of the rows from the table, But table should be partitioned & all the rows to be deleted should be present in one single partition...

leelakrishna302

 Profile Answers by leelakrishna302 Questions by leelakrishna302

• Jun 15th, 2012

We cannot

Answer Question  Select Best Answer

How to display all rows and all the columns of employee table?

ram

• Aug 8th, 2012

Select *from emp;
here * retriving all records from the db

Answer Question  Select Best Answer

ChevyBlazer

 Profile Answers by ChevyBlazer Questions by ChevyBlazer

• Jul 2nd, 2012

The answer will be between 11-14 . You have to consider two extreme cases where 1. 3 rows with a=10 and 11 rows with b=20 are all distinct rows - then the answer will be 14 2. Where there are 11 rows...

Venkat

• Jun 30th, 2012

The accurate answer is "The result can contain max of 14 records", but this not guaranteed. It can be less also. (Minimum is 10 rows and maximum is 14 rows). It is because there can be some overlpa in the same row between "a" and "b" column.

Answer Question  Select Best Answer

          Cursor C1 is          Select empno,          ename from emp;          Begin               open C1;           ...

Vivek

• Jun 29th, 2012

After committing first oracle will commit the transaction into redo log file and then Data file. The data block will remain into the memory until the logical reads are going on. Oracle use LRU algorit...

Art11

 Profile Answers by Art11 Questions by Art11

• Sep 27th, 2011

The data will be written from redo log buffer into redo log files.

Answer Question  Select Best Answer

Aniruddha Das

• Jun 11th, 2012

If you want to take care of performance tuning you need to take care of sub-queries as they takes a lot of time to executing in side the pl-sql blocks.

ptmich

 Profile Answers by ptmich Questions by ptmich

• May 28th, 2012

Ref cursor is used to declare a pointer variable. When you return a ref cursor, you are returning a pointer variable.

Answer Question  Select Best Answer

manisha

• May 27th, 2012

Use

Code
 

Neeraj Siddhey

• Mar 20th, 2012

This will work:-

Code
 

Answer Question  Select Best Answer

vizzi

• May 16th, 2012

When we use a select query in the from clause, it is called as a inline view. It is used to reduce complexity of using so many join conditions.

Answer Question  Select Best Answer

Outline the List of PRAGMA'S used in Oracle.

amrapali

• Apr 21st, 2012

PRAGMA The instruction is a statement that provides some instructions to the compiler. Pragmas are defined in the declarative section in PL/SQL. The following pragmas are available: AUTONOMOUS_TRA...

bobbyiiit

 Profile Answers by bobbyiiit Questions by bobbyiiit

• Apr 9th, 2010

PRAGMAPragma is a keyword in Oracle PL/SQL that is used to provide an instruction to the compile.Types Of Pragmas :-1 - AUTONOMOUS_TRANSACTION2 - EXCEPTION_INIT3 - RESTRICT_REFERENCES4 - SERIALLY_REUSABLE

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

In the exception part,what will happen if u don’t give (when others) where will it show error compile time or run time

NAND

• Feb 27th, 2012

It will give the error at run time if it is not able to find the type of exception thrown in the current PL/SQL block or the outer block.
It will not throw the compile time error.

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Feb 27th, 2012

Now, to clarify, I am taking the following statement; "in the exception part, what will happen if you don't give the (when others) statement" to mean an exception block with no other when statements a...

Answer Question  Select Best Answer

Susil Kumar Nagarajan

• Jan 21st, 2012

Use the combination of To_char and MIN functions.. to_char(min(created),dd-Mon-yyyy hh:mm:ss) Example:

Code
 

Hitendra Yadav

• Dec 15th, 2011

Just use min() function and find minimum timestamp from a table.

Answer Question  Select Best Answer