SQL Developer code ‘Advanced Format’ versus ‘Custom Format’

oracle-sql-developer

Preferences -> Code Editor -> Format -> Advanced Format
versus
Preferences -> Code Editor -> Format -> Advanced Format -> Custom Format

As I understand, both are alternative options to (re)format code in SQL Developer, where Advanced Format bases on .xml and Custom Format bases on .prg.

It seems, that the Advanced Format is the default, which is used when pushing Ctrl+F7.

How can I deactivate Advanced Format and activate Custom Format now?

Best Answer

The custom format allows you to augment what's available with GUI controls in the advanced formatter preferences page.

It uses arbori, a parse tree query language.

The developer, Vadim, discusses this in his blog here.

So you don't pick one or the other - both are in play when using the formatter.

Related Solutions

Can not execute LIMIT on sql Developer

Oracle 11g doesn't support the LIMIT clause, though the impending 12c release is rumored to support it.

Anyway, you can do this using an analytic windowing function:

select * from
( 
  select salary, row_number() over (order by salary desc) as rn
  from emp
)
where rn = 4;

You can also do this using rownum, but I find the above way to look cleaner.

Example SQL Fiddle for you to mess around with.

SQL Developer: how to script output to query results grid

if you remove first two lines (var ... and exec), you can run this in sql_developer and get your results in a grid.

Now, if you must have variable declaration, you could replace the : to a & in "job.contract_year in (2013,:v_yr)" so it will prompt you to enter a value at run time.

If you must convert this to a procedure, then you need to go the ref_cursor route.

Best Answer

Related Solutions

Can not execute LIMIT on sql Developer

SQL Developer: how to script output to query results grid

Related Question