I set up the the SSH profile:
See: sshprofile.png
Then I can set up the connection by specifying the type as SSH, successfully:
However, in the REST Admin, I don't get the SSH connection option:
/* Usage: | |
Package to get an apex session from SQL Developer (or other external tool) based on an existing session ID. | |
Useful to have parameterised views return data | |
--Get session in SQL Dev, replacing xxxxxxxxx with your actual session | |
begin | |
apex_session_utl.re_init_session('xxxxxxxxx'); | |
end; |
I set up the the SSH profile:
See: sshprofile.png
Then I can set up the connection by specifying the type as SSH, successfully:
However, in the REST Admin, I don't get the SSH connection option:
declare | |
l_file files%rowtype; | |
begin | |
select * | |
into l_file | |
from files | |
where id = 261; | |
owa_util.mime_header(l_file.mime_type); |
$ /home/trent/node-v0.12.2-linux-x64/bin/node app.js dev 110 | |
options { configFile: '/home/trent/apex-diff/config/config.json', | |
sqlcl: '/opt/sqlcl/bin/sql', | |
debug: true, | |
rebuildTempFile: false, | |
connections: | |
{ dev: 'dl_test/dl_test@localhost/xe', | |
prod: 'dl_prod/dl_prod@localhost/xe' } } | |
sql: { command: '%SQLCL% %CONNECTION% @%DIRECTORY%/%FILENAME% %PARAMS%', | |
files: |
set define off | |
set verify off | |
set feedback off | |
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK | |
begin wwv_flow.g_import_in_progress := true; end; | |
/ | |
-- AAAA PPPPP EEEEEE XX XX | |
-- AA AA PP PP EE XX XX | |
-- AA AA PP PP EE XX XX |
Piping in input doesn't seem to work when having one HIDE param and one non-HIDE param - refer to sql script below https://gist.github.com/trent-/1c2bb55da5045113498e#file-ords_manual_install-sql
Scenario 1: Both accepts are non-HIDE.... works fine
Scenario 2: Both accepts are HIDE.... works fine
Scenario 2: At least one is HIDE and one isn't.... doesn't work
Scenario 3: Only one param (HIDE or non-HIDE doesn't matter).... works fine
Call script:
Atom has a config not in the UI: core.restorePreviousWindowsOnStart
.
Set this to false
in your config.cson
file in order to start Atom in a blank state when you launch Atom.
create type ot_info is object ( | |
a number, | |
b number, | |
c number, | |
map member function equals return raw | |
); | |
/ | |
create type body ot_info as |
List<SystemVersion> installedVersions = new List<SystemVersion>(); | |
installedVersions.Add(new SystemVersion("system17.1.123.1256")); | |
installedVersions.Add(new SystemVersion("system17.2.0.188.1159")); | |
installedVersions.Add(new SystemVersion("system4.2.123.1256")); | |
List<SystemVersion> sortedVersions = | |
installedVersions | |
.OrderByDescending(o=>o.BuildNumber.Major) | |
.ThenByDescending(o=>o.BuildNumber.Minor) | |
.ThenByDescending(o=>o.BuildNumber.MajorRevision) |
set sqlformat ansiconsole | |
--See: http://www.aihw.gov.au/WorkArea/DownloadAsset.aspx?id=60129551915 | |
--http://meteor.aihw.gov.au/content/index.phtml/itemId/349510 | |
with raw_data as ( | |
select | |
upper('Smith') last, | |
upper('Nicholas') first, | |
to_date('29-01-1959', 'dd-mm-yyyy') dob, | |
'M' gender | |
from dual |