You are Browsing Oracle News

by E-Computer Concepts 9 months ago

What is PL/SQL?

PL/SQL is a sophisticated programing language use to access in Oracle database from various environments. It is integrated with the database server so that the PL/SQL code can be processed quickly and efficiently. PL/SQL is a procedural...

by E-Computer Concepts 9 months ago

Data Constraints

Oracle allows data constraints to be attached to columns with the help of SQL syntax that checks data for integrity prior storage. Once data constraints are part of a table column construct, the oracle database engine checks for the data...

by E-Computer Concepts 10 months ago

Oracle Startup Commands

The syntax of the STARTUP command with its important options has been displayed: STARTUP [FORCE][RESTRICT][PFILE=filename][OPEN[RECOVER][database][READ ONLY]|MOUNT|NOMOUNT] FORCE : Used when a startup does not occur as a result of...

by E-Computer Concepts 10 months ago

Starting and Stoping Oracle Database

Starting the DATABASE A database needs to be started before it can be accessed by users, Starting Up a database should be done by a privileged user. User who have been granted the SYSDBA or SYSOPER role can perform a startup or a shutdown...

by E-Computer Concepts 10 months ago

Logical Storage Structure of Oracle Database

An oracle server consists of both a database and an instance. In Oracle terminology, database refers to only the physical files on disk. These are the files that store the data itself, the database state information in the control files,...

by E-Computer Concepts 10 months ago

Oracle Database

A database is a centralized repository of organizational data. The oracle Database Server allows you to create, manage and retrieve data in the database. A database administrator who is responsible for administering a database should have...