2.8.3.1 Data Files The main purpose of a database is to store and retrieve data. It consists of a collection of data that is treated as a unit. An Oracle database has a logical and physical structure. The logical layer consists of Table spaces, necessary for the smooth operation of […]
Category: Certification Exams of Oracle
Stored Procedures – Introduction to Databases
2.8.3.4 Stored Procedures In Oracle, functions and procedures may be saved as stored program units. Multiple input argu-ments (parameters) may be passed as input to functions and procedures; however, functions return only one value as output, whereas procedures may return multiple values as output. The advantages to creating and using […]
Initialization Parameter Files – Introduction to Databases
2.8.3.5 Initialization Parameter Files The Oracle server must read the initialization parameter file before starting an Oracle database instance. There are two types of initialization parameter files: static parameter files and persistent parameter files. An initialization parameter file contains a list of instance parameters, the name of the database the […]
CREATE A NEW ORACLE XE 18C SAMPLE DATABASE – Introduction to Databases
2.9 CREATE A NEW ORACLE XE 18C SAMPLE DATABASE After you finish the installation of Oracle 18c Express Edition database (refer to Appendix A), you can begin to use it to connect to the server and build our database. Now let’s start to create a new Oracle 18c XE sample […]
Create an Oracle User Account for the User Schema – Introduction to Databases
2.9.2 Create an Oracle User Account for the User Schema After the default Oracle 18c XE database is connected, we need to create our customer Oracle data-base. Creating a customer database in Oracle18c XE is different from creating a customer database in the Microsoft SQL Server database management system (MDBS). […]
Create LogIn Table – Introduction to Databases
2.9.3 Create LogIn Table Now expand our user account or sample database icon, CSE _ DEPT, and we need to create and add all five Tables into this database. The first Table we need to add is the LogIn Table. Perform the following operations to create and add this Table […]
Create Faculty Table – Introduction to Databases
2.9.4 Create Faculty Table Right-click on the Tables folder on the left and select the NewTable item to open the design view of a new Table, which is shown in Figure 2.21. FIGURE 2.20 The completed data components for the LogIn Table (Copyrighted by Oracle and used with permission). FIGURE […]
Create Other Tables – Introduction to Databases
2.9.5 Create Other Tables In a similar way, create the rest of three Tables: Course , Student and StudentCourse. Select course _ id, student _ id and s _ course _ id as the primary keys for these Tables (refer to Tables 2.14, 2.15 and 2.16). For the data type […]