Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2014
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.24 KB | None | 0 0
  1. Prac 7(a):-
  2.  
  3. create table R1 (rollno number(2)primary key,name char(10),dept char(4));
  4. insert into R1 values(&rollno,&name,&dept);
  5.  
  6. insert into R1 values(&rollno,&name,&dept);(enter same rollno it ll give an error)
  7.  
  8.  
  9. create table student2 (rollno number(2)primary key,name char(10),dept char(4)not null);
  10.  
  11. insert into student2 values(&rollno,&name,&dept);
  12. (after 1 entry dont enter any dept it ll give an error )
  13.  
  14.  
  15. create table R2 (name char(10),sid number(4)primary key,address varchar(10));
  16. insert into R2 (&name,&sid,&address);
  17.  
  18.  
  19.  
  20. create table R3 (rollno number(2),sid number(4)references R2);
  21. insert into R3 (&rollno,&sid);
  22. (enter some another sid no not present in R2)
  23.  
  24.  
  25. create table R4 (rollno number(2),name char(10),dept char(4),check (dept in ('CT','It','MECH'));
  26. insert ......(error if entered other branch then given)
  27.  
  28.  
  29.  
  30. create table R5 (rollno number(2),sid number(4)default(50));
  31. insert ....
  32.  
  33. ----------------------------------------------------------------------------------------------------------------------------------------
  34.  
  35. Prac 11th :-
  36. create table emp(eno number(4),name char(10),salary number(7))
  37. insert into emp (&eno,&name,&salary);
  38.  
  39. get c:/17sql
  40. declare
  41. emp_no emp.eno%type;
  42. nam emp.name%type;
  43. begin
  44. select name into nam from emp where sal>40000;
  45. dbms_output putline("employee name:"//nam);
  46. end;
  47. .
  48.  
  49. //for display
  50.  
  51. set serveroutput on;
  52.  
  53. -----------------------------------------------------------------------------------------------------------------------------------
  54.  
  55. 12Th PrACTICAL :-
  56.  
  57. SQL> create table demo6
  58. 2 (eno number(4),name varchar(10), salary number(7));
  59.  
  60. Table created.
  61.  
  62. SQL>insert into demo6 values(&eno,&name,&salary);
  63.  
  64. SQL> create table backup7(rollno number(5),salary number(7));
  65.  
  66. Table created.
  67.  
  68. SQL>get c:/12.sql
  69.  
  70. create trigger up
  71. 2 before update on demo6
  72. 3 for each row
  73. 4 begin
  74. 5 insert into backup7 values(:old.rollno,:old.salary);
  75. 6 end;
  76. 7 /
  77.  
  78. Trigger created.
  79.  
  80.  
  81.  
  82. SQL> insert into demo6 values(8,40000);
  83.  
  84. 1 row created.
  85.  
  86.  
  87. SQL> update demo6 set salary=80000
  88. 2 where rollno=8;
  89.  
  90. 1 row updated.
  91.  
  92. SQL> select * from backup7;
  93.  
  94. ROLLNO SALARY
  95. ---------- ----------
  96. 8 40000
  97.  
  98.  
  99. SQL> select * from demo6;
  100.  
  101. ROLLNO SALARY
  102. ---------- ----------
  103. 8 80000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement