Oracle SQL Tuning with Oracle SQLTXPLAIN

By Stelios Charalambides
Apress Buy from amazon.com
Oracle SQL Tuning with Oracle SQLTXPLAIN is a practical guide to SQL tuning the way Oracle’s own experts do it, using a tool called SQLTXPLAIN. Using this simple tool—downloadable from My Oracle Support—you’ll learn how to tune even the most-complex SQL. Firmly based in real-world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance: badly tuned SQL. You’ll learn how the optimizer works, how to take advantage of its latest features, and when it’s better to turn those features off. 

OCA Oracle Solaris 11 System Administration Exam Guide (Exam 1Z0-821)

By Michael Ernest
Oracle Press Buy from amazon.com
Written by an Oracle Solaris expert who has been teaching courses on Oracle Solaris for the last 15 years, this book covers all objectives of the OCA Oracle Solaris 11 System Administration Exam. Author Michael Ernest also highlights key exam information and potential exam pitfalls. Practice questions at the end of every chapter test comprehension and simulate actual exam questions. The CD-ROM that accompanies the book features additional practice exam questions in the form of two complete practice exams that mirror the actual exam in content, style, tone, format, and difficulty. In addition to preparing you for the OCA exam, this exam guide also serves as a system administrator’s reference guide for Oracle Solaris 11.

Oracle WebLogic Server 12c—Distinctive Recipes

By Frank Munz
munz & more Buy from amazon.com
This book is an anthology of best practices in Oracle WebLogic Server administration, architecture, performance tuning, and monitoring. It was written for software architects, administrators, and developers who are familiar with Oracle WebLogic Server and want to know more. Author Frank Munz provides recommendations, discussions, best practices, deployable projects, Webcast videos, and directions on when to use a feature—and when not to. Other topics include the merged Java Virtual Machine, using JMX with your own applications, stuck threads, JDBC myths, effectively detecting memory leaks, Java EE examples (including deployments and NetBeans projects), Oracle Fusion Middleware, and using Oracle WebLogic Server in the cloud. Author Frank Munz is the 2011 recipient of the Oracle Excellence Award for Technologist of the Year: Cloud Architect. 

Oracle Snap Management Utility for Oracle Database Unveiled

Oracle has introduced Oracle Snap Management Utility for Oracle Database, an enhancement for its Sun ZFS Storage Appliance that streamlines and accelerates critical tasks required for data protection and secondary processing by 88 percent. It accelerates the creation and management of snapshot-based copies and clones of Oracle databases by reducing the steps required from 9 to 1 for snapshots and 12 to 1 for clones. Learn More...

Oracle Database Appliance X3-2 Unleashed

Now available, Oracle Database Appliance X3-2—a fully integrated system of software, servers, storage, and networking—provides up to twice the performance and more than four times the storage capacity of the original Oracle Database Appliance. The new release includes 512 GB of memory, 18 TB SAS disk storage, and 800 GB flash to enhance performance for online transaction processing (OLTP) and data warehousing. Learn More...

Oracle VM 3.2 Released

The latest release of Oracle’s virtualization management product, Oracle VM 3.2, delivers unified management and enhanced automation capabilities for Oracle’s SPARC T-Series servers running Oracle VM Server for SPARC as well as x86-based servers running Oracle VM Server for x86. Oracle VM also includes MySQL Enterprise Edition for use as a management repository, but organizations can choose to use Oracle Database, Enterprise Edition; Oracle Database, Standard Edition; or MySQL Enterprise Edition as the Oracle VM management repository when deploying in production environments. Learn More...

Oracle Buys Acme Packet

Oracle has agreed to acquire Acme Packet, the leading global provider of session border control technology. The combination of Oracle and Acme Packet is expected to accelerate the migration to all-IP networks by enabling secure and reliable communications from any device, across any network. Learn More...

Now Available: MySQL 5.6

The latest release of the MySQL open source database delivers increased performance, scalability, reliability, and manageability for the next generation of Web, cloud, and mobile applications. MySQL 5.6 improves developer agility with subquery optimizations, online data definition language operations, NoSQL access to InnoDB, new instrumentation in the Performance Schema feature, and better condition handling. Learn More...

Oracle’s PeopleSoft 9.2 Released

Oracle has unveiled Release 9.2 of PeopleSoft Human Capital Management, PeopleSoft Financials, PeopleSoft Enterprise Service Automation, and PeopleSoft supply chain management and supplier relationship management applications. The new release delivers 1,000 new features, functions, and enhancements; a new user experience; expanded product functionality; and a solution that is more cost effective to manage. This release also features new mobile capabilities including mobile requisitioning for purchasing users, as well as expanded capabilities for mobile inventory, expenses, approvals, and company directory. Learn More...

