Oracle DML Practice

-

What is Data Manipulation Language (DML)?

DML is referred to as a programming language that performs SELECT, INSERT, UPDATE, and DELETE operations. DML is some kind of command that manipulate data of oracle database tables.

 Command Examples are-

PGDICT4D Batch 13

/*

--select 5*9 from dual;

-- Table creation

create table student (st_roll number(4) primary key,

st_name varchar2(20), st_group char(1), st_beng number(3),

st_eng number(3), st_math number(3), st_total number(3));

select * from tab;

*/

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1000,'Md. Abdur Rashid','S',42,90,100);

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1001,'Md. Adur Salam','S',42,70,100);

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1002,'Md. Abdur Gaful','S',42,70,100);

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1003,'Mohsena','S',90,90,100);

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1004,'Abdus Salam','S',42,90,100);

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1005,'Khokon','S',85,90,100);

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1006,'Mr. Nobel','S',75,90,100);

insert into student

(st_roll,st_name,st_group,st_beng,st_eng,st_math)

VALUES

(1007,'Mr. Nobel','S',75,90,100);

/*

delete from student

where st_roll=1002;

*/




-- Table creation


DROP TABLE student;


-- Table Creation


create table student

(roll number(6),

name varchar2(20),sex char(1),CONSTRAINT STUDENT_ROLL_PK PRIMARY KEY (ROLL));

SELECT roll, name, sex FROM student;

-- Insert


insert into student (roll,name,sex) values (100000,'Md. Abdur RASHID','0');


insert into student (roll,name,sex) values (100001,'Md. Abdul Hamid','0');


insert into student (roll,name,sex) values (100002,'Md. Selimul Haque','0');


insert into student (roll,name,sex) values (100003,'Sharmin Akhtar','1');


insert into student (roll,name,sex) values (100004,'Debasis Das','0');


insert into student (roll,name,sex) values (100005,'Samsul Islam','0');


insert into student (roll,name,sex) values (100006,'Nasrin Yasmin','1');


insert into student (roll,name,sex) values (100007,'Sharmin Akhtar','1');


insert into student (roll,name,sex) values (100008,'Debasis Das','0');


insert into student (roll,name,sex) values (100009,'Rezaul Karim','0');


insert into student (roll,name,sex) values (100010,'Shamima Sultana','1');


cl scr;


-- Update


UPDATE student                    

SET name= 'Md. Nizam Uddin'

WHERE roll=100002;


SELECT roll, name, sex FROM student;


-- Multiple Conditions


UPDATE student                    

SET name= 'Md.Akbor Ali'

WHERE roll=100002 AND sex='0';



-- Conditional Delete


DELETE FROM student 

WHERE roll=100006;



-- Changing field width


ALTER TABLE student

MODIFY (name VARCHAR2(25));


-- Adding column


ALTER TABLE student

ADD (fname VARCHAR2(20));


-- Changing table name


RENAME student TO student1;


ALTER TABLE student1

DROP COLUMN fname;


ALTER TABLE student1

MODIFY (name VARCHAR2(24));



DESC student1;


cl scr;



SELECT roll, name, sex FROM student1;


SELECT roll, length(name), sex FROM student1

WHERE LENGTH(name) >=15;


cl scr;


SELECT max(roll), min(roll) FROM student1;



www.rashid-bd.info


Comments

Post a Comment

Popular posts from this blog

How to be an Innovative Speaker?

-
1. Innovation in Effective session conduct   Define your message of the session. •         Make it participatory. In your last line, ask questions and teach by name. The final 5 to 10 minutes will be dedicated to participant comments. •         Maintain start and Ending time. •          Concentrate on the audience's needs. Patience is required. Don't retaliate if the participants engage in unwelcome behavior. •         Boost your self-confidence on topics by reading daily papers, books, articles, senior lectures and self-experience. •         Prepare yourself. Write the last update date in a text box and put red color at the top right corner of your slide. •         Do not attend class until you have updated your slide. You won't show any slides that aren't based on current data. Pl...
Read more

Developing Personal Skills

-
  Developing Personal Skills Engr. Md. Abdur Rashid  PhD, NAPD Dear Officers and Staff, you must establish and ensure the long-term growth of your organization. Maintain the following managerial abilities in order to enhance personal skills on a daily basis while working. 1.                  1)       Self-assessment 2)       Creativity 3)       Innovation 4)       Listening and feedback 5)       Find self-satisfaction 6)       Leadership 7)       Team building 8)       Hunt knowledge 9)       Self-reliance and judgment 10)    Resilience 11)    Time management 12)    Stress management 13)    Control over anything 14)    Find satisfa...
Read more

Differences between the terms Science, Technology, and Engineering

-
What are the differences between the terms Science, Technology, and Engineering? Dr. Engr. Md. Abdur Rashid Director (Admin & Finance) NAPD Science Focus: The systematic study of the natural world through observation, experimentation, and analysis. Goal: To understand and explain the universe, its laws, and its phenomena. Methods: Scientific inquiry involves formulating hypotheses, conducting experiments, collecting data, and drawing conclusions. Examples: Physics, chemistry, biology, astronomy, geology. Technology Focus: The application of scientific knowledge to create tools, machines, and systems that solve problems or fulfill human needs. Goal: To improve efficiency, productivity, and quality of life. Methods: Technological development often involves innovation, design, and engineering. Examples: Computers, smartphones, automobiles, medical devices, renewable energy systems. Eng...
Read more