Sunday, January 4, 2009

Oracle Application Express (Apex)

Oracle Application Express (Apex)

It is a HTML Database where the database can be accessed anywhere following the url and credetials apart from this ,the basic repoting and query handling can also be done in apex .
The main basic three components present in apex are
1)Application Builder
1.1)Create Application
1.2)View Application
1.3)Demonstration
1.4)Application Adminstration
1.4.1)In This we can Manage services Activities and apex users as well.
1.5)Import
2)Sql Workshop
2.1)Object Browser
2.1.1)Create objects
2.1.2)Browse objects
2.2 )Sql Commands
2.2.1)Enter Commands
2.3)Sql Scripts
2.3.1)Create
2.3.2)Upload
2.3.3)View
2.3.4)Export
2.3.5)Import
2.4)Query Builder
2.4.1)Create
2.4.2) view
3)Utilities
3.1)DataLoad/Unload
3.1.1)Load
3.1.2)Unload
3.1.3)Repository
3.2)Generate DDL
3.3)Object Reports
3.3.1)Table Reports
3.3.2)Expection Reports
3.3.3)Security Reports
3.3.4)All objects Reports
3.3.5) PL/SQl Reports
3.4)Recycle Bin
3.5)Database Monitor
3.5.1)Sessions
3.5.2)System Statistics
3.5.3)Top SQL
3.5.4)Long Operations
3.6)Apex Views
3.7)Schema Comparisons
3.8)About Database

No comments: