SQLize Online / PHPize Online  /  SQLtest Online

create table Cred_emp_regi_t7 (eid number(6) , Firstname varchar2(35) , Lastname varchar2(25) , Mobile varchar2(16), address varchar2(35) ); describe Cred_emp_regi_t7; 101 Yusuf Tamboli 9766545454 Pune 102 Priya Patil 9878787878 Mumbai 103, Priti Singh +91-9878787878 Delhi 104 Amit Singh +91-9878787878 Delhi 106 yusuf tamboli +91-9878787878 Delhi insert into Cred_emp_regi_t7 values (101, 'Yusuf','Tamboli', 9766545454,'Pune'); insert into Cred_emp_regi_t7 values (102, 'Priya','Patil',9878787878,'Mumbai'); insert into Cred_emp_regi_t7 values (103, 'Priti','Singh','+91-9878787878','Delhi'); insert into Cred_emp_regi_t7 values (104, 'Amit','Singh', '+91-9878787878','Delhi'); insert into Cred_emp_regi_t7 values (106, ' ','tamboli','+91-9878787878','Delhi'); select * from Cred_emp_regi_t7; UPDATE TABLE update Cred_emp_regi_t7 set mobile=8668685713 where eid=104; ADD COLUMN alter table Cred_emp_regi_t7 add country VARCHAR2(50); select *from Cred_emp_regi_t7 DESCRIBE TABLE desc Cred_emp_regi_t7 TABLE MODIFY alter table Cred_emp_regi_t7 modify eid number(10); select * from country; select * from customer; select * from country inner join customer on country. country_id=customer.country_id; select * from country right join customer on country. country_id=customer.country_id; select * from country left join customer on country. country_id=customer.country_id; select * from country full join customer on country. country_id=customer.country_id select * from country join customer on country. country_id=customer.country_id;