Allow Blank Lines In Your SQL Statements: SQLBLANKLINES

-

 

use the following SQL*Plus statement: SET SQLBLANKLINES ON
This statement has two options to turn ON or OFF blank lines. If blank lines are turned on, then you are allowed to use blank lines within the lines of your SQL statement.
By default the blank lines are OFF, meaning it is not allowed to have blank lines within a SQL statement. Below is an example on the usage
SQL>show SQLBLANKLINES
sqlblanklines OFF
SQL>SET SQLBLANKLINES ON
SQL>select count(*) from dba_users
2
3 where username like 'D%';
  COUNT(*)
----------
        11
SQL>SET SQLBLANKLINES OFF
SQL>select count(*) from dba_users
2
3 where username like 'D%';
SP2-0734: unknown command beginning "where user..." - rest of line ignored.

You can also use a shorthand form of this command:

set SQLBL ONshow SQLBL

And that is the tip for today

Comments

Post a Comment

Popular posts from this blog

Script to display the SQL text for a specific SQL_ID

-
--> Purpose:    Script to display the SQL text  for a specific SQL_ID. -->             It returns the SQL_TEXT. --> Parameters: sql_id --> To Run:     @sqltext.sql sql_id --> Example:    @sqltext.sql 27b3qfm5x89xn --> --> Copyright 2020@The Ultimate SQL Tuning Formula set echo off set define '&' set verify off define _sql_id=&1 set verify off set feedback off set linesize 200 set heading on set termout on col sqltext format a100 word_wrapped select  sql_text as sqltext from gv$sqltext where sql_id = '&_sql_id' order by piece; **************************************************************************************** --> Purpose:    Script to display the SQL text  for a specific SQL_ID. -->             It returns the SQL_TEXT. --> Caution:  ...
Read more

UDO object Promotion

-
UDO Object Promotion ================= The following shows the detail steps needed to promote a UDO object using Object Management Workbench (OMW) Web application (P98220W). Example of UDO object used in this document is a Grid Format object. 1.       Enable Security Access to UDO Objects and enable access to both the OMW Web application (P98230W) and Work With User Defined Object application (P98220U) in Security Workbench (P00950). Refer to the following documents for more detail: - Document E1: SEC: Setting up View, Manage, and Action Security for the User Defined Objects (UDO) available with 9.2 and newer ( Doc ID 2072336.1 ). -  JD Edwards EnterpriseOne Tools Security Administration Guide  - See Chapter 24 Managing Security for User Defined Objects 2.       Ensure Allowed Actions and Transfer Activity Rules are set up in Object Management Configuration application (P98230) for UDO objects. Refer to D...
Read more

How to Change Your EnterpriseOne Environment Color

-
Image
Sometimes users start working and then forget which EnterpriseOne environment they are logged into. Can you tell which environment you are logged into? Luckily, there is a new UDC that allows you to change your EnterpriseOne environment color. You can now set up environments to be color-coded for when you need a clear visual distinction as to which environment you are logged into. This enables you to quickly identify the non-production environments by color. The new UDC is 98/CO and is available in EnterpriseOne Tools Release 9.2.4 with Applications Release 9.1 and 9.2. The image below shows the default EnterpriseOne environment color. However, you can easily change the color to reflect different environments. For example, DV could be red, PY could be green, and PD could be yellow, as shown below. To do so, just add a new row in the User Defined Codes section, enter the EnterpriseOne environment name and the HEX value of the color you want the environment to be, and ...
Read more