Posts

Showing posts from 2020

Demystifying Oracle Visual Builder Cloud service and understanding its architecture

By -
Image
Friends, Recently while exploring the latest oracle cloud features, VBCS caught my attention I was curious to learn more about this technology. I quickly hopped into  Oracle Groundbreakers Forum  and posted a query to understand and learn about this nascent technology VBCS. Based on my learning and understanding about VBCS, I'm putting all together in this article which will help you to understand the concept of VBCS and its architecture What is VBCS?  VBCS stands for Visual Builder Cloud services, it is a part of PaaS cloud services, similar to Java Cloud services. Using VBCS we can create and host both web and mobile applications in a secure cloud environment. Aimed at users who aren’t professional software developers, VBCS delivers an intuitive and visual development experience with no-coding required for application development.   Oracle Visual Builder leverages the open-source Oracle JavaScript Extension Toolkit (Oracle JET) to create engaging web and mobile int...
12 comments
Read more

Complex and Frequent queries in Oracle E-Business Suite

By -
Query to find out Profile Option values at Various levels SELECT fpo.profile_option_name SHORT_NAME,          fpot.user_profile_option_name NAME,          DECODE (fpov.level_id,                  10001, 'Site',                  10002, 'Application',                  10003, 'Responsibility',                  10004, 'User',                  10005, 'Server',                  'UnDef')             LEVEL_SET,          DECODE (TO_CHAR (fpov.level_id),                  '10001', '',                  '10002', fap.application_s...
3 comments
Read more

Calling JAVA method to connect Database through JDBC URL from PLSQL by Pranay Tiwari

By -
Recently I got a requirement in my project to form a connection with the different database servers and fetch data to display for further processing.  To accomplish this requirement we have registered PLSQL package as a java source.  You can find more details on the below link https://docs.oracle.com/en/database/oracle/oracle-database/18/jjdev/calling-Java-from-PL-SQL.html#GUID-499ABE6B-4391-43C8-A527-74A6C7B0A0FF Registering PLSQL package as java source to form database connection JDBC.  CREATE OR REPLACE AND COMPILE  JAVA SOURCE NAMED "pocJavaTest"    AS import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class pocJavaTest {   public static String world()   {      String s1="";    String driver = "oracle.jdbc.driver.OracleDriver";     String SQLSTMT =  ...
1 comment
Read more

HTML Table

By -
HTML Table important things to remember <th> table header <td>table data <tr> table row <!DOCTYPE html> <html> <head> <title>HTML Table By Pranay</title> <style> table, th, td {   border: 1px solid black;    border-collapse: collapse; } </style> <body> <table style="width:100%">   <tr>     <th>Firstname</th>     <th>Lastname</th>     <th>Age</th> <th><label for="inputid">Textbox</label> <th><label for="inputchkboxid">Select records</label>   </tr>   <tr>     <td>Jill</td>     <td>Smith</td>     <td>50</td> <td><input type="text" id="inputid" name="inputid" required pattern="^[a-zA-Z]+$"</td> <td><input type="checkbox" id="inputchkboxid" name=...
Post a Comment
Read more

Displaying Multiple Rows in ADF Page

By -
Image
In this exercise, we will learn to access multi records through checkox selection.  Create an ADF  application  Create an Application module and view the object EmpVo with below query select * from xx_employee_info Once view object created now its time to add Transient attribute to display a checkbox Now select the checkbox for the transient attribute as shown in the below code snippet.  Now create a page and drop this View object from data control on to the page as Table.  Select row selection as Multiple Rows as shown in below code snippet.  Add button in the panel accordion for the table  to print the checked records  Create Binding for the table "enpTable"and create actionlistener event for the button Write below code in manage bean package tgr.oracle.apps.fnd.PranayMultiChkBox; import java.util.Iterator; import java.util.List; import ...
1 comment
Read more

HTML5 Canvas

By -
Image
This is Sample Code for HTML Animation. getContext():-this is used to draw 2d graphic s <!DOCTYPE html> <html> <title>HTML Drawing using Canvas</title> <head> <!-- After title -- Style Comes -->    <style>    #canv{                 border:solid 2px red;             }    </style>     </head> <body> <canvas id="canv" width="500" height="300"></canvas>  <script>  let canvas=document.getElementById("canv");  let graphic=canvas.getContext("2d");   console.log(graphic);        graphic.font="40px courier";  graphic.fillText("Pranay Canvas",50,50);  graphic.strokeStyle="orange"; </script> </body> </html> _________________________________________________________________________________ Output of Above code ...
Post a Comment
Read more