Oracle Database lab Application

Authorization:

1. Create UserTempUser identifiedBySa
2. DefaultTablespace users
3.  TemporaryTablespaceTempQuota unlimitedOnUsers;
5. CreateProfile tempprofile LIMIT
6. SESSIONS_PER_USER 3
7. CPU _ per_call 2000
8. IDLE_TIME 15
9. LOGICAL_READS_PER_CALL 200
10. FAILED_LOGIN_ATTEMPTS 2;
12. -- Specify the configuration file for the user
14. Alter UserTempUser profile tempprofile;
16. -- Permissions granted to users
18. Grant CreateSessionToTempUser;
20. Grant Select OnStudentToTempUser;
22. ConnectTempUser/sa;
25. -- Revoke User Permissions
26. Revoke Select OnSystem. studentFromTempUser;
28. Revoke CreateSessionFromTempUser;

View:

1. Create Or Replace ViewStudent_MathAs
2. Select*FromStudent
3. WhereSclassIn(
4. SelectC.Name FromClass c, department d
5. WhereC. department = d. did
6. AndD. DNAME ='Department of mathematics')
7. With CheckOpition;
8. )
11. Create Or Replace ViewDepartment_ClassAs SelectD. dna m, c, cname
12. FromClass c, department d
13. WhereC. department = d. did;
15. SelectTextFromUser_viewsWhereView_name =UPPER('Student _ math');

Sequence:

1. Drop TableSequence_table;
2. Create TableSequence_table (
3. Id number,
4. Op varchar2 (20)
5. )
6. /
8. Drop SequenceIncr_id;
9. Create SequenceIncr_id
10. StartWith100
11. IncrementBy1
12. Nomaxvalue
13. Nocycle
14. Order;
15. /
17.  Create Or Replace TriggerIncr_trigger
18. BeforeInsert OnSequence_table
19. ForEach row
20. Declare
21. Next_no number;
22. Begin
23. SelectIncr_id.nextval
24. IntoNext_no
25. FromDual;
26. : NEW. ID: = next_no;
27. End;
28. /
30. -- Test
32. Insert IntoSequence_table (op)Values('Insert');
34. Select*FromSequence_table;
36. -- View the sequence status
38. Select*FromUser_sequencesWhereSequence_name =UPPER('Incr _ id');

Things:

1. -- The isolation level of a transaction is read committed.
2. Set Transaction Isolation Level Read Committed;
4. SelectSnameFromStudent;
5. -- If it is not submitted, the previous transaction is not processed.
6. Commit;
8. -- Serializable
9. Set Transaction Isolation Level Serializable;
11. SelectSname, ageFromStudent;
13. UpdateStudentSetAge = 23
14. WhereSname ='Bruce Lee';
15. -- Rollback;
16. Rollback;
17. SelectSname, ageFromStudent;
19. -- Savepoint section storage point

1 2 Next Page