- Tags:
- Show more
- Pages:
- 1
- Words:
- 275
A database is a central repository for an organization’s resources. An efficient database enables easier administration and enhances the security of the database. However, it is essential to understand the basic controls for the creation of the database tables and the fields. The AUTOTRACE command is a critical element in database administration. In the Oracle database, the AUTOTRACE executes the query and queries the plan table automatically. For the user to use the AUTOTRACE, the user must have the PLUSTRACE role which has its location in ORACLE_HOME/sqlplus/admin directory. Creating a Table called Students The script creates the table Students with fields such as StudentId, LastName, FirstName, AdvisorName and the Faculty. CREATE TABLE Students ( StudentID int, LastName varchar(200), FirstName varchar(200), AdvisorName varchar(200), Faculty varchar(200) ); Creating a Table called Faculty The script creates the table Faculty with fields such as StudentId, LastName, FirstName, AdvisorName and the Faculty. CREATE TABLE Faculty ( StudentID int, LastName varchar(200), FirstName varchar(200), AdvisorName varchar(200), Faculty varchar(200) ); Inserting Data INSERT INTO Faculty (StudentID, LastName, FirstName, AdvisorName, Faculty) VALUES (StudentID, LastName, FirstName, AdvisorName, Faculty); Select Command from the Table The script selects all from the Faculty table with a specific AdvisorName. select * from Faculty WHERE AdvisorName='{$ AdvisorName }'; Inserting Data INSERT INTO Students (StudentID, LastName, FirstName, AdvisorName, Faculty) VALUES (StudentID, LastName, FirstName, AdvisorName, Faculty); Select select * from Students WHERE AdvisorName='{$ AdvisorName
Leave feedback