pracs1_ddl_commands

pracs1_ddl_commands - ROLL_NO NUMBER(38) NAME VARCHAR2(50)...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 SQL> create table rishib(roll_no integer,name varchar(25)) Table created. SQL> desc rishib Name Null? Type ----------------------------------------- -------- -------------------------- ROLL_NO NUMBER(38) NAME VARCHAR2(25) SQL> alter table rishib add(marks integer) Table altered. SQL> desc rishib Name Null? Type ----------------------------------------- -------- -------------------------- ROLL_NO NUMBER(38) NAME VARCHAR2(25) MARKS NUMBER(38) SQL> alter table rishib modify(name varchar(50)) Table altered. SQL> desc rishib Name Null? Type ----------------------------------------- -------- --------------------------
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ROLL_NO NUMBER(38) NAME VARCHAR2(50) MARKS NUMBER(38) SQL> insert into rishib values(4,'Rishi Baldawa',527) 1 row created. SQL> insert into rishib values(3,'Deepak Agrawal',521) 1 row created. SQL> select * from rishib ROLL_NO NAME MARKS---------- -------------------------------------------------- ----------4 Rishi Baldawa 527 3 Deepak Agrawal 521 SQL> truncate table rishib Table truncated. SQL> select * from rishib Sheet1 Page 2 no rows selected SQL> drop table rishib Table dropped. SQL> desc rishib ERROR: ORA-04043: object rishib does not exist SQL>...
View Full Document

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Page1 / 2

pracs1_ddl_commands - ROLL_NO NUMBER(38) NAME VARCHAR2(50)...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online