Oracle Developer Advanced Forms and Reports

Peter Koletzke Buy from amazon.com See also Oracle Forms Recipes
Develop powerful web-based and client/server applications in record time. Maximize the power of Oracle Developer to create sophisticated, flexible, and user-friendly database applications. This unique guide contains an invaluable resource--a discussion of actual Forms and Reports standards used by the authors to create production systems. Included are standards for the use of SQL and PL/SQL in the development tools, naming conventions, and GUI design. In addition, there is extensive coverage of advanced techniques you can use to save time when developing and maintaining your forms and reports. Examples are based on the authors' award-winning Forms template used in many real-world projects.

Inside, learn to:
  • Take advantage of Oracle Developer's object-oriented features
  • Build simple applications in less than an hour and more complex ones in a day or two
  • Create and deploy standards for best practices, code sharing, and object reuse
  • Use Forms and Reports templates to create custom applications with a consistent look and feel
  • Master the GUI design features of Forms and Reports

Oracle Application Server 10g Web Development

Chris Ostrowski, Bradley Brown Buy from amazon.com
Develop flexible, cross-platform Web applications using Oracle Application Server 10g and this exclusive Oracle Press guide. Take advantage of the full support for all major Web development languages, APIs, and frameworks and learn to create and test applications quickly, interface with the Oracle database seamlessly, and deploy your applications to the Web securely. Inside you’ll find full details on J2EE integration, Oracle Forms 10g, Oracle Reports 10g, OracleAS Discoverer 10g, OracleAS Portal, and Oracle JDeveloper 10g.

Commercial Application Development Using Oracle Developer 2000

Ivan Bayross Buy from amazon.com
A very good book for Oracle Reports and Forms developers freshers and professionals.

Paperback: 604 pages
Publisher: BPB Publications (August 13, 2003)
Language: English
ISBN-10: 8176560685
ISBN-13: 978-8176560689
Product Dimensions: 9.2 x 7.2 x 1.2 inches
Shipping Weight: 1.8 pounds

A very nice ebook on building reports in Oracle fusion middleware 11g. This manual is intended for anyone who uses Oracle Reports to build reports. The needs of both novice and advanced users are addressed. Following the step-by-step instructions, you can build the example reports from start to finish. Each report that you build will demonstrate how to use many of the powerful features in Reports Builder. To free download this ebook click the below link:

Free Download Oracle Reports Builder Guide 11g From Google Drive 

Suppose you want to scan a tabular grid block (loop through all records in detail block) from top to bottom in Oracle forms. You can do this task by using :system.last_record system variable to determine whether it is last record in a block and then exit.


   --- then move to first record
      --- do some processing
      if :system.last_record = 'TRUE' then
      End if;
   End Loop;
   --- after exiting move to top

Norton internet security is one of the my favorite internet security software, I always prefer to have this one on my system rather than any other anti virus protection software. I believe that if Norton antivirus or internet security is in your system then you don't have to worry for the threats or any kind of virus and spyware.

But always remember to have original Norton internet security or antivirus software because a pirated software will not protect your system but make them vulnerable. So to download the latest original Norton internet security or antivirus click the below link.
Norton Internet Security’s five patented layers of protection and powerful cloud features protect you from threats, no matter where you go or what you do online.

Download size: 139.08 MB

Protects Against

All types of viruses and spyware
Online identity theft when you bank or shop
Bad files and websites when you browse and share
Phishing scams
Theft of your personal information
Hard-to-remove infections
Social network threats when you socialize

Key Features and Benefits

Stops all types of online threats from ever reaching you, no matter where you go or what you do online. Our five patented layers of protection quickly and accurately detect and eliminate almost any threat, including viruses that hackers haven’t even created yet.

Protects your most personal information when you surf, shop, and socialize online by guarding your browser, your passwords, and your private data.

Ultra-fast Internet network layer stops threats before they can reach your PC.
Browser protection blocks “phishing” websites set up to trick you into revealing your passwords, credit card numbers, and other confidential information.

Scans your Facebook News Feed for dangerous downloads and suspicious links.
Protects your identity by remembering, securing, and automatically entering your user names and passwords.

Makes it easier to protect your kids when they go online by letting you manage Norton Online Family from within the product.

Learn More...

Giving date picker calendar option to user for date type fields in Oracle Forms. I am providing you the form (FoxCal.Fmx) and two libraries (General.plx and Calendar.pll). You can download these files by clicking below link:

