Create Schema, Table, Insert Data: Manage Database, Insert Data using SQL *Plus

by Köll Cherizard, Dököll Solutions

Our Oracle ORA_DEV database is accessible, we had a successful installation and we mastered our first running of the instance effortlessly using Oracle SQL *Plus. In this session, we will be creating an additional administrator user account for the back-end. We will grant our user the proper privileges to manage a schema and database objects, including the ability to perform CRUD functions. We have decided to continue using Oracle SQL *Plus to run some complicated management commands for changes in our database environment. We hope you are at the ready, as we are, to learn a few more tricks. We are documenting this particular Journal Entries segment with the intent to include and highlight all areas of interest, to complement all necessary and important steps in our process as your guide.

26 pages, Kindle Edition

Published April 20, 2021