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 👇 YouTube Link :- https://www.youtube.com/channel/UC8U2tW9d8N_qosD8739Id5Q