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

I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

have a MS Excel 2003 query that works tied to an excel spreadhseet. Want to know how I can have it ask in excel for a date, where the date will go into the query. Like a prompt asking through date: ???? and you can enter the date, or even if a way you could make the query search automatically enter the current date into that field would work as well. So far this is my query in sql format.SELECT PO01A.POHIS_PO_NO,...

We have the following data hello,hello℅hi,hello hi ,hello hi% and we want to print only in order hello%hi and hello hi %.

Display each employee’s last name, hire date, and salary review date, which is the first Monday
after six months of service. Label the column REVIEW. Format the dates to appear in the format
similar to “Monday, the Thirty-First of July, 2000.”