How do you write a good SQL script?

How do I write a SQL script?

To create an SQL script in the Script Editor:1On the Workspace home page, click SQL Workshop and then SQL Scripts. The SQL Scripts page appears.2Click the Create button. ... 3In Script Name, enter a name for the script. ... 4Enter the SQL statements, PL/SQL blocks you want to include in your script. ... 5Click Create.

How do you write a good SQL code?

1Provide Correct Formatting for the Query. ... 2Specify the SELECT fields instead of using SELECT * ... 3Remove Correlated Subqueries if not required. ... 4Limit the results obtained by the query. ... 5Remove The DISTINCT Clause if not required. ... 6Avoid Functions in Predicates. ... 7Avoid OR, AND, NOT operators if possible.

How do I start a SQL script?

To execute a script from the SQL Scripts page:1On the Workspace home page, click SQL Workshop and then SQL Scripts. ... 2From the View list, select Details and click Go. ... 3Click the Run icon for the script you want to execute. ... 4The Run Script page appears. ... 5Click Run to submit the script for execution.

What makes a good SQL query?

Correctness, readability, then optimization: in that order Avoid tuning your SQL query until you know your query returns the data you're looking for. And even then, only prioritize optimizing your query if it's run frequently (like powering a popular dashboard), or if the query traverses a large number of rows.