Oracle APEX & Java

SQL Joins

2011-08-01T07:39:00.001-07:00

If you need to understand SQL Joins then following is the good article.

http://www.oracle-base.com/articles/9i/ANSIISOSQLSupport.php

ALL, ANY and SOME Comparison Conditions in SQL

2011-07-08T23:37:00.000-07:00

It is quite possible you could work with Oracle databases for many years and never come across the ALL, ANY and SOME comparison conditions in SQL because there are alternatives to them that are used more regularly.

You can find more info on following links:

I hope this will be quite useful to many developers.

Thanks to PL/SQL Challenge.

Regards,

Sohil Bhavsar

SQL Functions: Calculate difference between columns of current and previous/next row

2011-05-24T07:04:00.000-07:00

Hi friends,

How to calculate difference between columns of current and previous/next row?

Let's say, you want to monitor how often products are sold from your store.

i.e.

You want difference between current and previous SELL_DATE then you can write query as follows:

SELECT TO_CHAR(SELL_DATE, 'DD-MON-YYYY HH24:MI:SS'),
       TO_CHAR(LAG(SELL_DATE) OVER (ORDER BY SELL_DATE), 
       'DD-MON-YYYY HH24:MI:SS') AS SELL_DATE_PREV,
       (SELL_DATE - LAG(SELL_DATE) OVER (ORDER BY SELL_DATE))
       * 24 * 60 * 60 AS DIFF_IN_SECONDS
FROM PRODUCT_SALES
ORDER BY SELL_DATE DESC;

More Info: Oracle - Base : Lag Lead Analytic Functions

Regards,

Sohil Bhavsar

Oracle Application Express 4.0 with ExtJS

2011-05-16T03:14:00.000-07:00

Oracle Application Express 4.0 with ExtJS

Oracle Application Express 4.0 with ExtJS is quite interesting book. I feel it will be very helpful to the APEX community.

Because, there are very limited resources available for integration of ExtJS and Oracle APEX and the way the book is written it is very easy to understand the concepts of ExtJS.

APEX team has already integrated jQuery in Oracle APEX 4.0 onwards, so before reading the book I had a mindset that jQuery is better then ExtJS but now I feel for Rich User Experience ExtJs is quite good option and APEX Developmt Team should focus towards that.

Congratulations Mark Lancaster for publishing this book.

Oracle Hidden Columns

2010-08-01T23:21:00.000-07:00

Hidden Columns for Tables with Column Objects

When a table is defined with a column of an object type, Oracle adds hidden columns to the table for the object type's leaf-level attributes. Each object-type column also has a corresponding hidden column to store the NULL information for the column objects (that is, the atomic nulls of the top-level and the nested objects).

Link to Oracle Doc

APEX 4.0, now the game begins....

2010-06-23T22:24:00.000-07:00

Finally APEX 4.0 is released.

Download APEX 4.0

For which we all are waiting.

Great!!!

Set up Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2 using Tim Hall's instruction

2010-03-25T23:09:00.000-07:00

Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2

http://www.oracle-base.com/articles/11g/OracleDB11gR2RACInstallationOnOEL5UsingVMwareServer2.php

2010-02-14T00:27:00.000-08:00

Save Our Tigers | Join the Roar

www.saveourtigers.com

Show your support for our national animal! Join the movement to stop India’s tigers from fading away. Save Our Tigers - an Aircel initiative in partnership with WWF India.

Java Tip

2010-01-30T02:28:00.000-08:00

It is better to call shell command (having multiple spaces) by passing all arguments using a string array.

For e.g.

try{

String myCmd[]={"command","dest","src"};
shell.exec(myCmd);

}catch(Exception e){

System.out.println(e.getMessage());

}

Check out Oracle APEX 4.0 Features @

2010-01-30T02:08:00.000-08:00

Oracle APEX 4.0 Features

Learn APEX 4.0 @ Try APEX Now

2010-01-30T01:54:00.000-08:00

Mod PLSQL

2010-01-30T01:41:00.001-08:00

MOD_PLSQL is an Oracle HTTP Server (Apache) extension module that allows developers to create dynamic web pages from PL/SQL packages and stored procedures within the database. It is ideal for developing fast and flexible applications that can run on the Internet or an Intranet.

Oracle Application Express

2010-01-30T01:37:00.001-08:00

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure.