How to Connect Scott user in Oracle database - SQL Language

-

 In this blog, you will understand if scott user not connect in Oracle.. then how to connect.

In Oracle Scott user does not exist so we have to create 

First connect with sys as sysdba user. And the follow the commands as shown in below video. 



Commands:-

1. For that go to SQL command line and connect by using username: sys as sysdba ......password: [press enter on keyboard]


2. then create user scott by command "CREATE USER scott IDENTIFIED BY tiger;"


3. Then grant all privileges to scott by command "GRANT ALL PRIVILEGES TO scott;"


4. Then try to connect to scott/tiger and use the command "select * from tab" to see whether the required tables such as EMP table exists or not. *If not then do the step 7* (i.e if it shows "*no rows selected*")


5. Then Download the given file and save it in any suitable drive ( suitably E drive)


6. Then connect to scott/tiger using 'scott' as username and 'tiger' as password.


7. When connected run the command given below line by line (second line may give an error but it is fine)

*second command is most important*


SQL> @ ?/rdbms/admin/scott.sql

SQL> @ ?/sqlplus/demo/demobld.sql

SQL> @ ?/rdbms/admin/utlsampl.sql


After the third command the SQL command line will automatically close


8.- Restart the sql command line:- Connect with Scott and tiger ..

 and run query - select * from tab;


Subscribe my channel on YouTube and get more ideas 👇


Comments

Post a Comment

Popular posts from this blog

How to take Google Classroom on Desktop Home screen.

-
Image
 In this blog I am going to show you how to Create shortcut of Google Classroom on Desktop screen. Step 1 :-  Open Google Chrome. Step 2 :- Click on Three dots on the Top Right Corner. ( Click on the image for clear view or zoom ) Step 3 :- Click on  More Tools  then Click on  Create Shortcut...  ( Click on the image for clear view or zoom ) Step 4 :- Tick on Open as Window and then click on  Create. Step 5 :- Close or minimize the google window and check the icon on desktop. The video for creating shortcut of Google classroom on desktop I attached below. Watch it once then you will easily understand. Hope you got the shortcut of Google Classroom on you desktop screen.  If you like this blog then please Share, Comment. Subscribe my channel on YouTube and get more ideas 👇 YouTube Link  :-    https://www.youtube.com/channel/UC8U2tW9d8N_qosD8739Id5Q
Read more

How to make Colorful spiral using Python

-
Image
 In this blog I did the code for colorful spiral with Python. Below I given the code with video. Do read carefully the code or watch the video that I attached below and try it by your own. Video:-  Watch video for better understanding. Code:-  import turtle colors=['red','purple','blue','green','orange','yellow'] turtle.speed(100) t=turtle.Pen() turtle.bgcolor(black) for x in range(360):     t.pencolor(colors[x%6])     t.width(x/100+1)     t.forward(x)     t.left(59) Output:-  Subscribe my channel on YouTube and get more ideas 👇 YouTube Link  :-    https://www.youtube.com/channel/UC8U2tW9d8N_qosD8739Id5Q
Read more