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

flamey

• Aug 25th, 2005

LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN

Answer Question  Select Best Answer

Using ROWID.CONSTRAINTS

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

By using the index and rowid

Answer Question  Select Best Answer

Integrity constraint is a rule that restricts values to a column in a table.

samiksc

 Profile Answers by samiksc Questions by samiksc

• Jan 19th, 2006

Integrity constraint restricts values of a column so that only meaningful values as per the business logic of the table be entered into the column.Integrity constraints are of the following types:Not ...

Answer Question  Select Best Answer

Database Link is a named path through which a remote database can be accessed.

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

When u want to access the database from remote database then u hv to create a database link with creating a directory .

Answer Question  Select Best Answer

Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.

RamPrasad K

• Jun 12th, 2006

Hi,Yes,We can use current and next values from a sequence.-Regards,

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

tnsnames.ora is used to connect to the remote db. To get the connection listener.ora should be configured at the server and it should be up and running.

deva

• Sep 20th, 2006

Listener is used to get the client server communication. U can access ur server only if the listerner is ON

Answer Question  Select Best Answer

I don no

Ramprasad K

• May 30th, 2006

Hi,Implementing a project from the begining to the production and maintenance stage.(1) System Planning:        (Scope & Budget of the Project)(2) Business Analy...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Shiv Mangal Rahi

• Jul 24th, 2006

---

Hi All,

INSTR function finds the numeric starting position of a string within a string.

As eg.

Select INSTR('Mississippi','i',3,3) test1,

         INSTR('Mississippi','i',1,3) test2,

         INSTR('Mississippi','i',-2,3) test3

from dual;

Its output would be like this

Test1           Test2              Test3

___________________________________________

11                   8                     2

SUBSTR function returns the section of thte specified string, specified by numeric character positions.

As eg.

Select SUBSTR('The Three Musketeers',1,3) from dual;

will return 'The'.

Shiv Mangal Rahi

• Jul 24th, 2006

Hi All,INSTR function finds the numeric starting position of a string within a string.As eg.Select INSTR('Mississippi','i',3,3) test1,         INSTR('Mississipp...

Nagarajan.R

• Jul 18th, 2005

INSTR (String1,String2(n,(m)), INSTR returns the position of the mth occurrence of the string 2 in string1. The search begins from nth position of string1.  SUBSTR (String1 n,m)&nb...

Improve Answer

Read Best Answer

Editorial / Best Answer

Indu  

 Profile Answers by Indu Questions by Indu

• Member Since Sep-2005 | Sep 15th, 2005

---

Quote

 

A ROWID is created by Oracle for each new row in every table, it is a pseudo column that has a value for every row in a table. The ROWID gives us the physical address of a row and is the fastest way to access any row. The ROWID contains 3 bits of information, they are :-

1. The block within the database file.
2. Row # within the block.
3. Database file ID.

An example could be :-

000088C9.0191.0002

 

The ROWID has three important uses, it is :-

1. The fastest path to any row.
2. A way of speeding the COMMIT process in application code.
3. Unique identifiers of any given row.

Unquote

 

Indu

 Profile Answers by Indu Questions by Indu

• Sep 15th, 2005

Quote  A ROWID is created by Oracle for each new row in every table, it is a pseudo column that has a value for every row in a table. The ROWID gives us the physical address of a row and is the f...

Sajida

• Jun 10th, 2005

By using rowid

Improve 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

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

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

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

INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

union:  distinct result set of two queries.union all : result set of two or more queries including duplicatesminus: result set of first query  "-" resultset of second queryintersect : common result set of both query;

Answer Question  Select Best Answer

Maintaining data integrity through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key or unique key of the referenced table.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

Foreign key constraints is know as referential integrity. which refers to a primary or ( unique ,not null) column

Answer Question  Select Best Answer

SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

Savepoint is used to give some break points between multiple transactions so that if some transaction is required to be rolledback then some of transaction will still available in buffer. commit will save the data and remove all savepoints

Answer Question  Select Best Answer

CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW,BLOB, CLOB,NCLOBFOR ORACEL 9I AND ABOVE.TIMESTAMP, TIMESTAMP WITH TIME ZONE, YEAR TO DAY, DAY TO SECOND

Answer Question  Select Best Answer

Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause

Answer Question  Select Best Answer