Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

Under SQL Prompt type connect system press <enter> system will prompt with password … Type admin123 and Press <enter>

Connected message will be displayed along with SQL>_

prompt.

At present we will type EXIT and return back.

2.   Type sqlplus in Command Prompt Window and press <enter> will also take you to SQL Prompt and rest of the above command may be tried.

We shall create a user under SQL Prompt with some of the rights.

Login SQL*Plus connect with username as system and password as admin123 and get connected.

Now, we are going to create a user and the name of the user-id is learner. His password also we use the same user-id defined. In this case learner is a user-id and learner is the password too.

SQL>  create  user  learner  identified  by  learner;

press <enter>

User created message will be displayed along with SQL

prompt.