How to "reverse" a MassAllocation Journal Entry in Oracle?

What is the meaning of 'doc' command in oracle ? What are the use of it?

I have a request about adding new application at existing oracle 11gr2 database.

What questions should I raise with the vendor about there application and database setup requirements. Please give my answer at your earliest possible time, because my nagement waiting for the answers.

Thanks in advance.
Ibrahim

I want to create a database containing info about the student, i,e their resume with photo, how can i store these details directly to oracle database?

amahanit

 Profile Answers by amahanit Questions by amahanit

• Oct 8th, 2007

Use LOB data types

Answer Question  Select Best Answer

Mukesh

• Jan 20th, 2006

The size of controlfile depend on 5 different parameter at the time of creation of database.MAXLOGFILEMAXLOGMEMBERSMAXDATAFILESLOGHISTORYMAXINSTANCE.

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

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

Murugavel

• Aug 29th, 2006

Hi,I hope the difference is:execute() - returns boolean value (true implies that the query returns some Resultset, where false is not)executeUpdate() - returns integer value (the value implies number of rows affected)bye..

Answer Question  Select Best Answer

Suresh

• May 11th, 2006

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

Answer Question  Select Best Answer

Arijit Basu

• Oct 7th, 2006

How can I call a report from a from in d2k?

Answer Question  Select Best Answer

srinivas devulapalli

• Sep 12th, 2006

Toad Tool exist in not only importing or exporting the data but also creating the database objectthe object etc

Answer Question  Select Best Answer

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

developer

• Oct 11th, 2006

Hi Mukund,Developers and DBAs use these tools to get the best performance out of their applications. The execution plan is made available to you in the form of rows inserted into a special table calle...

Answer Question  Select Best Answer

Peter Wegner

• Nov 5th, 2006

You can use the oraenv script to ensure that user accounts are updated and to switch between databases.

Answer Question  Select Best Answer

Mano

• Sep 26th, 2006

Hi,select max(nvl(empno,000000))+1 from empU have to wrie this in pre_text_item trigger of the empno item.Check and confirm.Thanks and bye

Answer Question  Select Best Answer

sudheer

• Oct 17th, 2006

Hi,  We can't use relational operation in decode.where as we use in case stament.

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

Used to avoide parsing three mode  shared, exclusive and similarcursor_sharing=need to set this parameter on session or system level. this can also affect bind picking

Answer Question  Select Best Answer

gpsaravanan202

 Profile Answers by gpsaravanan202 Questions by gpsaravanan202

• Dec 12th, 2007

The only difference between rownum and level pseudocolumn  isRownum is used to order the datas according to their ranks and it is used in inline views..Level pseudocolumn is used in hierarchial retrival of database.....

Answer Question  Select Best Answer

pkjayan

 Profile Answers by pkjayan Questions by pkjayan

• Apr 29th, 2007

Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and Redo-Log fileS(minimum 2).  

Answer Question  Select Best Answer