What is difference between varchar and varchar2?
Varchar means fixed length char, varchar2 means variable length char.
Difference between oracle8i and oracle9i?
a. The biggest difference between Oracle8i and Oracle9i is that Oracle9i lets you resize the SGA memory areas dynamically i.e., the Database Buffer Cache DB_CACHE_SIZE or the SHARED_POOL_SIZE, etc., can be resized when the database is up and running. The same is not possible with Oracle8i. You can get more information from OTN.
b. Oracle 9i is an enhanced version of the Oracle 8i. Oracle 8i does not provided time stamping facility, which is provided in Oracle 9i.
c. You can drop a column in oracle 9i using alter table command where as this is not available in oracle 8i.
d. Database performance ease of management scalability security availability Windows 2000 integration and application areas: Internet content management commerce integration packaged applications Business Intelligence native compilation of PL/SQL reduction in latch contention (SGA locks) and I/O improvements better Java performance (better compilation, improved garbage collection) distributed database performance enhancements enhanced 3-tier security (integration with LDAP...) improved hosting security (through use of virtual private databases), fine-grained auditing and single sign-on improved user security (more password management features, etc.) Ability to encrypt stored data row-level access control (Oracle Label Security).
e. Listed below are some of the features of 9i:
What is Pro*C? What is OCI?
OCI: - OCI refer to Oracle Call interface is set of Low Level API (Application
Program Interface Call) used to interact with Oracle Database. By OCI one
can use the operation such as Logon, Fatch, parse, execute etc. Generally
these are written in C/C++.
What is the difference between "NULL in C" and "NULL in Oracle?
The NULL in C treated as Zero or void. but in SQL NULL value is Non
or blank represented it can't manipulated.
In Oracle varchar2 takes dynamic space for storage then why char is still in oracle?
The major difference between varchar2 and char is fixed length and variable length. Varchar2 have variable length mean if we declare as 20 space and its use only 5 space the memory assign only 5. But in char takes daclare space while use any number space less than declare.
Have a Oracle Question
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.