Posts

Showing posts from May, 2024

View Passwords in SQL DEVELOPER

Image
  View Passwords in SQL DEVELOPER   Firstly we need to download a extension. CLICK-HERE-TO-DOWNLOAD-EXTENSION   Download and Install Download the latest version of the extension for Oracle SQL Developer 4.x/17.x/18.x/19.x/23.x/... to your machine. The extension will be packaged as zip file - pls. don't unzip the extension;)   In SQL Developer, navigate to Help -> Check for Updates... Instead of choosing from the existing update centers, select the "Install From Local File" option, and specify the path to the zip file you downloaded.   Restart SQL Developer to complete the extension installation

Process to execute shell script from oracle R12

Process to Call a shell script or REST API from oracle R12 Ø     To call a rest api we need to run curl command in bash script Example of simple bash script calling API #!/bin/bash curl -L 'https://aet-trackine.com/services/' \ -H 'Content-Type: application/json' \ -H 'Authorization: Bearer F95U05owDB6e8%2b0e3bAV5GSRmBzJB0Q0WeplT5XDSOMoLBpk' \ -d '{     "method": "add",     "data":         {             "recipient_details":                 {                      "recp_mobile": "+91991273324",                     "recp_name": "John Doe",     ...

Custom form creation process

Image
  Documentation of Custom   Forms: Step-1 ->Open the form Builder application and connect it with the server ->now delete the module and open the template.fmb which is standard ->Rename Template file with ur form name and save as form.fmb(form name) ->Now click on Data Block and delete DetailBlock ->Now click on Canvas and delete Blockname ->Now click on windows and delete Blockname Step-2 ->Now click on data Block and click (+) symbol which we can find on the left side on the top ->Now Create the new Data Block Use the Data Block Wizard and click ok ->Then click on next ->now click on table or view and click next ->give ur custom table name and click on enforce data integrity so that we can find the columns of our table and move all the items to database items and click next ->then click on next ->give the data block name which we want to display and click on next ->click on data block and call the la...