Previous Next
Database Connectivity
Step to create Data Base Connectivity (Visual Basic with Oracle)
Step-I
Create Table in Oracle
Step – II
Create Data Source
Step –III
Connect Database
Step –I Create Table in Oracle
Syntax
CREATE TABLE "table_name"("column 1" "data_type_for_column_1","column 2" "data_type_for_column_2",... )
So, if we are to create the Student table specified as above,
Example
CREATE TABLE student
(Name char(50),
reg_no number(10),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)
