Monday 15 July 2013

Testing for posting PLSQL formatting options

Introduction

This blog post is to display the different formatting options for Oracle SQLDeveloper.
To indicate the first change I am using BOLD. I am using Oracle as the base set of options.
I am also using the PL/SQL example code as shipped in the preferences UI.

Option 1: Source SQL Copied out of Program code
Option 2:....

Option 1: Source SQL Copied out of Program code.
Assumption, Source SQL: Enclosed in "

Used when SQL is contained in another language for example contained in Java, C or
even PL/SQL itself (as in the contrived example).

With option on:

SELECT
  embedded_double_query
FROM
  mytable


With option off:

/* Comment... embedded in double quotes "select embedded_double_query from
mytable" */
/* Embedded in single quotes 'select embedded_single_query from mytable' */
CREATE OR REPLACE PACKAGE BODY test1
IS
  g_column1               VARCHAR2(17) := NULL;
  g_column2               VARCHAR2(52) := NULL;
  g_column3_from_column22 VARCHAR2(25) := NULL;
  g_column_4711           VARCHAR2(11) := NULL;
FUNCTION testfunction(

Image verion TODO: make images/screen shots smaller with relatively bigger text - but still the
same size (consistent) for this web page.[removed data base details]
Go with shorter vertically and 'original size' but a bit smaller originally.

Option 1: (original size)




Option 2: ....

Image version
Option2: (extra large)


No comments: