Oracle 9i - SQL - Student Guide - Volume 1
The Oracle Database (commonly referred to as Oracle RDBMS or simply Oracle) consists of a relational database management system (RDBMS) produced and marketed by Oracle Corporation. As of 2009[update], Oracle remains a major presence in database computing.
Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software.
(Name of the database=db18)
(Note: all commands are in bold letters):
1. Open the command prompt and execute the command sqlplus/nolog
2. Connect to the default database as sysdba in sql prompt SQLconn sys/oracle as
sysdba you can see the name of that database by executing select name from
3. Now open another command prompt and set oracle SID as set oracle_sid=db18
My first debt in writing this book is to my father Dr. Alapati Appa Rao, who is responsible for my
love for education and books. This book is a direct outcome of the early scholarly interest nurtured
by him, as well as his support and encouragement for writing the Oracle 9i book, which is this
John Watson, the Technical Reviewer for the book, did a superb job in not merely catching
technical errors, but also in prodding me to explain several concepts clearly and accurately. I’ve
gained immensely from John’s collaboration on this book....
Oracle là một trong những hệ quản trị cơ sở dữ liệu mạnh nhất hiện nay. Các phiên bản mới được đưa ra nhằm tăng tính hiệu quả, mềm dẻo và linh hoạt trong việc quản lý. Ebook này đề cập tới phiên bản Oracle 9i - một phiên bản rất đáng quan tâm.
This book is intended to help you continue on your exciting new path
towards obtaining the Oracle8i certified database administrator certification.
The book will give you the necessary knowledge of the Oracle Server architec-
ture and the hands-on skills you need to pass Exams 1Z0-024 and 1Z0-026.
Although the OCP exams for Database Administration can be taken in any
order, it is generally recommended that the Oracle8i OCP certification exam for
Performance and Tuning and the Oracle8i OCP certification exam for Network
Administration be the final exams taken in the series. ...