Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Bitmap Join Indexes -
This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization-This feature enable in prevention of storage problems that are associated with multi-byte characters sets by using character semantics while defining table columns in data.
Data Guard-As this feature is there in every database Oracle9i Data Guard is the new name for in technology advancements ofOracle8i which Standby Database inception of a large number of new advance features.
Export and Import Enhancements in Oracle9i-this is the unique feature that is there in oracle 9I to export and import enhancement through Oracle 9i, See what new functionality has been incorporated into the Export and Import utilities in Oracle9i. Flashback Query-this feature will allow the adept and rational view of the data at an earlier or any point in time.
High Availability Enhancements in Oracle9i-By advancing the ability it detains downtime for users by adopting the new high availability features of Oracle9i.
Index Organized Table (IOT) Enhancements in Oracle9i-It gives developer a better support for secondary indexes and much improved online maintenance as heap tables.
Apart from those above, other new features are below. They are list of differences that oracle 10g have in contrast to 9i
In 2005 after the successful of oracle 19G oracles released another variant of oracle 10 G that is Oracle 10G release 2.
This is also having some alluring and unique features than oracle 10G relase1
Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL
Initializing and Referencing Collections Until you initialize a collection, a nested table or varray is automatically null (i.e. the collection itself is null, not its elements)
Query: SELECT * FROM EMPLOYEE1; Select 5 columns and all rows from one table Query: SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;
Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference
FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent
Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an
Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur
First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst
Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to
Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd