In which section of a PL/SQL block is a user defined exception waste?

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by vishakha_jain81

• Aug 7th, 2008

In exception block

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

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