Scribd
Upload
2 views1 page

TCL Command Lab

The document outlines a series of TCL commands for managing a course table in a database. It includes creating a table with specific fields, inserting records, creating savepoints, deleting records, and performing rollbacks. The steps illustrate how to manipulate data and control transactions effectively.

Uploaded by

Hardik Bansla
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

TCL Command Lab

The document outlines a series of TCL commands for managing a course table in a database. It includes creating a table with specific fields, inserting records, creating savepoints, deleting records, and performing rollbacks. The steps illustrate how to manipulate data and control transactions effectively.

Uploaded by

Hardik Bansla
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Assignment - TCL commands

1. Create course table with the following fields

a. course_id , type integer, Primary key

b. course_name type varchar(20)

2. Insert the following records in course table

(1, DBT)

(2,OS)

(3,JAVA)

(4, Data structure)

3. Create a savepoint insertion

4. delete the record - DBT and OS

5. Create savepoint deletion

[Link] back to deletion

7. Insert the following record

(5, Algorithms)

[Link] to insertion

9. complete Rollback

You might also like