180 likes | 312 Views
ORACLE SESSION. ORACLE SESSION. Execute IE to link to the website of ORACLE iSQL*Plus https://oraeng01.syr.edu:5560/isqlplus Login in Username is your NetID username, Password is orange , Connect Identifier is cse581. ORACLE SESSION. We will discuses :
E N D
ORACLE SESSION CSE 581,EECS, SU
ORACLE SESSION • Execute IE to link to the website of ORACLE iSQL*Plus https://oraeng01.syr.edu:5560/isqlplus • Login in Username is your NetID username, Password is orange , Connect Identifier is cse581 CSE 581,EECS, SU
ORACLE SESSION • We will discuses : • Create table, • Insert/Delete/Update data, • Drop table, CSE 581,EECS, SU
Login into ORACLE iSQL*Plus https://oraeng01.syr.edu:5560/isqlplus CSE 581,EECS, SU
Work Space of ORACLE iSQL*Plus CSE 581,EECS, SU
EXAMPLE DATA CSE 581,EECS, SU
CREATE ATABLE • CREATE TABLENAME (attr1 datatype1, attr2 datatype2,…); Datatype examples - number(e.g. 1024), real or float (10.24), varchar2(‘ABC12’) CSE 581,EECS, SU
INSERT TO TABLE (Ⅰ) • INSERT INTO tablename VALUES(value1,value2…) CSE 581,EECS, SU
RESULTS after INSERT • SELECT * FROM CSE581; CSE 581,EECS, SU
INSERT TO TABLE (Ⅱ) • INSERT INTO tablename (attr1, attr2) VALUES(value1,value2) CSE 581,EECS, SU
RESULTS after INSERT • SELECT * FROM CSE581; CSE 581,EECS, SU
DELETE DATA CSE 581,EECS, SU
RESULTS after DELETE • SELECT * FROM CSE581; CSE 581,EECS, SU
UPDATE DATA CSE 581,EECS, SU
RESULTS after UPDATE • SELECT * FROM CSE581; CSE 581,EECS, SU
DROP A TABLE • DROP TABLE tablename; CSE 581,EECS, SU
End CSE 581,EECS, SU