Skip to content

Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases.

License

Notifications You must be signed in to change notification settings

MadhushaPrasad/Oracle-SQL

Repository files navigation

Oracle-SQL

1-BFTWWQO8gd-Rb6ah-N0-Gdbp-A.png

Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases.

Year 3 semester 1 DS module Worksheets

  • Worksheets 01 -> done ☑️
  • Worksheets 02 -> done ☑️
  • Worksheets 03 -> done ☑️

Documentation

You can find the online documentation of the Oracle Database under docs.oracle.com/en/database/

LiveSQL

Some of the examples that you see within this repository can be executed in the free web-based tool: LiveSQL.oracle.com.

LiveSQL is also an excellent resource for getting started with Oracle Database.

Dev Gym

If you would like to challenge yourself, you can take quizzes, workouts and classes at DevGym.oracle.com

Basic SQL syntax

We are here using basic SQL syntax to show how our DB works.

CREATE TABLE students 
  ( 
     contact_id     NUMBER(10) NOT NULL, 
     last_name      VARCHAR2(50) NOT NULL, 
     first_name     VARCHAR2(50) NOT NULL, 
     address        VARCHAR2(50), 
     city           VARCHAR2(50), 
     uni_assignment VARCHAR2(50), 
     CONSTRAINT students_pk PRIMARY KEY (contact_id) 
  ); 

isaac-arnault-oracle.png

You can create and provision tables in Oracle DB using PL/SQL syntax for more advanced needs.

If you enjoyed this gist, feel free to fork and share it! Thanks.

About

Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published