Create a table in Oracle .. insert a row.. update the data.. delete the row or table

Watch the full video for better understanding 👇

1. Create a table

Commands :-

create table students (

Name varchar(15),

Rollno int,

Age int,

Address varchar(15));

2. Insert a row

Command :-

insert into students values ('Raj', 21, 18, 'Thane' );

insert into students values ('Jay', 26, 17, 'Kalwa');

insert into students values ('Om', 28, 18, 'Mumbra');

*Click on the picture for clear view

To view the table :-

Command:-

Select * from students;

3. Update the table :-

Commands :-

Update students

Set rollno=24;

Where name like 'R%';

To view the table :-

Command:-

Select * from students;

4. Delete a row or table :-

For row :-

Command :-

delete from students where name like 'Raj';

For table :-

Command :-

drop table students;

Table dropped means table has been deleted.

Hope you understood.

Subscribe my channel on YouTube and get more ideas 👇

Programming Techniques