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

kumaresan.m

 Profile Answers by kumaresan.m Questions by kumaresan.m

• Sep 12th, 2006

high water mark is concerned with segments not with the datafilesafter analysing the segments, this query will give the hwm for the segmentselect (blocks-empty_blocks) HWM from dba_segments where segment_name=upper('name') and segment_owner=upper('name');

bhanushiva

 Profile Answers by bhanushiva Questions by bhanushiva

• Jan 19th, 2006

There is no single system table which contains the high water mark (HWM) for a table. A table's HWM can be calculated using the results from the following SQL statements: SELECT BLOCKS ...

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

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

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

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

lax

• Aug 22nd, 2006

A candidate key is a key that uniquly identifies

sandeep kumar

• Jan 16th, 2006

key is the attribute that can uniquely identify specified record from  a table. Any key i.e. attribute or combination of attributes can be selected as primary key. the remaining key attributes ar...

Answer Question  Select Best Answer

Padmanathan

• Aug 20th, 2006

Hi,select owner, segment_name,bytes/1024/1024 "Size in Mb" from dba_segments where segment_type=<TABLE_NAME>This is total size physicall occupiedfor actual size:Analyze the table first using DBM...

harsha

• May 11th, 2006

How to get the size of the specified table i.e for a particular table??

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

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

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

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