Posts

Create a table in Oracle .. insert a row.. update the data.. delete the row or table

Image
Watch the full video for better understanding 👇 1. Create a table  Commands :-  create table students ( Name varchar(15), Rollno int, Age int, Address varchar(15)); 2. Insert a row  Command :- insert into students values ('Raj', 21, 18, 'Thane' ); insert into students values ('Jay', 26, 17, 'Kalwa'); insert into students values ('Om', 28, 18, 'Mumbra'); *Click on the picture for clear view To view the table :- Command:-  Select * from students; 3. Update the table :-  Commands :-  Update students Set rollno=24; Where name like 'R%'; To view the table :- Command:-  Select * from students; 4. Delete a row or table :- For row :-  Command :-  delete from students where name like 'Raj'; For table :-  Command :- drop table students; Table dropped means table has been deleted. Hope you understood. Subscribe my channel on YouTube and get more ideas 👇 YouTube Link :- https://www.youtube.com/channel/UC8U2tW9d8N_qosD8739Id5Q

Digital clock using Python

Image
 Step 1 :-  open IDLE and start typing the code. Code:-  from tkinter import* from tkinter.ttk import* from time import strftime root Tk( root.title("clock") def time(): string strftime(%H:%M:%S %p' ) label.config(text-string) label.after(1000, time) label-Label(root, font ("ds-digital",80), background="black", foreground="White") label.pack(anchor='center')  time() mainloop() ( Click on the picture for clarity ) Step 2 :- Save the file Step 3 :- Run the code and get the output. Hope you got the output. Watch the video for better understanding. Subscribe my channel on YouTube and get more ideas 👇 YouTube Link :- https://www.youtube.com/channel/UC8U2tW9d8N_qosD8739Id5Q

How to run a java program in CMD

Image
 In this blog I m going to show you How to run a java program in Command prompt or CMD. The video for this I have uploaded on my YouTube channel. Watch the video carefully for better understanding. Step 1 :- Type the code in notepad. Step 2 :- Save the code in C drive with .java extension . And filename must be classname. So, the filename will be :- hello.java Step 3 :- Open Command prompt / CMD and come back to the C drive. Then after that we have to first compile the code. Step 4 :- For Compilation process :- javac classname.java Type this command and press enter.  Step 5 :- If you got 0 errors then we have to run a program.  For running process :- java classname Subscribe my channel on YouTube and get more ideas 👇 YouTube Link :- https://www.youtube.com/channel/UC8U2tW9d8N_qosD8739Id5Q  

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

How to take Gmail and You Tube on Desktop home screen

Image
In this blog I am going to show you how to take Gmail & You tube applications on desktop. Step 1 :- Open Google  Step 2 :- Type chrome://apps  on the search bar. Step 3 :- Press Enter then this screen will be shown. Step 4 :- Right click on the Gmail icon and click on Create Shortcut. Step 5 :- After click on create shortcuts one confirmation you will get then click on Create. Step 6 :- Close or minimize the google window and check the icon on desktop. The video for creating shortcut of Gmail & YouTube I attached below. Watch it once then you will easily understand. Hope you got the shortcut of  Gmail and YouTube or others applications of google in 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

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

How to Connect Scott user in Oracle database - SQL Language

Image
 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...