Download Form and required PLL

Like us to get notifications for free source code in future, thanks.

How To Use

It is very simple to use, no need to attache any library to your form, just copy all three files to your current working directory of your application. Suppose you have a form and there is one or many date date type fields in the form. You have to create key-listval trigger for those date type fields or create a push button adjacent to those fields and paste the below code in when-button-pressed trigger:

pl_id paramList;
  pl_id := Get_Parameter_List('foxcal');
  IF NOT Id_Null(pl_id) THEN  
  end if;
  pl_id := create_parameter_list('foxcal');
  add_parameter(pl_id, 'XPOS', text_parameter, to_char(50));
  add_parameter(pl_id, 'YPOS', text_parameter, to_char(100));
  add_parameter(pl_id, 'CURRDATE', text_parameter, to_char(Sysdate));
  add_parameter(pl_id, 'Label', text_parameter, 'Date Picker');
  CALL_FORM('foxcal', no_hide, do_replace, query_only, no_share_library_data, pl_id);
  :yourdateitem := :Global.G_LOV_Date;

Note: Your current working directory for form designer and runtime should be the directory where you copied the above mentioned three files.
Download the demo form from the following link Date Picker Demo


Determining current block in Oracle Forms Using SYSTEM.CURSOR_BLOCK system variable. The value that the SYSTEM.CURSOR_BLOCK system variable represents depends on the current
navigation unit:
If the current navigation unit is the block, record, or item (as in the Pre- and Post- Item, Record, and Block triggers), the value of SYSTEM.CURSOR_BLOCK is the name of the block where the cursor is located. The value is always a character string. If the current navigation unit is the form (as in the Pre- and Post-Form triggers), the value of SYSTEM.CURSOR_BLOCK is NULL.


Assume that you want to create a Key-NXTBLK trigger at the form level that navigates depending on what the current block is. The following trigger performs this function, using :SYSTEM.CURSOR_BLOCK stored in a local variable.

curblk VARCHAR2(30);
curblk := :System.Cursor_Block;
IF curblk = ’ORDERS’
THEN Go_Block(’ITEMS’);
ELSIF curblk = ’ITEMS’
THEN Go_Block(’ORDERS’);


Determining current item using System.Cursor_Item in Oracle Forms. SYSTEM.CURSOR_ITEM represents the name of the block and item, block.item, where the input focus (cursor) is located.The value is always a character string.

Usage Notes
Within a given trigger, the value of SYSTEM.CURSOR_ITEM changes when navigation takes place. This differs from SYSTEM.TRIGGER_ITEM, which remains the same from the beginning to the end of single trigger.

Assume that you want to create a user-defined procedure that takes the value of the item where the cursor is located (represented by SYSTEM.CURSOR_VALUE), then multiplies the value by a constant, and then reads the modified value into the same item. The following user-defined procedure uses the COPY built-in to perform this function.

new_value NUMBER;
new_value := TO_NUMBER(:System.Cursor_Value) * .06;
Copy(TO_CHAR(new_value), :System.Cursor_Item);

View Oracle Developer Handbook at Amazon.com 

Subscribe To Get Email Notifications For Latest Updates Like This:
Enter your email address:

Delivered by FeedBurner

Pro Oracle SQL

Pro Oracle SQL is the very good book on the market today. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Profiles to optimize SQL in packaged applications, and much more. You'll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. To download this ebook Click Here


Oracle SQL Tuning Pocket Reference

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify. To download this ebook Click Here


SQL Pocket Guide 3rd Edition

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL information into an accessible summary. To download this ebook Click Here

You want to add a value in Combo List item in Oracle Forms, by typing it in combo list box text area. Here is the example is given for the same, you can write following block in When-Validate-Item trigger for the combo box item:

Write the following code in When-Validate-Trigger of combo box:

   total_list_count      Number (10);
   loop_index_var        Number (10)                  := 1;
   list_element          Varchar2 (50);
   list_element_value    Varchar2 (50);
   list_element_to_add   Varchar2 (50);
   list_value_to_add     Varchar2 (50);
   element_match         Varchar2 (5)                 := 'FALSE';
   value_match           Varchar2 (5)                 := 'TRUE';
   list_id               item                         := Find_item ('YOURBLOCK.COMBOLIST1');
   total_list_count := Get_list_element_count (list_id);
   List_element_to_add := :YOURBLOCK.COMBOLIST1;

      list_element := Get_list_element_value (list_id, loop_index_var);
      loop_index_var := loop_index_var + 1;

      IF list_element_to_add = list_element
         element_match := 'TRUE';
      END IF;

      EXIT When list_element = list_element_to_add;

   list_value_to_add := list_element_to_add;

   IF element_match = 'FALSE'
      Add_list_element (list_id, total_list_count + 1, list_element_to_add, list_value_to_add);
   END IF;

