Nishanth

• Aug 17th, 2006

For ORACLE to display the amount of time it takes to execute a statement or procedure in the SQL window you need to set some environmental,in this case you have to execute the following statement...

Answer Question  Select Best Answer

Asim Jamal

• Jun 6th, 2006

   We can add a signature to a database by using LONG datatype.and can use in the report as required.  

Answer Question  Select Best Answer

Oracle Net Services provides enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services eases the complexities of network configuration and management, maximizes performance, and improves network diagnostic capabilities. Oracle Net, a component of Oracle Net Services, enables a network session from client application to an Oracle database server....

Suresh

• May 11th, 2006

DISTRICT   STUDENTNO  STATUS---------- ---------- -EG         1          PEG    ...

Answer Question  Select Best Answer

Tarak Nath

• Apr 12th, 2006

Increasing the DBWN will not help ,because unless LGWR writes DBWN cannot write. Here the solution will be to decrease th e MTTR parameter  so that frequent check point takes place.

SURINDER KAPOOR

• Mar 26th, 2006

dbw0 The database writer writes modified blocks from the database buffer cache to the datafiles. Oracle Database allows a maximum of 20 database writer processes (DBW0-DBW9 and DBWa-DBWj). The initial...

Answer Question  Select Best Answer

jagadishVarodia

• Apr 12th, 2006

For time being type below command at sql promptSQL>define_editor=viYou can add export EDITOR=vi in .profile and logou/login for permament changeHope this will solve it

Guna Sagar Challa

• Mar 27th, 2006

Hi,To set the editor for editing sql commands and PL/SQL code at the SQL*Plus (Unix: $sqlplus) enter the following command at ur sql prompt after logging indefine _editor = <path and file name of the exe for the new editor>Hope this solves ur probCheers,Guna Sagar Challa

Answer Question  Select Best Answer

Kanchan

• Mar 7th, 2006

In Oracle with PLSQL language implemented in D2K, we can use principle of INHERITANCE by using Libraries which is oops concept. 

Answer Question  Select Best Answer

What is use of variable declaration in programming language? what is difference between oracle & programming language?

prasadmeduri

 Profile Answers by prasadmeduri Questions by prasadmeduri

• Feb 20th, 2006

Oracle provides us with storage area where you can have seperate users,roles for accessing large amount of data.It has a database management system.we can store large amount of data usign oracle....

love_oracle

 Profile Answers by love_oracle Questions by love_oracle

• Feb 13th, 2006

In programming language storing the user information we take the help of variable. And variable are also used to store the result after execution. Difference between programming language and oracle ar...

Answer Question  Select Best Answer

Jamuna.B

• Feb 17th, 2006

Before traversing thru the table you can check the status of recordset ie whether it is open or closed.if rsdiv.status=closed then   rsdiv.open............end ifTry this.Cheers,Jamuna.B

Prasad Meduri

• Feb 13th, 2006

As soon as you open the recordset you cannot give if ....use while not rs.eof()..................................rs.movenext().................................wendtry this

Answer Question  Select Best Answer