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

How to declare a local variable?

1119

What is an Oracle Instance?

1123

What is the difference between view and materialized view in Oracle?

1156

Will you be able to store pictures in the database?explain.

992

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2234

What is literal?

1007

Can group functions be mixed with non-group selection fields?

1020

What is SQL access advisor in Oracle?

1191

What does sharding mean?

1001

What is blob datatype?

1130

What are the parameters that we can pass through a stored procedure?

1065

What is an oracle?

1018

How to convert characters to dates in oracle?

1101

How to start your 10g xe server from command line?

1073

What is recycle bin in Oracle?

1151