Declare variables
PL / SQL

Is the development of procedural SQL language, standard language for accessing data in relational database from oracle coorperation.

STRENGTHS PL / SQL:

1. INTEGRATION

2. PL / SQL in Oracle Tools

3. Improve performance

PL / SQL Block Structure Read the rest of this entry »

In 1994 two people working on the software company Rational James Rumbaugh who developed OOD (Object Oriented Diagram) and Grady who developed Broach OMT (Object Modeling Language). Then in October 1995 they were creating a Unified method version 0.8. Then in the fall of 1995 Ivan Jacobson joined the two of them introduces Use Case Tool. In June 1996 the three of them create UML (Unified Modeling Language) version 0.9. Finally, in January 1997 created the UML 1.0 version before dibetuklah konsersium of several software companies. In September 1997 was born UML version 1.1 with 8 pieces diagrams, ie sequence diagrams, activity diagrams, collaboration diagrams, class diagrams, use diagrams, statechart diagrams, component diagrams and deployment diagrams. In 1999 was born UML version 1.3 with the addition of use case diagrams bone. In May 2001 born UML version 1.4 with the addition of object diagrams. In March 2003 born UML version 1.5. At the end of 2003 was born UML version 2.0 with the addition of composite structure diagrams, interaction diagrams overflow, timming package diagrams and charts. And the change of communication, Read the rest of this entry »

At the moment we are using oracle dev 6i we need to connect to oracle 9i database to retrieve data that will be used in using oracle developer 6i.

previous course we must make sure oracle 9i and oracle dev 6i done properly installed. So how do we connect it, how very simple, namely:

1. open folder oracle on C:.

2.open folder Oracle,then select the folder oracle 9i (with folder names during installation) example: ora9i.

3.select network folder. Read the rest of this entry »

SYSTEM DEVELOPMENT LIFE CYCLE

CONCEPT relational database

1. First proposed by Dr.EFCodd in the 1970s.

2. Where is the basis of Relational Database Management System (RDBMS).

3. Model relasional mencakup hal-hal berikut ini: Relational model include the following:

* Collection of objects and relationships.

* The set of operators to operate the relation.

* Data integrity for accuracy and consistency.
<!–[if !supportLineBreakNewLine]–>
<!–[endif]–> Read the rest of this entry »