5.4.9 Configuring Quick SQL Settings
Configure settings inline to explicitly set SQL syntax generation options, or click the Settings button at the top of the right pane to declaratively set the generation options.
- Configuring Settings Declaratively
Configure settings declaratively by clicking the Settings button at the top of the right pane. - Configuring Settings Inline
Configure settings inline to explicitly set SQL syntax generation options.
Parent topic: Using Quick SQL
5.4.9.1 Configuring Settings Declaratively
Configure settings declaratively by clicking the Settings button at the top of the right pane.
To configure settings declaratively:
Parent topic: Configuring Quick SQL Settings
5.4.9.2 Configuring Settings Inline
Configure settings inline to explicitly set SQL syntax generation options.
You can configure settings inline to explicitly set SQL syntax generation options. When configuring setting inline:
- Settings must start on a new line. To enter multiple settings,
begin with
# settings =
. To enter a single setting per line, use#
. - All values are case insensitive.
- Brackets, spaces, and commas can be added for clarity but are ignored.
- To have all settings generated use
# verbose: true
To configure settings inline:
-
On the Quick SQL page, enter Quick SQL shorthand syntax in the left pane.
The generated SQL displays in the right pane.
-
Scroll through generated SQL in right pane.
At the bottom, the line starting with
-- Generated by Quick SQL
is the SQL shorthand syntax. Consider the following example:-- Generated by Quick SQL undefined 12/7/2023, 12:20:47 PM /* departments /insert 4 name /nn location country employees /insert 14 name /nn vc50 email /lower cost center num date hired job vc255 view emp_v departments employees --- Non-default options: # settings = {"apex":"Y","db":"19c"} */
-
Specify settings after the line starting with
# settings =
.Entering settings directly into the right pane ensures the same SQL generation options are utilized even if you download the script and later paste it back. For example, enter the following to prefix all table names with TEST and generate for schema OBE:
# settings = { prefix: "test", schema: "OBE" }. Alternatively, enter each setting on a separate line for the same result: # prefix: "test" # schema: "OBE"
Tip:
To view a listing of settings, by click Help and then the Settings tab.
Parent topic: Configuring Quick SQL Settings