This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Select constraint | |
select * from all_constraints | |
where constraint_name = 'T_CUST_PASS_CK' | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN | |
APEX_AUTHENTICATION.LOGOUT ( | |
P_SESSION_ID => :APP_SESSION, | |
P_APP_ID => :APP_ID, | |
P_WS_APP_ID => NULL ); | |
END; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Checks whether the given string is numeric | |
function isNumeric(str) { | |
if (!str.length || !isNaN(str.replace(/\s/,"z")/1)) {return true;} | |
return false; | |
} | |
//Checks whether a field is null or numeric else returns 0 | |
function f_chkNumberFlds(pVal) { | |
var lVal; | |
if ( pVal.length > 0 ) { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Step 1 | |
Get your Javascript function to add-up the total ready. I have created a simple function which you can customise for your application. You will need to know the ID of the tabular form element you are trying to add. | |
All editable APEX tabular forms that are ID'ed like f0x_000x. You can find them out by using Firebug (chrome, firefox) or IE Developer Tool by hitting F12 as below. | |
In my case I need add up the total in Salary column as I add rows or edit entries and add it to the Total Salary text field above the tabular form. | |
So here is the script. Find out the ID of your field and update the italics part. | |
STEP 2. Test out the javascript. | |
Its a good idea to make sure your code works before putting it page attribute. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
.rpm packages are those packages used by Red Hat linux and .deb are those installer files used by Debian Distros. Some time you must have to convert .rpm packages into .deb and vice versa. fot that you must install a program called Alien | |
Insatalling Alien in Debian Distros | |
just type the following command in linux | |
sudo apt-get install alien | |
Convert .rpm into .dev |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
I'm using linux mint 17 (Qiana) cinnamon. When i update, using the command --> sudo apt-get update | |
I got these error messages below: | |
E: Encountered a section with no Package: header | |
E: Problem with Mergelist /var/lib/apt/lists/packages.linuxmint.com_dists_qiana_upstream_i18n_Translation-en | |
E: The package lists or status file could not be parsed or opened | |
I encountered these similar problems already 3 times. So I search on the internet, and found that many people already encountered such kind of error messages. Some blogs and forums suggested this command below to solve the problem. | |
sudo rm /var/lib/apt/lists/* -vf |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
A while ago I tried to install Oracle 11g R2 Express Edition on a 64-bit Ubuntu machine. This proved to be not as easy as you would expect. There are many blogs and articles about this subject and I tried a number of them. Unfortunately neither of the instructions seemed to work completely on my machine. With the combined information from the authors, I finally got it to work and I’ll gladly share my recipe in this blog. I have also included the installation steps for SQL Developer en Java (which is needed to install SQL Developer) in this blog. The installation was performed on a Ubuntu 12.04 VM with the following software. | |
Oracle Java 1.7.0_51 | |
Oracle XE 11.2.0 (http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html) | |
SQL Developer 4.0.0.13.80 (http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html) | |
Installing Java | |
We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK co |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1- $ sudo fdisk -l | |
2- $ sudo ntfsfix /dev/<sda?> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Download the ZIP file from Oracle. Make sure you have a current JDK installed on your machine (Glassfish 4.1 supports Java 8). | |
As root, enter the directory you want to install to (I install it in /usr/share) and extract the ZIP file there. | |
#Add the binaries directory of your new installation to the PATH. One way of doing this is to use a profile script in /etc/profile.d. Create a file there whose name ends in .sh, make it executable, and add this line: | |
export PATH=/usr/share/glassfish4/glassfish/bin:$PATH | |
Log out and back in to make the change take effect. | |
#Create a group and a user for GlassFish. |
OlderNewer