--- element added...

   When form_trigger_failure
   When Others
      Message (SQLERRM);

Oracle Enterprise Manager 12c has helped Oracle customers deliver enterprise private cloud services up to ten times faster while helping them free up administration resources. Read more to discover how it can help your organization to streamline IT management processes and guide you in your transformation to cloud.

I am giving below the references for the Top 3 Oracle Enterprise Manager 12c books:

Building and Managing a Cloud Using Oracle Enterprise Manager 12c

By Madhup Gulati, Adeesh Fulay, and Sudip Datta View at Amazon.com
Building and Managing a Cloud Using Oracle Enterprise Manager 12c combines the science and art of leveraging Oracle technologies to build a cloud from scratch or to build on existing IT investments. The authors teach you how to quickly design and implement the various aspects of a cloud lifecycle, from setup to delivery to operation, with a focus on Oracle Enterprise Manager 12c. Strategies and best practices for building a solid cloud foundation for increased operational efficiency, greater business agility, and reduced costs are included.

Oracle Exadata Recipes

By John Clarke View at Amazon.com
Oracle Exadata Recipes takes an example-based, problem/solution approach in showing how to size, install, configure, manage, monitor, optimize, and migrate Oracle Database workloads on and to Oracle Exadata Database Machine. Whether you’re an Oracle DBA, UNIX/Linux administrator, storage administrator, network administrator, or Oracle developer, Oracle Exadata Recipes provides effective and proven solutions to accomplish a wide variety of tasks on Oracle Exadata Database Machine. You will learn how to install and configure Oracle Exadata, manage your Oracle Exadata hardware infrastructure, monitor and troubleshoot performance issues, and manage smart scan and cell offload processing.

Expert Oracle Enterprise Manager 12c

By Kellyn Pot’Vin, Anand Akela, Gokhan Atil, Alex Gorbachev, Niall Litchfield, Leighton Nelson, and Pete Sharman View at Amazon.com
DBAs and system administrators are expected to offer increasing levels of service for 24/7 systems and cloud environments. Oracle Enterprise Manager 12c offers robust, end-to-end intelligent management of the complete systems environment. Expert Oracle Enterprise Manager 12c covers basic monitoring and configuration, advanced metric extensions, and plug-ins while providing real-life scenarios and demonstrations that will help you become familiar with using the Oracle Enterprise Manager 12c console.

A simple and secured way to encrypt and decrypt data in Oracle 11g with DBMS_OBFUSCATION_TOOLKIT package. DBMS_OBFUSCATION_TOOLKIT enables an application to encrypt data using either the Data Encryption Standard (DES) or the Triple DES algorithms.

The following Toolkit package uses DBMS_OBFUSCATION_TOOLKIT package to encrypt and decrypt data.

Note: You must modify the key defined in this package to have your custom secret encryption method. The data is encrypted by the key can be decrypt only with that key. Learn More...

To encrypt data:
select toolkit.encrypt('The test data 123.') from dual;
To decrypt data:
select Toolkit.decrypt('5C8ADD7B98919FC937A53AB986782EA9EE63D4ADDF7CA322') from dual;
The test data 123.

Create Or Replace PACKAGE Toolkit As
  FUNCTION encrypt (p_text  In  VARCHAR2) RETURN RAW;
  FUNCTION decrypt (p_raw  In  RAW) RETURN VARCHAR2;
END Toolkit;

Create Or Replace PACKAGE BODY Toolkit As
  ---- the custom key for
  g_key     RAW(32767)  := UTL_RAW.cast_to_raw('20130417');
  ---- the custom padding character
  g_pad_chr VARCHAR2(1) := '_';

  PROCEDURE padstring (p_text  In OUT  VARCHAR2);

  FUNCTION encrypt (p_text  In  VARCHAR2) RETURN RAW Is
    l_text       VARCHAR2(32767) := p_text;
    l_encrypted  RAW(32767);
    DBMS_OBFUSCATION_TOOLKIT.desencrypt(input          => UTL_RAW.cast_to_raw(l_text),
                                        Key            => g_key,
                                        encrypted_data => l_encrypted);
    RETURN l_encrypted;

  FUNCTION decrypt (p_raw  In  RAW) RETURN VARCHAR2 Is
    l_decrypted  VARCHAR2(32767);
    DBMS_OBFUSCATION_TOOLKIT.desdecrypt(input => p_raw,
                                        Key   => g_key,
                                        decrypted_data => l_decrypted);
    RETURN Rtrim(UTL_RAW.cast_to_varchar2(l_decrypted), g_pad_chr);

  PROCEDURE padstring (p_text  In OUT  VARCHAR2) Is
    l_units  NUMBER;
    IF Length(p_text) Mod 8 > 0 Then
      l_units := Trunc(Length(p_text)/8) + 1;
      p_text  := Rpad(p_text, l_units * 8, g_pad_chr);
    END IF;

