Demo: Version Control for PL/SQL in 30 Minutes

Hi Everyone! We prepared a 30 minute demo video to show you how Gitora can help you manage your PL/SQL code base. Check it out below:

Comments

Post a Comment

Popular posts from this blog

Wrapping PL/SQL Source Code and a Strange Bug (PLS-00753)

Wrapping process makes PL/SQL source code unreadable. Developers can wrap package specifications, package bodies, functions, procedures, type specifications and type bodies. Unfortunately triggers cannot be wrapped. To wrap the trigger code you need to place your source code to a package or procedure and call it from the trigger.

There are two ways to wrap PL/SQL source code.

1. Wrapping PL/SQL source code with wrap utility


Wrap utility takes two parameters. First one (iname) is the PL/SQL source code file and the second one (oname) is the output file that will hold the wrapped code.

wrap iname=example_input_file.sql oname=example_output_file.plb
This is an easy way to wrap source code because you do not need to handle DDLs bigger than 32767 bytes. But this way, you need to save DDLs into different files and execute the wrap command frmo the command prompt for each file.

2. Wrapping PL/SQL source code with DBMSL_DDL package


The DBMS_DDL package contains an overloaded wrap API to wrap PL…
Read more

An ADF Faces ProgressIndicator Example for File Upload

Image
This post demonstrates how an ADF Faces ProgressIndicator can be used to display the progress of a file upload.

The sample application is built in JDeveloper 10.1.3.2. You can download the sample workspace from here. The workspace does not need a database connection to run.
Sample Application

The sample application consists of one page that allows the user to upload files to the server. When the upload starts, a progress indicator displays the current status of the upload operation. The uploaded files are not stored anywhere.
Controlling the progressIndicator
<f:view> <afh:html> <afh:head title="FileUpload"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"/> <afh:script source="progressIndicator.js"/> </afh:head> <afh:body onload="deactivateProgressIndicators();"> <af:messages/> <af:form usesUpload="true"> <af:inputHidden id="fileUploadSt…
Read more

JavaScript DecimalFormat

We needed to implement a number formatter in JavaScript for Formspider, our Web 2.0 framework for PL/SQL developers. The applications developed with the framework can run on both Java and JavaScript from the same code base. Since we used the DecimalFormat on Java side, we needed the same functionality for the Javascript environment as well. The Javascipt code below implements Java's DecimalFormat in JavaScript.
It is implemented to fulfill our basic needs such as prefix, suffix, comma separation, min/max digits and percentage(%) values.

Here is the source code:DecimalFormat.js

Examples:
var df = new DecimalFormat("$#,#00.00#");
df.format(1); //$01.00
df.format(12345.6789); //$12,345.679
df.formatBack("$1,234.00"); //1234

For detailed information you can visit Java DecimalFormat description page.
Öskan Şavlı
Read more