Database

0 / 5. 0

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

Related samples

Name Instructor’s name English 101 Date A Responsive Essay of the Article “Mommy, there's a Nigger at the Door” Ronald Jackson‘s article, “Mommy, there's a...

COMPARE AND CONTRAST THE SECONDARY EDUCATION SYSTEMS OF VIETNAM AND AUSTRALIA by (Name) The Name of the Class (Course) Professor (Tutor) The Name of the School...

The ecological benefits of rammed earth construction in medium density urban development Presented By Institution Date Introduction Technological innovations in recent...

Young and New Technology Student’s Name Institutional Affiliation Impacts of Technology on Children Research based on violence in mass media and their effect on...

Comments

Leave feedback

Your email address will not be published. Required fields are marked *