KSPRDEEP

• Oct 17th, 2012

In parameter means it will insert the values
OUT parameters means it will print out put (pass values to output). If we not assigning any value to out parameter it will take (print) NULL value.

INOUT means it take values as input and out put

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 7th, 2008

1.There is no hard and fast rule about this. Whether to use INOUT or OUT depends upon the situation.2. If not assigned anything to OUT parameter it retuns NULL value.

Answer Question  Select Best Answer

KSPRADEEP

• Oct 17th, 2012

Cluster are groups of one or more tables physically stores together to share common columns and are often used together

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk ...

Answer Question  Select Best Answer

We can create a column with' not null+unique' with out using primary key

PRADEEP

• Oct 17th, 2012

Primary key: set of columns is uniquely identified a rows of a table. It does not allow both nulls and duplicate values. If we use null values it will allow duplicate values but it does not allow n...

Radha

• Jul 14th, 2011

We can create NOTNULL and UNIQUE constraints on single column. Which indirectly means a Primary Key. But only a Primary Key column can be used as Foreign key column. Primary key provides a default...

Answer Question  Select Best Answer

 %  TYPE  provides  the data type of a variable or a database column to that variable. % ROWTYPE  provides the record type that represents a entire row of a table or view or columns selected in the cursor. The advantages are : I. Need not  know about variable's data typeii.  If  the  database  definition of a column in a table changes, the...

PRADEEP

• Oct 16th, 2012

%rowtype is associated entire table(if we want to declare all columns then we need to declare %rowtype).

%type is associated with one column .(if we want to declare entire column then we need to declare %type).

Yaseen

• Aug 9th, 2012

If using %type and %rowtype , no need to know the the data type of the table column . and once the development is finished , the type of column is changed it will not effect the coding.

Answer Question  Select Best Answer

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