How to use Oracle Live SQL for Practice SQL queries.

Ankan Das
2 min readJan 15, 2023

--

Oracle Live Sql is an online platform to write sql queries, function procedure, package. It is super easy to use and one can try cool and complex SQL queries.

Step 1:

Account in Oracle Live SQL:

Go to the official site of Oracle Live SQL

Create an account & log in.

Step 2:

After login click on top left menu icon -> select SQL worksheet and start writing the queries.

Step 3:

If you want use the pre existing schemas , then go schema section.

Select any schema from that list, I am selecting that EMP and DEPT(SCOTT) schema.

Inside that I want to see the EMP table. After click on it, one can get a detail view of that table and all the properties of the schemas.

Step 4:

Now go to the worksheet again.And start writing.

See we are now able to query from that table. In this way you can write different type of sql statements and brash up you sql skill set.

Thanks a lot for reading till the end. You can contact me in case you need any help.

Web: https://ankandas.netlify.app
Instagram: https://www.instagram.com/ankaninperson/
GitHub: https://github.com/Ankan982

--

--

Ankan Das
Ankan Das

Written by Ankan Das

Software Developer who loves to explore new technologies. To know more about me lets connect : https://ankandaslinks.netlify.app/

No responses yet