END Toolkit;

The Beatles... Let it be naked...

Stripped back to its brilliant basics and free from post-production embellishment, Let It Be… Naked presents the group's final album as The Beatles intended it to be. Refreshingly simple versions of "Across the Universe" and "The Long and Winding Road" and bonus rehearsal recordings complete the intimate package. Live performance footage of two classic tracks is also now available. Buy at Amazon.com

Aashiqui 2 (Original Motion Picture Soundtrack)

The sequel to the blockbusting soundtrack for Aashiqui arrives in grand style by stringing together songs from Bollywood masters like Mithoon, Jeet Ganguly and Ankit Tiwari to tell an epic love story.Check it Out at Apple.com

Anna Karenina

Set amid the glittering high society of Imperial Russia in the late 19th century, this sumptuous adaptation of Tolstoy's novel features opulent sets, striking cinematography and the reunion of Pride & Prejudice director Joe Wright and star Keira Knightley. Buy at Amazon.com

Retrieves the sequence number of the selected row for the given group. Suppose you want to get a particular column value from a record group for the all rows or for particular rows, then you can use get_group_selection built-in to perform the task.


Built-in: GET_GROUP_SELECTION Example: Return a comma-separated list (string) of the selected part  numbers from the presumed existent PARTNUMS record group.
FUNCTION Comma_Separated_Partnumbers
tmp_str VARCHAR2(2000);
rg_id RecordGroup;
gc_id GroupColumn;
the_Rowcount NUMBER;
sel_row NUMBER;
the_val VARCHAR2(20);
rg_id := Find_Group(’PARTNUMS’);
gc_id := Find_Column(’PARTNUMS.PARTNO’);
Get a count of how many rows in the record group have been marked as "selected"
the_Rowcount := Get_Group_Selection_Count( rg_id );
FOR j IN 1..the_Rowcount LOOP
Get the Row number of the J-th selected row.
sel_row := Get_Group_Selection( rg_id, j );
Get the (VARCHAR2) value of the J-th row.
the_val := Get_Group_CHAR_Cell( gc_id, sel_row );
IF j = 1 THEN
tmp_str := the_val;
tmp_str := tmp_str||’,’||the_val;
RETURN tmp_str;

People love using iPad. We know because they've said so. In a study by J.D. Power and Associates, Apple ranked "Highest in Customer Satisfaction Among Tablets" in the US. And because people love iPad so much, they're doing more with it — a lot more.

View at Amazon.com

Only iPad has so many apps

With more than 300,000 apps made just for iPad, there's almost no end to what you can do.2 These aren't merely scaled-up versions of phone apps. They're powerful apps that take full advantage of everything iPad has to offer.

It's beautifully made. And performs beautifully

iPad is exquisitely designed using smooth glass on the front and precision-cut aluminium on the back. But there's more to it than meets the eye. With powerful chips and fast graphics, the true beauty of iPad may just be how capable it is.

Two great sizes. Two brilliant displays

The ultra-high-resolution screen on iPad with Retina display makes everything look crisp and lifelike. While the iPad mini display is bright and vivid, and a perfect canvas for all the apps made for iPad.

A battery that lasts as long as you will

Great battery life has always been one of the things that makes an iPad an iPad. Even with its slim design and incredible performance, iPad has an astounding 10-hour battery life.3

Smile for the camera. Both of them

The iSight camera on the back of iPad lets you shoot beautiful 5-megapixel still images and record HD video in 1080p. And the front-facing FaceTime HD camera lets you make video calls on the big, beautiful iPad screen.

iPad gives you ultra-fast wireless

With dual-band Wi-Fi, you can browse, download and stream content at remarkable speeds. And because Wi-Fi + Cellular models support fast data networks all over the world, you can connect no matter where you are.4

Millions of ways to play, work and learn. From one trusted source

