Modes of Operation in Oracle Forms and Retrieving Data
Oracle Forms Developer has two types of modes of operation , one is Enter-Query mode and other is Normal mode. We use Enter-Query mode to enter search criteria for a …
How to Install WAMP Server on Windows PC
If you are making a website or testing a project which requires Apache, MySQL & PHP, you can install and test that from your windows PC easily. Did you ever …
CREATE Trigger by Using OLD and NEW Qualifiers
Basically OLD and NEW qualifiers are used for row-level trigger. When a row-level trigger is createsand fires, the PL/SQL run time engine creates and populates two data structures that are …
Create Triggers that are Invoked by DML Operations
What are Triggers? Triggers are similar to stored procedures. A trigger is a PL/SQL block that is stored in the database. A trigger is automatically executes by the Oracle database when …
Best Keyboard Shortcut Keys
Keyboard Shortcuts (Microsoft Windows): ================================ ALT+ENTER (View the properties for the selected item) ALT+F4 (Close the active item, or quit the active program) ALT+ENTER (Display the properties of the selected …
Use of Concatenation Operator in SQL
Concatenation operator is used to links or add columns or character srtings to other columns or character. Concatenation is represented by two vertical bars (||). When we use concatenatin operator, …
Declaring and Naming JavaScript Variables
Variable are used as a container, where we can put different types of value into this container, and then we can use or manipulate this value, also replace the container …
How to Install Oracle Developer Suite 10G
1/ Go to the oracle.com. 2/ Put mouse pointer on the Downloads menu and click on the Developer Tools from drop down menu. 3/ After clicking, go to …
Basic Rules of JavaScript Syntax
Basically JavaScript syntax is used to write JavaScript properly. In definition, it is a set of rules that define how JavaScript program are constructed or correctly structured JavaScript program. …
SQL SELECT Statement Using WHERE Clause
When we need specific information or data or row from the database then we can use WHERE clause to restrict or specific data. A WHERE clause directly follows the FROM …
