manoj bajaj

• Apr 25th, 2006

Yes we can relate two tables from 2 diff usersE.g. if user A has table Ta  and User B has Table Tb  and Table Tb is child table and needs foreign key on A.Ta  then we need to grant "references" object privillege to User B on table Ta.1

Answer Question  Select Best Answer

SADANAND

• Apr 14th, 2006

First create a Trigger and with Procedure you insert records.The :new will take the new values.So use Triggers in Procedures.

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

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

Guna Sagar Challa

• Mar 27th, 2006

Hi,Use the V$OPEN_CURSOR view to know how many cursors are currently open in the database.Guna Sagar Challa 

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

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

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

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

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

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

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

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