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.