| Interview questions [message #168253] |
Wed, 19 April 2006 08:31  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
| received via PM |
My questions are
1)Advantages of Oracle 9i over prior releases?
2)Differences between CHAR,VARCHAR and VARCHAR2?
3)Features of 10g?
4)briefly about oracle versions(like oracle 7i,8i.....) till?
Thank you!
shanti
|
MHE
|
|
|
|
| Re: Interview questions [message #168256 is a reply to message #168253] |
Wed, 19 April 2006 08:46  |
|
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
1) Read the documentation. The site requires a free account. Search for the "Oracle9i Database New Features"
Some highlights of 9iR1: CASE statements, ANSI-compliant joins, introduction of TIMESTAMP data types, the use of SPFILE/PFILE, DBMS_METADATA, ...
2) CHAR is blank-padded, VARCHAR2 isn't. VARCHAR is in fact the same as VARCHAR2 but this might change in the future so Oracle recommends you to use VARCHAR2.
3) For 10g there's also a new features guide on the site mentioned above.
4) look here.
MHE
[Updated on: Mon, 19 June 2006 01:15] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