The more apps, music, films and books you download to your iPad, the better it gets. And with iPad, all that content is available from one trusted source: Apple. We even review every app to guard against malware.

iOS 6. The world's most advanced mobile operating system.

The innovative features and built-in apps in iOS 6 make iPad not only easy to use but also incredibly fun. Every iOS software update downloads straight to iPad. And because Apple makes both the hardware and software, everything is designed to work together.

iCloud puts your content on all your devices.

iCloud stores your content — your music, photos, apps, mail, contacts, calendars, documents and more — and wirelessly pushes it to all your devices. It's seamlessly integrated into your apps, so you're up to date
everywhere you go. All you have to do is nothing.

Oracle ADF Mobile Available

Oracle has unveiled Oracle ADF Mobile, a new HTML5 and Java-based application development framework that enables developers to build, deploy, and extend hybrid mobile applications for multiple platforms, including iOS and Android, from a single code base. An extension of Oracle Application Development Framework, Oracle ADF Mobile enables organizations to protect their investments while  addressing frequently changing mobile requirements by allowing developers to rapidly and visually develop applications once and deploy them to multiple devices and platforms.
View Book Reference For Oracle ADF at Amazon.com

Oracle Application Express Release 4.2 Available

The latest release of Oracle Application Express allows developers to rapidly build database-centric HTML5 applications using only a Web browser. These applications can run on any mobile platform. Oracle Application Express is a no-cost option included with all editions and current releases of Oracle Database. Oracle Application Express 4.2 is available now for download from Oracle Technology Network.

Oracle NoSQL Database 11g Release 2 Increases Performance

Oracle has released Oracle NoSQL Database 11g Release 2, a highly scalable, low-latency, key-value database for real-time big data workloads. A key component of the Oracle Big Data platform, Oracle NoSQL Database 11g Release 2 enables organizations to easily manage high-velocity transactional data generated by Web-based applications, social media, sensors, smart meters, and communications services.

I shared a data entry example form here in this post for Oracle Forms beginner developers, so that they may take an idea to how to develop a simple data entry form in Oracle Forms. The form can be fully modified.

Example is given for an emp table and other related tables. You can download Emp.fmb form from Google drive by clicking here Emp.Fmb Form

To run this form you would require some tables in Payroll schema, so create a user/schema with name Payroll and run the following script:

-- start


  DEPT      VARCHAR2(60 BYTE),
  ADDR1     VARCHAR2(60 BYTE),
  ADDR2     VARCHAR2(60 BYTE),
  CITY      VARCHAR2(30 BYTE),
  DOJ       DATE,
  DOR       DATE,
  DOP       DATE,
  PFNO      VARCHAR2(30 BYTE),
  BASIC     NUMBER(10)                          DEFAULT 0,
  HRA       NUMBER(10)                          DEFAULT 0,
  CONV      NUMBER(10)                          DEFAULT 0,
  MEDC      NUMBER(10)                          DEFAULT 0,
  BONUS     NUMBER(10)                          DEFAULT 0,
  TEL       NUMBER(10)                          DEFAULT 0,
  OTHA      NUMBER(10)                          DEFAULT 0,
  CL        NUMBER(3)                           DEFAULT 0,
  EL        NUMBER(5)                           DEFAULT 0,
  SL        NUMBER(3)                           DEFAULT 0,
  PFA       NUMBER(10)                          DEFAULT 0,
  TDS       NUMBER(10)                          DEFAULT 0,
  TDSMB     NUMBER(2)                           DEFAULT 0,
  ADVTOTAL  NUMBER(10)                          DEFAULT 0,
  ADVDED    NUMBER(10)                          DEFAULT 0,
  FY        VARCHAR2(9 BYTE),
  CP        VARCHAR2(30 BYTE),
  FYCP      VARCHAR2(40 BYTE),
  ESI       NUMBER(10,2),
  TDSDED    NUMBER(10,2)

  CP    VARCHAR2(30 BYTE),

  TRANID      NUMBER(10),
  ECODE       VARCHAR2(10 BYTE),
  ENAME       VARCHAR2(60 BYTE),
  NOOFWD      NUMBER(3),
  NETCONV     NUMBER(10,2),
  NETMED      NUMBER(10,2),
  NETTEL      NUMBER(10,2),
  NETHRA      NUMBER(10),
  OT_HRS      NUMBER(10),
  OT_SAL      NUMBER(10,2),
  OTHER_A     NUMBER(10),
  GRS_SAL     NUMBER(10,2),
  PFA         NUMBER(10),
  ESIA        NUMBER(10),
  TDS         NUMBER(10,2),
  ADVI        NUMBER(10),
  OTH_DED     NUMBER(10),
  CLT         NUMBER(2),
  ELT         NUMBER(2),
  SLT         NUMBER(2),
  TL          NUMBER(2),
  CAA         VARCHAR2(1 BYTE),
  FY          VARCHAR2(9 BYTE),
  CP          VARCHAR2(30 BYTE),
  FYCP        VARCHAR2(40 BYTE),

Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT
Insert into DEPT

Insert into DESIG
Insert into DESIG
Insert into DESIG
   ('SR. MANAGER');
Insert into DESIG
Insert into DESIG
Insert into DESIG
   ('DY. MANAGER');
Insert into DESIG
Insert into DESIG
Insert into DESIG
Insert into DESIG
Insert into DESIG
Insert into DESIG
Insert into DESIG

Insert into EMP
    TEL, OTHA, CL, EL, SL,
   ('1000', 'ABC', 'xyz', 'abc', NULL,
    NULL, 'NEW DELHI', 'DELHI', '110020', NULL,
    TO_DATE('08/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, '12345', '654123',
    8000, 2500, 500, 1000, 5000,
    500, 250, 7, 31, 8,
    780, 1000, 5, 10000, 500,
    '254252525632548', '2010-2011', 'LTD.', '2010-2011 INTERNATIONAL LTD.', 210,
Insert into EMP
    TEL, OTHA, CL, EL, SL,
    NULL, 'GHAZIABAD', 'UP', '110020', '9540377373',
    TO_DATE('01/10/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, NULL, NULL,
    10000, 4000, 1000, 1000, 5000,
    1000, 2000, 7, 31, 8,
    780, 2000, 2, 50000, 1000,
    NULL, '2010-2011', 'INTERNATIONAL LTD.', '2010-2011 INTERNATIONAL LTD.', 0,
Insert into EMP
    TEL, OTHA, CL, EL, SL,
   ('93993', 'VIN', 'AGM', 'ACCOUNTS', NULL,
    NULL, 'NEW DELHI', 'DELHI', '110020', NULL,
    TO_DATE('01/01/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, NULL, NULL,
    33333, 0, 0, 0, 0,
    0, 0, 7, 31, 8,
    780, NULL, 1, NULL, NULL,
    NULL, 'FY', 'FY', 'FY', 0,

Insert into FYCPT
   (FY, CP, FYCP)
   ('2010-2011', 'INTERNATIONAL LTD.', '2010-2011 INTERNATIONAL LTD.');

-- end

Apple launched most advanced iMac yet. It’s just 5mm thin at its edge with up to 40 per cent less volume than the previous generation. To do all that required unprecedented feats of engineering — and imagination. Apple invented new technologies, pioneered new manufacturing techniques and devised all-new ways to do more in less space.

The enclosure is so thin, it’s not possible to weld the pieces using traditional methods. Apple used friction-stir welding, which is commonly used on airplane wings, rocket booster tanks and other parts that simply can’t fail. This process uses a combination of intense friction-generated heat and pressure to intermix the molecules of the two aluminium surfaces — creating a seamless, precise and super-strong join. You may not see it, but this iMac wouldn’t be possible without it.

 Apple iMac View at Amazon.com

The new Oracle JDeveloper and Oracle ADF includes fixes as well as several new features. This release is aligned with the rest of the components of Oracle Fusion Middleware including SOA, WebCenter and Oracle Cloud. For all the details please review the following documents in the documentation library:
Some of the new features in this release include the following:
  • Simpler look and feel with the Skyros Skin
  • Visualization components including Treemap, Sunburst, and Timeline
  • List View
  • PanelGridLayout
  • Code Editor
  • Much More...
Download this release to try out all the new features and be sure to leverage the documentation library to find out about these features / functionality as well as to gain access to the developer's guide and more.
In this newsletter we collected the resources that will get you up to speed with Oracle JDeveloper & Oracle ADF

Oracle 11g Anti-Hacker’s Cookbook

By Adrian Neagu View at Amazon.com
This book covers the most-important security measures as well as tips and tricks that can be used for better Oracle Database 11g security. The author uses real-world scenarios to show you how to secure the Oracle Database server from different perspectives and against different attack scenarios. Almost every chapter has a possible threats section, which describes the major dangers that can be confronted. The initial chapters cover how to defend your operating system, network, data, and users. The defense scenarios are linked and designed to prevent these attacks. The later chapters cover Oracle Database Vault, Oracle Virtual Private Database, Oracle Label Security, and Oracle Audit Vault.

Oracle Business Intelligence 11g Developers Guide

By Mark Rittman View at Amazon.com
This Oracle Press guide explains how to build business intelligence (BI) applications using Oracle Business Intelligence 11g. It covers how to execute effective queries, build accurate models, use scorecards and key performance indicators, create dynamic reports, set up dashboards, and publish to smartphones and wireless devices. The author also describes how to integrate BI applications with Oracle Fusion Middleware security, Oracle WebLogic Server, and Web services. Aimed at developers creating BI solutions using Oracle’s platform, this book also covers Oracle Exalytics In-Memory Machine, a hardware appliance that combines Oracle Business Intelligence and Oracle TimesTen In-Memory Database, for “speed of thought” analytics.

Beginning Database Design, Second Edition

By Clare Churcher View at Amazon.com
Beginning Database Design, Second Edition, provides short, easy-to-read explanations of how to get database design right the first time. It is aimed at novice designers, especially those who are doing ad hoc design as a result of employing end-user tools such as Oracle Application Express, Microsoft Access, and Microsoft Excel. The author offers numerous examples to help readers avoid the many pitfalls faced by new and not-so-new database designers.

Oracle Database 11g Release 2 Performance Tuning Tips and Techniques

By Richard Niemiec View at Amazon.com
Oracle Certified Master Richard Niemiec shows you how to systematically identify and eliminate database performance problems in this updated Oracle Press book. Filled with real-world case studies and best practices, the book details the latest monitoring, troubleshooting, and optimization methods. Learn how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered. In addition, Niemiec discusses how to properly index and partition Oracle Database 11g Release 2; work with Oracle Exadata and Oracle Exalogic Elastic Cloud; and efficiently manage disk drives, RAID arrays, and memory. 

Oracle Advanced PL/SQL Developer Professional Guide

By Saurabh Gupta View at Amazon.com
Master PL/SQL concepts with Oracle Advanced PL/SQL Developer Professional Guide. The book starts with an overview of PL/SQL and outlines the characteristics and benefits of the language. It then covers advanced PL/SQL features that include code writing using collections, tuning recommendations using result caching, and enforcing row-level security. The book also dives deep into the use of Oracle SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection. The book can serve as a study guide for the Oracle Advanced PL/SQL Developer Certified Professional certification. Each major certification topic is covered in a separate chapter, with practice questions included at the end of every chapter.

In this blog I will discuss many recipes regarding CSS interactions with images. Recipes include dealing with borders, manipulating background images, rounding corners on boxes, replacing HTML text with images,  and much more.

Settig a Background Image

Setting a background image that does not repeat. Use the background-image and background-repeat  properties to control the display of an image.

body {
background-image: url(bkgdimg.jpg);
background-repeat: no-repeat;

Creating a Line of Background Images

You want a series of background images to repeat vertically or horizontally. To tile the background images horizontally or along the x-axis, use the following CSS rule:

body {
background-image: url(bkgdimg.jpg);
background-repeat: repeat-x;

To have the background image repeat along the vertical axis, use the repeat-y value for the background-repeat property.

Positioning a Background Image

You want to position a background image in a web page. Use the background-position property to set the location of the background image. To place an image that starts 75 pixels to the right and 150 pixels below the upper-left corner of the viewport, use the following CSS rule:

html {
height: 100%;
body {
background-image: url(bkgdimg.jpg);
background-repeat: no-repeat;
background-position: 75px 150px;
To position center use this:
body {
background-image: url(bkgd.jpg);
background-repeat: no-repeat;
background-position: center;
To place a background image in the lower-right corner, as shown in, you can use the following CSS rule:
body {
background-image: url(bkgd.jpg);
background-repeat: no-repeat;
background-position: bottom right;

Using Multiple Background Images on One HTML Element

You want to place more than one background image within one HTML element.

In CSS3, the shorthand background property can accept multiple sets of background image information as long as commas separate them.

h2 {
border: 1px solid #666;
border-radius: 20px;
-moz-border-radius: 20px;
-webkit-border-radius: 20px;
background: white;
padding-top: 72px;
text-align: center;
background: url(mail.gif) top center no-repeat,
url(printer.gif) 40% 24px no-repeat,
url(gift.gif) 60% 24px no-repeat,
url(content-bkgd.png) 50% 50% repeat-x,
url(heading-sub-bkgd.png) 3em 3em repeat-x,
url(plane.gif) center no-repeat;
font-family: "Gill Sans", Trebuchet, Calibri, sans-serif;
color: #666;

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.