Oracle E-Business Suite

Oracle E-Business Suite consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications. It contains several products:

• Oracle CRM
• Oracle Financials
• Oracle HRMS
• Oracle Mobile Supply Chain Applications
• Oracle Order Management
• Oracle Procurement
• Oracle Project Portfolio Management
• Oracle Quotes
• Oracle Transportation Management
• Oracle Warehouse Management Systems
• Oracle Inventory
• Oracle Enterprise Asset Management

SQL Developer

The SQL Developer is an IDE for working in Oracle Database and gives the developer a quick overview of the entire database. It is developed by Oracle Corporation in Java and it is free for use.

SQL Developer can connect to any Oracle Database version 9.2.0.1 and later and runs on Windows, Linux, and Mac OSX. Default connectivity to the database is through the JDBC Thin driver (no Oracle Home required); the JDBC Type 2 driver (OCI client side driver) is also supported.

Toad

Toad -> Tool for Oracle Application Development
A product of Quest Software
Overview of Toad
-------------------
Toad provides the following features and benefits:
1. SQL Development
2. Data Management Reporting
3. PL/SQL Development
4. Application Development
5. Database Administration
6. Optimization and Tuning

Short-cuts:
-----------
F1 -> Help
F2 -> Toggle output Window
Shift+F2 -> Toggle Data Grid Window
F4 -> Describe Oracle objects like Table, view, Procedures, Functions, etc
F5 -> Executes the selection or entire screen as a script.
F7 -> Clear all text
Ctrl + L -> Convert text to Lower Case
Ctrl + U -> Convert text to Upper Case
Ctrl + Z -> Undo
Ctrl + Enter -> Execute the current query
Shift+F9 -> This will run only the SQL that your cursor is on. You do not need to highlight the line or the entire SQL statement; simply place your cursor anywhere inside the SQL statement and click SHIFT-F9.
Ctrl + F -> Find the String