Apex- Oracle’s Best Kept Secret

What is Oracle Apex?

Oracle Application Express (Oracle Apex, previously named Oracle HTML-DB) is a freeware software development environment based on the Oracle database. It allows a very fast development cycle to be achieved to create web based applications.

APEX is Oracle’s answer to wizard-based Web Development. It certainly is full of wizards! APEX contains metadata (lots of it) on everything in the tool, too. It produces dynamic HTML and it’s fast! APEX uses the PL/SQL module for Apache (mod_plsql). It doesn’t use any Java code. Anything you can do in SQL or PL/SQL can be done using APEX. APEX provides a nice Web-based team development environment for your organization.

Read More : http://vinaytechs.blogspot.com/2009/12/apex-oracles-best-kept-secret.html

Version Control with Subversion

Introduction

Version control is the art of managing changes to information. It has long been a critical tool for programmers, who typically spend their time making small changes to software and then undoing those changes the next day. But the usefulness of version control software extends far beyond the bounds of the software development world. Anywhere you can find people using computers to manage information that changes often; there is room for version control.

And that’s where Subversion comes into play.

Read More : http://vinaytechs.blogspot.com/2009/12/version-control-with-subversion.html

Optical Character Recognition (OCR)

This article aims to look at implementation of OCR solutions in transaction handling processes to further optimize accuracy and productivity.

What is OCR?

Optical character recognition, usually abbreviated to OCR, is the mechanical or electronic translation of images of handwritten, typewritten or printed text (usually captured by a scanner) into machine-editable and searchable text/content. In today’s world, where information is critical, the ability to create live content where before there was only static images must be worth 10 times than the source.

Why do we need it?

Read More : http://vinaytechs.blogspot.com/2009/12/optical-character-recognition-ocr.html

Oracle External tables – Overview

Overview on Oracle External tables

External tables can read flat files (that follow some rules) as though they were ordinary (although read-only) Oracle tables. Therefore, it is convenient to use external tables to load flat files into the DB. External can be used like SQL tables in querying purpose. So we can use it for insert and update of data into permanent tables. No DML can be performed on external tables but they can be used for query, join and sort operations. Views and synonyms can be created against external tables. They are useful in the ETL process of data warehouses since the data doesn’t need to be staged and can be queried in parallel.

Read More : http://vinaytechs.blogspot.com/2009/12/oracle-external-tables-overview.html

Hidden Blackberry Features

Advanced Enterprise Activation Settings

ALT-CNFG In Options -> Advanced Options -> Enterprise Activation Settings for Enterprise Activation

Address Book

ALT-VALD In address book list Validate the data structure and look for inconsistencies

ALT-RBLD In address book list Force a data structure rebuild

Read More : http://vinaytechs.blogspot.com/2009/12/hidden-blackberry-features.html

Streaming Video Concepts

STREAMING
Streaming is a technique for transferring data such that it can be processed as a steady and continuous stream. Streaming video is a term applied to the compression and buffering techniques that allow one to transmit and view video in real-time through the

Internet. In other words, streaming media is the simultaneous transfer of digital media files such as video, audio, and data through a server application that can be displayed in real-time by client applications. Once a streamed file has been downloaded and viewed, the physical file is no longer present on the user’s computer or Mobile Devices.

Read More : http://vinaytechs.blogspot.com/2009/12/streaming-video-concepts.html

Difference between AIX and Solaris

Solaris and AIX Installation perform following activity similarly :

• Probe the hardware for devices and load the appropriate device drivers
• Assign a host name
• Set up a network setup type, Dynamic Host Configuration Protocol (DHCP) or
• Static IP
• If you choose static IP, you will be asked to enter the IP address, subnet

Read More : http://vinaytechs.blogspot.com/2009/12/difference-between-aix-and-solaris.html

DB2 System Objects

This article gives overview on DB2 system objects and helps DB2 developers to know detail description about each system objects

Introduction

DB2 has a comprehensive infrastructure that enables it to provide data integrity, performance, and the ability to recover user data. DB2 controls and accesses system objects.

Read More : http://vinaytechs.blogspot.com/2009/12/db2-system-objects.html

how to tune the joins?

A SQL statement involving two or more tables requires Oracle join data from multiple sources in order to achieve the desired result. The Oracle Server has several built in methods for performing joins, and each method has its own performance and resource usage qualities. While an application developer or DBA doesn’t need to explicitly tell Oracle which join method to use or the order in which different tables should be joined, a solid understanding of how Oracle processes joins allows us to design and build systems for optimal performance. In this presentation we’ll examine the different methods Oracle uses for joining data from multiple sources, and we’ll see how this understanding can be used to design better database schemas, tune SQL statements, and tune databases as a whole for better join performance. Since most SQL statements involve joins, tuning joins leads to improved overall system performance.

Read More : http://vinaytechs.blogspot.com/2009/12/how-to-tune-joins.html

HQL & Hibernate Mappings

Introduction to HQL

HQL is fully object-oriented, understanding notions like inheritance, polymorphism and association. HQL allows representing SQL queries in object-oriented terms—by using objects and properties of objects. Queries are case-insensitive, except for names of Java classes and properties. The tables are mapped to Java classes in the hbm files. The columns in the tables are mapped to the properties in the hbm file and those properties are set in the Java class.

Read More : http://vinaytechs.blogspot.com/2009/12/hql-hibernate-mappings.html

Developing a Struts2 application step by step

Introduction

Struts is a well-organized framework based on MVCarchitecture. In Model-View-Controller Architecture, Model stands for the business or database code, View represents the page design code and the Controller for navigational code. All these together makes Struts an essential framework for building Java applications. But with the development of new and lightweight MVC based frameworks like Spring, Stripes and Tapestry, it becomes necessary to modify the Struts framework. So, the team of Apache Struts and another J2EE framework,WebWork of OpenSymphony joined hand together to develop an advanced framework with all possible developing features that will make it developer and user friendly.

Read More : http://vinaytechs.blogspot.com/2009/12/developing-struts2-application-step-by.html

Exception handling in Oracle(9i)

Oracle 9i: Exception Handling

This article covers Oracle Exception Handling and the different types in it with sample SQL scripts along with the screen shots. Topics covered in this are, Introduction to Exception Handling – Propagation of Errors Types of Exceptions – Named System Exceptions; Unnamed System Exceptions; User-Defined Exceptions, SQL error code, SQL error message.

Read More : http://vinaytechs.blogspot.com/2009/12/exception-handling-in-oracle9i.html

Windows 7 Key Board Shortcuts

General keyboard shortcuts

* F1: Display Help
* Ctrl + C (or Ctrl + Insert): Copy the selected item
* Ctrl + X: Cut the selected item
* Ctrl + V (or Shift + Insert): Paste the selected item
* Ctrl + Z: Undo an action
* Ctrl + Y: Redo an action

Read More : http://vinaytechs.blogspot.com/2009/12/windows-7-key-board-shortcuts.html

Performance Tuning in Applications Using Hibernate

This article gives an introduction to Hibernate and brief overview of how to tune the Hibernate components and various strategies used to tune the application which uses Hibernate.

More info : http://vinaytechs.blogspot.com/2009/12/performance-tuning-in-applications.html

Crypto with RSA Key encryption

This article describes how to configure crypto isakmp with RSA encryption key on any WAN link; in this case all data will be transferred in encrypted form………..

More Info : http://vinaytechs.blogspot.com/2009/12/crypto-with-rsa-key-encryption.html