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;
WHERE table_name = '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 Cred_emp_regi_t7
set mobile=8668685713 where eid=104;
alter table Cred_emp_regi_t7
add country VARCHAR2(50);
select *from Cred_emp_regi_t7;
DESCRIBE TABLE
desc Cred_emp_regi_t7
alter table Cred_emp_regi_t7
modify eid number(10);
select * from Cred_emp_regi_t7_BKP;
select * from(select emp.*, rownum from emp order by rownum desc)where rownum<=5
select * from emp where mod(eid,2)=1
create table Cred_emp_regi_t7 (
eid number(6),
Firstname varchar2(35),
Lastname varchar2(25),
Mobile varchar2(16),
address varchar2(35)
)
Telegram: DB developers channel