Innila

 Profile Answers by Innila Questions by Innila

• Mar 2nd, 2007

LOB datatypes can be used to store blocks of unstructured data like graphic images, video, audio, etc

Answer Question  Select Best Answer

ajeeteng

 Profile Answers by ajeeteng Questions by ajeeteng

• May 5th, 2010

The DBMS_TTS package checks if the transportable set is self-contained. TRANSPORT_SET_CHECK Procedure This procedure checks if a set of tablespaces (to be transported) is self-contained. After calling this procedure, the user may select from a view to see a list of violations, if there are any.

Answer Question  Select Best Answer

Kamal Mohapatra

• Jul 23rd, 2007

You must be speaking about PLS_INTEGER.? PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER which uses library arithmetic. As such PLS_INTEGER is somewhat faster than BINARY_INTEGER. Also BINARY_INTEGER has subtypes. I don't think PLS_INTEGER has subtypes

Answer Question  Select Best Answer

RoulRaj

• May 11th, 2007

There should be atleast one statement in between Begin and End.The Statement may be Null statement also.Syntax:declarebeginnull;end;RegardsR.K.Roul

Answer Question  Select Best Answer

Hi,1. Iam looking for sample program for ref cursor. ref cursor can be associated with many select statements and we can use the ref cursor to return the multiple value from the procedure or function. how to use the ref cursor in a program to associate with many select statements.2. we can't use the %rowtype attribut to return the multiple from the procedure or function instead of ref cursor. if we...

krishnamohan_geek

 Profile Answers by krishnamohan_geek Questions by krishnamohan_geek

• Mar 25th, 2007

Hi,Let me answer your second questin first. Why ref cursor instead of %ROWTYPE.%ROWTYPE is used for fetches record/row of a single table.OR in case of columns of different tables then you have to crea...

Answer Question  Select Best Answer

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 5th, 2007

You can use SYSDATE oracle.lv_today := sysdate;or select sysdate into lv_today from dual;both the statements assign sysdate to lv_today

Answer Question  Select Best Answer

Hi, can any body give me the sample program for avoiding the mutating error. we can avoid the mutating through the statement level trigger instead of using the statement leve trigger, i need one sample program to avoid the mutating error by using pl/sql table.Thanks Saravanan.P

KiranKW

 Profile Answers by KiranKW Questions by KiranKW

• May 3rd, 2007

A mutating error comes when u r trying to do some DML operation on a table that owns the trigger.... there are a lot of options to avoid mutation .. eg, Making it autonomous transaction...

Answer Question  Select Best Answer

gopichandv2002

• May 22nd, 2007

You should write returning in the blank place

Answer Question  Select Best Answer

What is the differences between it.

norman

 Profile Answers by norman Questions by norman

• May 8th, 2007

Rule Based Optimization is an older technique which is used for optimization of queries but follows a fixed rule or strategy for achieving the same. But in contrast cost Based Optimization is a later ...

Answer Question  Select Best Answer

ramnath123

 Profile Answers by ramnath123 Questions by ramnath123

• Oct 21st, 2011

Code + decode

Code
code + decode

Answer Question  Select Best Answer

Data Concarency => Means that many users can access data at the same time.Data Consistency => Means that each user sees a consistent view of the data, including visible changes made by the user's own transactions and transactions of other users.

arvind kumar

• Apr 12th, 2006

types of triggers

tm1966_muthu

 Profile Answers by tm1966_muthu Questions by tm1966_muthu

• Feb 17th, 2006

ConcurrencyHow well can multiple sessions access the same data simultaneously ConsistencyHow consistent is the view of the data between and within multiple sessions, transactions or statements

Answer Question  Select Best Answer

Antony Gubert

• Mar 6th, 2006

Definer Rights--------------A routine stored in the database by default, is executed with the definer rights (owner of the routine), depending on the user who calls it.  For example, table "...

Tez

 Profile Answers by Tez Questions by Tez

• Oct 9th, 2005

U can unerstand these if u hav an idea of DBA..... DBA is the one who has all the priveleges on the database.....So if u are a user of the database........ and if u want to make some operations on t...

Answer Question  Select Best Answer

ramkiibm.yerra

 Profile Answers by ramkiibm.yerra Questions by ramkiibm.yerra

• Aug 29th, 2007

Hai Rashmi?Its not Similar. The First statement is only for Read-Only Trasactions that to be used in PL/SQL Block. The Second one is for Isolation Levels like Read Uncommitted, Read Committed, Repeatable Read, Serializable.RegdsRama Krisha.Yramakrishna . yerra @ in . ibm . com

Answer Question  Select Best Answer

Sourabh

• Mar 4th, 2006

create table src_table(col1 varchar2(10),col2 varchar2(10),col3 varchar2(10),col4 varchar2(10),col5 varchar2(10));insert into src_table values ('A', 'B', 'C', null, null);insert into src_table values ...

KS

• Mar 3rd, 2006

To create a result set where the rows need to be columns, or vice versa. You need to "pivot" rows into columns, or vice versa. this is where you need to look at a pivot (or crosstab) query.

Answer Question  Select Best Answer

developer

• Sep 14th, 2006

Hi,for example u have a sequence called s1 and table as student theninsert into student values(s1.nextval,field1,field2, ....);that's all

Divesh

• Apr 23rd, 2006

U can directly use insert into < table_name> select .currval/nextval from dual.Please free to contact me if any queries on dibansal@cisco.com

Answer Question  Select Best Answer

rajkumar1237

 Profile Answers by rajkumar1237 Questions by rajkumar1237

• Apr 27th, 2013

OCI means::oracle call interface.is a interface api used to access oracle database from C programs. Data Guard stands for it is multiple DB servers environment configured for Physical as well as Logic...

Answer Question  Select Best Answer

D. Madhusudhana Rao ( 9885626575)

• Aug 1st, 2006

Its depend upon the query. If the two queries are firing on the table it is not possible. If the queries are firing on different different tables then it is possible.Thanks & RegardsMadhu D.

Manoj Kumar Verma

• Aug 1st, 2006

As Distributed database system based on 2 phase commit,one query is independent of 2 nd query so of course we can run.manoj

Answer Question  Select Best Answer

Sheetal

• Aug 24th, 2006

Hi,Your program will delete all rows from the table. If you print output after fetch from the cursor it will show all rows those where selected in the cursors.When the cursor was created u select...

Rama Krishna,Y

• Aug 21st, 2006

Hi Friend!! If you want to use the entire tale data from table in PL/SQL programing block,you have to store the entire data in a temp buffer variable .. to syntronize that operation Oracle supports...

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

rashid

• Sep 20th, 2006

define is use for predefine variable its depends on user. You can use char or number

Sachin

• Sep 5th, 2006

CHAR

Answer Question  Select Best Answer