Wednesday, 12 September 2018

Handle Not Equal Condition in If statement


Requirement: Hide the row based upon the value in swift, if null don't display row itself

C Swift Code:
swift EC


C => <?if:not(SwiftCode="")?>

EC=> <?end if?>



----------------------------------------------
some cases
<?if:SwiftCode="XXXXX"?> --> worked

<?if:SwiftCode=""?>  -> working

<?if:SwiftCode!=""?> -> did not work

Equality worked but != does not work, use not() instead

<? if xdofx:length(SwiftCode)!=0?> swift<?end if?>  -- worked

Wednesday, 29 August 2018

Override Scientific format in Excel output of RTF template in BI Publisher Report


Use below syntax to achieve it, if your tag name is invoice_number


<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?INVOICE_NUMBER?></fo:bidi-override>

Same can be used for issue in Date format changes

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?period_name?></fo:bidi-override>

Wednesday, 23 May 2018

Moving Oracle Apps into Oracle Cloud

Useful Doc:

https://apexapps.oracle.com/pls/apex/f?p=44785:141:13706953039635::::P141_PAGE_ID,P141_SECTION_ID:523,3680

Getting Started with Oracle NoSQL

https://docs.oracle.com/cd/NOSQL/get_started.htm

Monday, 21 May 2018

How to Install Dockers on windows

Please follow link of my git account:

https://github.com/abhi20aug/learn-docker/blob/master/windows/Step-1.txt

getting started with JET Oracle JavaScript Extension Toolkit

http://www.oracle.com/webfolder/technetwork/jet/globalExamples.html


Some informative links
1. https://blogs.oracle.com/imc/implementing-oauth-in-oracle-jet-applications



Installing and creating your first Oracle JET app is as simple as 1-2-3

  1. npm install -g @oracle/ojet-cli
above did not work on windows7, already had node installed via chocolaty package manager.
hence used:

npm install -g oracle/ojet-cli

  1. ojet create ojet-demo --template=navdrawer
  2. cd <app name>
  3. ojet serve

how to use docker for oracle xe 11g

refer: https://hub.docker.com/r/sath89/oracle-xe-11g/

You need to install chocolaty for docker windows installation, once done steps are below:

  • docker-machine ls
  • docker-machine start default1
  • docker-machine env default1
  • docker-machine ip

1. pull docker file

docker pull sath89/oracle-xe-11g
docker run -d -p 8080:8080 -p 1521:1521 sath89/oracle-xe-11g

to list running processes:
docker ps -a

stop the running containers:
docker stop <container-name>/id



Connect to sql developer :