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

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

indifa

• Sep 4th, 2007

Select * from dba_objects where owner = 'GL' and object_type = 'TABLE'Change GL to AP and AR for respective table info.

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

srinivas

• Aug 24th, 2006

If we have same triggers at form level, block level and item level, then the triggers at lowest level will take first priority. so the sequence is item level, block leven and form level.

Cnu

• Mar 18th, 2006

The default execution hierachy is Item-levelBlock-LevekForm-LevelIf u want to change the execution Hierarchy u can set the trigger property from override to Before or After as per ur requirement.Regards.,Cnu.,

Answer Question  Select Best Answer

lokesh

• Oct 4th, 2007

Here we need to use system parametrs which are available in report module.DESTYPE OR DESTNAME we need to use to print the output in specified printer.

Answer Question  Select Best Answer

naveen5555

 Profile Answers by naveen5555 Questions by naveen5555

• Sep 22nd, 2007

Installation of ORACLE 9i in LinuxRefer this page http://ivan.kartik.sk/oracle/install_ora9_elinux.html#st1

Answer Question  Select Best Answer

hkrishna

 Profile Answers by hkrishna Questions by hkrishna

• Jul 28th, 2008

Hi Friend,Question is not clear, I think you need to add a column for particular table.Just do like, alter table add column datatype;this will take you add a column in a table.

Answer Question  Select Best Answer

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Jul 10th, 2007

Hi,The databse domain are the differenet types of database. Database domain can be Oracle, MS SQL Server, Sybase etc. It's depend on user on which database domain he can work better.Suppose if we select oracle there different domains are: Oracle 9i, Oracle 10G and Oracle 11i etc.

Answer Question  Select Best Answer

kirangsv

 Profile Answers by kirangsv Questions by kirangsv

• Jun 2nd, 2008

Co-related sub-query:- The main differencre between subquery and co-related subquery is that in subquery child query is executed first n then parent,but in co-related subquery main query is executed...

Answer Question  Select Best Answer

lieni

• Jul 30th, 2007

there are many tips!1) inside a cursor never  perform an other sql or call a function performing an sql, join that table better to the cursor body.2) perform bulk operations3) avoid in (subselect...

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 26th, 2007

You can use the proc *C in the pl/sql. and for the second question you have to configure it e.g isqlplus/ oem grid etc

Answer Question  Select Best Answer

Suman

• Sep 7th, 2006

Hi,   Could you please tell me more clearly on "Grid Technology" and how it is  different from other Oracle version say,Oracle 9i?Thanks in advance.     &n...

Nishanth

• Aug 17th, 2006

The g in ORACLE 10g means GRID TECHNOLOGY10g is Oracle's grid computing product group including (among other things) a database management system (DBMS) and an application server.

Answer Question  Select Best Answer

developer

• Sep 11th, 2006

Hi,The correct answer isselect to_char(to_date(15000,'j'),'jsp') from dual;try this one. hope this will help u.byedevp2.

satya

• Sep 6th, 2006

I think it is correct , there is no word called Lakh in US English. Try switch to language UK english then it may work.    Lot of people in USA dont understand certain UK english words.

Answer Question  Select Best Answer

Vijay Akumalla

• Dec 20th, 2006

Hi,If a Form Item's property needs to be changed, then it should be done from a form trigger and not a database trigger. You can use Visual Attributes or Property Classes to achieve this or a form tri...

Answer Question  Select Best Answer

svinaymbd

 Profile Answers by svinaymbd Questions by svinaymbd

• Jun 12th, 2008

Hito convert report in excel format your need to install desktop patch on your client and should have the xml publisher responsibility as a developer you need to create a first you need to convert you...

Answer Question  Select Best Answer

The main important aspect is physical data model is created after logical data model. For designing a logical data model one need not have through knowledge in any specific RDBMS like oracle, Informix and so on. This is because logical data model is created after having through study of the business entities which would be involved in the application. The same can be represented by using E-R diagram...

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Jul 10th, 2007

Logical vs Physical Data ModelingLogical Data ModelPhysical Data ModelRepresents business information and defines business rulesRepresents the physical implementation of the model in a database.Entity...

Answer Question  Select Best Answer

Truncate command will delete all records and the most important thing to make note of truncate command is since truncate command cannot be rolled back one must make sure to take proper backup of table data before performing the truncate command. Truncate command is thus used to remove all rows from either a table or a cluster. If one wants to use the truncate command in a cluster they can use it only...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

* Used to Delete all the datas in a table .* Cannot be rollbacked.

Answer Question  Select Best Answer

The programmer may like the database o take some action when a database event occurs. In order to achieve the above purpose triggers are defined. The trigger body refers to the code written within the trigger which gets fired and executed when the related database event associated with the trigger occurs. On this situation one may have the question what is the event on the happening of which triggers...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

 trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures.Triggers are implicitly fired by Oracle when a triggering event occ...

Answer Question  Select Best Answer

matvin

• Apr 20th, 2007

Pre-query trigger fires before the query excutes and fires once while you try to query. With the help of this trigger you can modify the where clause part dynamically. Post-query fires after query exc...

Answer Question  Select Best Answer