English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Specifically a table that has this syntax

create table students (
Student_ID number primary key
FirstName varchar(50),
LastName varchar(50),
SSN varchar(20),
Address varchar(50),
PhoneNo numeric(12),
LetterGrade varchar(2),
FGPER numeric(10)
)

2007-06-11 01:16:36 · 3 answers · asked by Anonymous in Computers & Internet Programming & Design

3 answers

INSERT INTO students VALUES (data goes here in order of columns);

INSERT INTO students (column names go here) VALUES (Data goes here);

2007-06-11 01:32:44 · answer #1 · answered by MarkG 7 · 0 0

insert into students
values ( 1, ´Adam´, ´Smith´, ´XXX´, ´55, Main St´, 115550123, ´C´, 123456 )


p.s.: use single quote for varchar or char

2007-06-11 08:29:19 · answer #2 · answered by RodrigOF 1 · 0 0

I think the DBEasy 2.02 software can help you. It is easy to manage oracle databases.

2007-06-12 04:15:40 · answer #3 · answered by Anonymous · 0 0

fedest.com, questions and answers