Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Prac 7(a):-
- create table R1 (rollno number(2)primary key,name char(10),dept char(4));
- insert into R1 values(&rollno,&name,&dept);
- insert into R1 values(&rollno,&name,&dept);(enter same rollno it ll give an error)
- create table student2 (rollno number(2)primary key,name char(10),dept char(4)not null);
- insert into student2 values(&rollno,&name,&dept);
- (after 1 entry dont enter any dept it ll give an error )
- create table R2 (name char(10),sid number(4)primary key,address varchar(10));
- insert into R2 (&name,&sid,&address);
- create table R3 (rollno number(2),sid number(4)references R2);
- insert into R3 (&rollno,&sid);
- (enter some another sid no not present in R2)
- create table R4 (rollno number(2),name char(10),dept char(4),check (dept in ('CT','It','MECH'));
- insert ......(error if entered other branch then given)
- create table R5 (rollno number(2),sid number(4)default(50));
- insert ....
- ----------------------------------------------------------------------------------------------------------------------------------------
- Prac 11th :-
- create table emp(eno number(4),name char(10),salary number(7))
- insert into emp (&eno,&name,&salary);
- get c:/17sql
- declare
- emp_no emp.eno%type;
- nam emp.name%type;
- begin
- select name into nam from emp where sal>40000;
- dbms_output putline("employee name:"//nam);
- end;
- .
- //for display
- set serveroutput on;
- -----------------------------------------------------------------------------------------------------------------------------------
- 12Th PrACTICAL :-
- SQL> create table demo6
- 2 (eno number(4),name varchar(10), salary number(7));
- Table created.
- SQL>insert into demo6 values(&eno,&name,&salary);
- SQL> create table backup7(rollno number(5),salary number(7));
- Table created.
- SQL>get c:/12.sql
- create trigger up
- 2 before update on demo6
- 3 for each row
- 4 begin
- 5 insert into backup7 values(:old.rollno,:old.salary);
- 6 end;
- 7 /
- Trigger created.
- SQL> insert into demo6 values(8,40000);
- 1 row created.
- SQL> update demo6 set salary=80000
- 2 where rollno=8;
- 1 row updated.
- SQL> select * from backup7;
- ROLLNO SALARY
- ---------- ----------
- 8 40000
- SQL> select * from demo6;
- ROLLNO SALARY
- ---------- ----------
- 8 80000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement