7 Comments

karim
March 13, 2015 at 3:15 pm
CREATE TABLE Records
(ID int(10),
Name char(20),
Address Char(50),
Phone int(10), );
INSERT:
INSERT INTO Records
(ID, Name, Address, Phone),
VALUE (581, john, 43809 Blossom hill Ashburn va, 7032915060);
UPDTE:
UPDARE Records
SET Name=Mike, Address= 2131 lees mill hill Dallas tx 75211, Phone=2713396905,
WHERE ID=581;
SELECT ALL:
SELECT * Records;
SELECT ID AND NAME:
select name, address from records;
ALTER TABLE:
to add column to a table:
alter table Records
add personal_contact varchar2(20);
DELETE:
delete records;
Log in to Reply

Pamela halbhavi
March 14, 2015 at 6:49 pm
Most of these tested on Oracle 10 and working
Create a Table name as RECORDS, Where columns are- Id, Name, Address, Phone. –
Create table RECORDS(
id Int not null,
Name varchar2(30),
Address varchar2(55),
Phone varchar2(20));
INSERT –
Insert into RECORDS
values(01,’Alex’,’AAAAAAA’,’7031112222′);
UPDATE –
Update RECORDS
set Name =’Alexis’ where Id=01;
SELECT all –
Select * from Records;
SELECT Id and Name –
Select Id, Name from Records;
SELECT with WHERE clause –
Select * from RECORDS where id = 04;
DELETE –
Delete RECORDS where Id = 05;
ALTER table –
ALTER table RECORDS
add Mobile varchar2(20);
Log in to Reply

nasir
March 22, 2015 at 4:32 pm
Create Table RECORDS(PersonID int, Name varchar(255), Address varchar(255), Phone varchar(20),);
INSERT
(id,name,address,phone),
value(‘001′,’ali’,’2391 rolling fork circle herndon va’,’2027585300′);
UPDATE
set name=’palwinder’where id=010;
SELECT all
SELECT * from Records;
SELECT Id and Name
SELECT Id,Name from Records;
SELECT with WHERE clause
SELECT * from RECORDS where Id=10;
DELETE
Delete RECORDS where ID=10;
ALTER Table
add postalcode varchar(10)
Log in to Reply

Palwinder
March 23, 2015 at 5:25 am
CREATE TABLE Records
(ID int(15),
Name char(25),
Address Char(60),
Phone int(10), );
INSERT:
INSERT INTO Records
(ID, Name, Address, Phone),
VALUE 100, TONI1,(817,walker rd, great falls va 22066);
UPDTE:
UPDATE Records
SET Name=toni,2262 stone wheel dr reston ,va ,22066
WHERE ID=100;
SELECT ALL:
SELECT * Records;
SELECT ID AND NAME:
select name, address from records;
add personal_contact varchar2(27);
DELETE:
delete records;
ALTER TABLE:
to add column to a table:
alter table Records
Log in to Reply

Olubunmi Ogunsola
March 24, 2015 at 7:16 pm
CREATE TABLE
(ID(10), Country Char(30),Name Char(45)
Insert INTO records
(ID, Country, Name)
(1, Brazil, Juninho);
Update Records
SET Name=Juninho, Brazil
WHERE ID=1;
Select all
SELECT *
WHERE Country=Brasil;
Delete
delete records;
Alter Table
Add City varcahr(25);
– Tomiwa
Log in to Reply

sivi ramesh
March 28, 2015 at 6:46 pm
CREATE TABLE Records
(ID int(20),
Name char(30),
Address Char(50),
Phone int(15), );
INSERT:
INSERT INTO Records
(ID, Name, Address, Phone),
VALUE (001, Ram, 12941 waterparkview,herndon va, 7032223333);
UPDTE:
UPDARE Records
SET Name=TOM, Address= 12920 sand lake Reston 20168, Phone=5404556666,
WHERE ID=009;
SELECT ALL:
SELECT * Records;
SELECT ID AND NAME:
select name, address from records;
ALTER TABLE:
to add column to a table:
alter table Records
add personal_contact varchar2(40);
DELETE:
delete records;
Log in to Reply

Jay
August 17, 2015 at 5:14 pm
delete will remove particular record from table, truncate will remove all rows but save table, drop will remove table (table and data will be lost)
Log in to Reply