vijaya

• Jan 10th, 2006

If DEFINE is isqlplus command then how do u define ACCEPT command. what is difference between them?i think define is a command in sql *plus which works same in isqlplus with ACCEPT.pls do forward the argument.

marthand

• Dec 27th, 2005

define is not a sql commanddefine is Isql*plus command.  to give a global variable we use it

Answer Question  Select Best Answer

Narender Reddy

• Jan 4th, 2006

In Oracle 9i instead of snapshot we can use meterialized views which can act as snapshot.Diff between view & snapshot is view is not a table its a virtual table to join one or more table or to pre...

prakash2906

 Profile Answers by prakash2906 Questions by prakash2906

• Dec 27th, 2005

A snapshot is a table that contains the     results of a query of one or more tables or views, often located on     a remote database.

Answer Question  Select Best Answer

Transaction is logical unit between two commits and commit and rollback.

Vaibhavi

• Dec 21st, 2005

A  Transaction  is  a  logical  unit of work that comprises one or more SQL statements executed by a single user.

j lehew

• Aug 25th, 2005

A transaction either commits (i.e. all its actions happen), or it aborts (i.e. all its actions are undone). This all-or-nothing quality makes for a simple programming model.   Transactions also meets the ACID test: Atomic, Consistent, Isolation, and Durable

Answer Question  Select Best Answer

SaratKumar Puranam

• Oct 4th, 2005

Non corelated subquery, where the subquery has been executed once for the entire parent statement.

Answer Question  Select Best Answer

Jayakumar M

• Nov 9th, 2005

Cursor_already_open, Invalid_cursor

kumar vikal

• Jul 27th, 2005

Invalid_cursor, cursor_not_open

Answer Question  Select Best Answer

To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.

SaratKumar Puranam

• Oct 4th, 2005

Advantages of view:1. Restricts the access to particular columns and rows of the base tables.2. Hide the data complexity.3. Can access the data for two different base tables with out performing a join...

Answer Question  Select Best Answer

Atal

 Profile Answers by Atal Questions by Atal

• Sep 16th, 2005

scott@8i> create database link ora8idev  2  connect to scott  3  identified by tiger  4  using 'ora8idev'  5  /Database link created.scott@8i> select * from dual@ora8idev;D-Xscott@8i>

Swapnil

• Jul 28th, 2005

It is a way of connecting to remote database. usage is  @xyz.tablename.column

Answer Question  Select Best Answer

flamey

• Aug 25th, 2005

LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN

Answer Question  Select Best Answer

Sandipanni Bharadwaj

• Aug 10th, 2005

5. The query of the view shoud not consist of any aggregate funtion  6. The query shoud not consist of any subquery 7 And the other option is we can use the instead of trigger to update the ...

Swapnil

• Jul 28th, 2005

An Insert,Update,delete can be done through views is 1. inserts/updates/deletes done only in one base table at a time 2. primary key columns should be part of view 3. columns which are going to be updated must be part of vew def. 4. it shouldn't voielet the contraints

Answer Question  Select Best Answer

Scott

• May 12th, 2005

By utilizing savepoints, you are able to rollback to a given point in your processing. An example of this would be: ... COMMIT;  INSERT UPDATE SAVEPOINT A  DELE...

Ratan

• Mar 25th, 2005

Savepoints are the temporary bookmarks. it is possible to rollback up to the named savepoint.

Answer Question  Select Best Answer