Saturday, November 7, 2009

INDEX SQL / PLSQL DATABASE CONNECTIVITY


SQL/ PLSQL PROGRAMS


Create Queries
View Querie
Insert Querie
DELETE Querie
Update Querie
Select Querie
Sub Queries
JOIN Querie
Outer JOIN Querie
GRANT
REVOKE
High level language extensions – PL/SQL
Control Flow in PL/SQL
Cursor
Implicit Cursors
Explicit Cursors
To use Explicit Cursor
To access an Explicit Cursor
PL/SQL Procedures
Execute a Stored Procedure
PL/SQL Functions
Execute a PL/SQL function

Database Connectivity



Step to create Database Connectivity (Visual Basic with Oracle)
Step-I Create Table in Oracle

Step – II Create Data Source (Click on Step )


Step - 1
Step - 2
Step - 3

Step –III Database Connectivity ( Click on Step)

Step – 1
Step - 2
Step - 3
Step - 4
Step - 5
Step - 6
Step -7
Step - 8
Setp -9

No comments:

Post a Comment