Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

difference between oracle8i and oracle9i

Question Posted / kalpana

Answer Posted / kalpana

merge is a command which is used to both insert and delete.
timestamp datatype is introduced.
max no of columns in 8i is 256 where as in 9i we can have
999.
on delete set null supports only in 9i.
by using this, when we delete the parent record the child
records are replaced with null values

Is This Answer Correct ?    11 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle?

1063

What is an oracle database?

1102

How to use fetch statement in a loop?

1066

How many data types are supported?

1133

what is IDE,DMV in sql server?

2878

Why do we use coalesce function in oracle?

1164

How to define a data source name (dsn) in odbc manager?

1077

What's dateware house and what's clustor with practicle example

2231

What are set operators?

1135

How to update values in a table in oracle?

1075

How to create a table index?

1222

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2544

Explain the use of owner option in exp command.

1095

What is an oracle function?

1239

Hi Can any one tell me what are the API's used in requisition import.

1964