Udemy logo

concatenate sqlSQL or Structured Query Language is a powerful and standard database computer language. It is used with all the RDBM’s to retrieve and manage data. There are three categories of commands in SQL. They are DDL(Data Definition Language), DML(Data Manipulation Language) and DCL(Data Control Language). Examples of Software that use SQL are MYSQL, Oracle, Sybase, SQL Server and more. Though SQL is very good at creating, retrieving and manipulating data, by itself, it lacks the basic programming features. PL/SQL is used to include SQL statements in data driven programs.

Today we walk you through the Graphical User Interface known as SQL Scripts, which help to manage script files. The latter contain the different SQL commands as well as PL/SQL blocks. If the script file contains SQL*Plus commands they are ignored at the time of execution. We assume that you are familiar with the different SQL commands and PL/SQL, if not you can take this course on how the essentials of SQL for PL/SQL programming.

What is a SQL script

A SQL script is a group of SQL commands saved a single file. This file can contain both SQL statements as well as PL/SQL blocks. You can learn more about SQL commands in this course.

What is SQL Scripts

The SQL Scripts is part of a Graphical User Interface from Oracle which helps to deal with all aspects of script files. SQL Scripts is an environment that enables you to create, edit, delete script files, and also execute them.

Advantages of using script files

To truly appreciate the power of scripts, take this course on SQL server essentials. Lets go through each operation to understand how to use SQL Scripts better.

How to Access SQL Scripts

To access the SQL Scripts, you need to first log in to the home page of the Workspace.

Next step is to view the SQL Scripts, you have to select the SQL Workshop icon’s down arrow and choose the option SQL Scripts from the drop down menu.

How to create SQL Script

There are two methods. Here we look at the first method.

  1. Using the Script Editor
  1. The second method is to upload from the local file system.

What does the Script Editor do

You can add content to the existing file, edit existing content, execute or delete scripts stored in the Script repository.

How to Edit a SQL Script

How to delete a SQL Script

There are two ways to delete Scripts from the Scripts repository. Let’s take a look at the first method.

  1. First Method
  1. Second Method

How to copy a SQL Script

This can be done by saving the script in the Script Repository with a new name in the editor.

How to execute a SQL Script

How to view the SQL Scripts results

Hope this article on SQL Scripts gave you a clear insight about how to create and manage script file. Study the theory and implement the different operations to gain proficiency in this GUI editor. To know more about SQL recommend you to take this course on advanced SQL concepts.

Page Last Updated: June 2014

Top courses in SQL

Complete SQL and Databases Bootcamp: Zero to Mastery [2023]
Andrei Neagoie, Mo Binni, Zero To Mastery
4.6 (3,704)
SQL and PostgreSQL: The Complete Developer's Guide
Stephen Grider
4.7 (5,445)
Highest Rated
SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
Academind by Maximilian Schwarzmüller, Maximilian Schwarzmüller, Manuel Lorenz
4.7 (1,028)
101 Practice SQL Questions: Basic to Advanced
Curtis Norman
4.9 (20)
Highest Rated
The Complete SQL Bootcamp 2022: Go from Zero to Hero
Jose Portilla
4.7 (155,102)
SQL for Beginners: The Easiest Way to Learn SQL Step by Step
Code Star Academy, Oracle Master Training | 175,000+ Students Worldwide
4.5 (3,412)
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
Colt Steele, Ian Schoonover
4.6 (75,363)
SQL for Beginners: Learn SQL using MySQL and Database Design
Tim Buchalka's Learn Programming Academy, Jean-Paul Roberts
4.5 (39,885)
SQL Programming Basics
Global Academy
4.5 (3,860)

More SQL Courses

SQL students also learn

Empower your team. Lead the industry.

Get a subscription to a library of online courses and digital learning tools for your organization with Udemy Business.

Request a demo