6 Essential Drupal Interview Questions

Name and describe the five conceptual layers in a Drupal system. What is Drupal’s taxonomy system and what are some of its key features? Drupal comes with a built in taxonomy system that allows for categorization of the nodes on a site. The taxonomy system allows for arbitrary definition of terms, as well as arbitrary […]

Hosting For Freelance Developers: PaaS, VPS, Cloud, And More

At a glance, the hosting industry may not appear exciting, but it’s grunts in data centres the world over that keep our industry going. They are, quite literally, the backbone of the Internet, and as such they make everything possible: from e-commerce sites, to smart mobile apps for our latest toys. The heavy lifting is […]

Write Tests That Matter: Tackle The Most Complex Code First

toptal-blog-image-1469463837817-2e9e74c78ea4a99309408b33020036fe

There are a lot of discussions, articles, and blogs around the topic of code quality. People say – use Test Driven techniques! Tests are a “must have” to start any refactoring! That’s all cool, but it’s 2016 and there is a massive volume of products and code bases still in production that were created ten, […]

SQL Database Performance Tuning

Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance. In mid-sized and large companies, most SQL database tuning will be handled by a Database Administrator (DBA). But believe me, there are plenty of developers […]

A New Way of Using Email for Support Apps: An AWS Tutorial

Email may not be as cool as other communication platforms but working with it can still be fun. I was recently tasked with implementing messaging in a mobile app. The only catch was that the actual communication needed to be over email. We wanted app users to be able to communicate with a support team […]

Guide To Budget Friendly Data Mining

Unlike traditional application programming, where API functions are changing every day, database programming basically remains the same. The first version of Microsoft Visual Studio .NET was released in February 2002, with a new version released about every two years, not including Service Pack releases. This rapid pace of change forces IT personnel to evaluate their […]

Oracle Forms Builder 11g Main Screen

Once the appropriate menu item has been clicked on (for Windows), the Oracle Forms Builder Object Navigator will appear. . Note that the Oracle Forms Builder screen has remained virtually unchanged between Versions 9i, 10g and 11g. After starting up Oracle Forms, the main screen will be presented. The menu bar across the top provides […]

Oracle Forms and Reports 11g Starting Information

nstallations for Oracle 10g Developer and Oracle 11g Forms and reports should have similar Oracle Home start menu items. For example, the Oracle 11g Forms and Reports is installed on top of the Oracle Fusion Middleware (also called Weblogic Server) and has the following Start menu items: To run the Oracle 11g Forms Builder under […]

Oracle 9i, 10g and 11g Developer Suite Tools

Oracle Developer Suite contains the following main components: Oracle 9i, Oracle 10g and Oracle 11g Forms – For designing data entry forms. Oracle 9i and Oracle 10g Reports – For designing reports. Oracle 9i, 10g or 11g JDeveloper – For developing Java applications or applets Oracle 9i, 10g or 11g Warehouse Builder and Discoverer – […]

Oracle 9i, Oracle 10g and Oracle 11g Developer Suite Forms and Reports Prerequisites

Before following this tutorial, a student must have a valid user account in an Oracle server or a local installation of an Oracle database. Contact your DBA or systems administrator to learn the details of how Oracle server is set up in your organization. If you have a local instance of the Oracle database, please […]

Introduction To Oracle 9i / 10g / 11g Developer Suite Forms and Reports Tutorial

This tutorial introduces the Oracle 9i, Oracle 10g and Oracle 11g Developer Suite Release 2 that includes Oracle Forms and Oracle Reports. The main objectives are to demonstrate and provide hands-on instructions for creating and modifying data entry and query forms in various configurations, reports and graphics. Caveats: I have been working on this tutorial […]

OracleAtoZ SMS Gateway (Send/Received SMS by using Oracle)

OracleAtoZ SMS Gateway is very useful for many organizations that are dealing with Complains Management System. By using OracleAtoZ SMS Gateway you can Send/Received complain solving SMS messages directly into your Oracle Database. Many organizations that are dealing with customer services like CRM Related Companies, Telephone Companies , Dish TV Companies , Cable TV Network […]

How to send Email in Oracle using Gmail.

oracle-gmail_head

Email sending by using Oracle through Gmail: In oracle we can send email by using two ways. 1- Send Email through Gmail 2- Send Email through Email Exchange server. In this post we will know how to send email by using oracle through gmail. Small compnies can not purchase and manage exchange serves so they […]

What is Oracle Virtual BOX

VirtualBox may be a powerful x86 and AMD64/Intel64 virtualization product for enterprise furthermore as home use. Not solely is VirtualBox a particularly feature made, high performance product for enterprise customers, it’s conjointly the sole skilled resolution that’s freely accessible as Open supply software system underneath the terms of the wildebeest General Public License (GPL) version […]

Chapter No.10 How to save the data in database in Oracle?

In this chapter we will store the data in oracle database. In Chapter No.6 we have designed a form by using oracle forms builder with wizard.  We will store a data of these fields in database now. As we know that we are already created tables in database in Chapter No. 2. Open a form […]

Chapter No.9 Form Item Property

Every item on Oracle Forms Builder has its unique properties.  We can change these properties according to our need of the application. In this chapter we will discuss some important and most usable properties of items.   Tab Property Name Description General Name Use for give proper Item Name Item Type Text Item/List Item/Radio Group […]

Chapter No.8 Form Data Block Property

<<Previous Chapter                                                    Next Chapter>> We are discus here some important properties of Oracle Forms Builder. We can change these properties of block as per need. If we press “F4” on any Block then we will see these properties that are given below. We are here discussing only most useable properties.   Tab Property Name Description […]

Chapter No.7 Detail of Form Canvas, Block and Items

<<Previous Chapter                                                    Next Chapter>> In previous chapters we learn that how to draw the items on canvas. In this chapter we will learn about Canvas, Block and Items. In this pitcher you see that there are different objects of the form. If we want to see “Property” of any object just selects this object and […]

Chapter No.6 Make Database Block with wizard on Canvas

<<Previous Chapter                                                    Next Chapter>> In this chapter we will make Database Block by using Data Block Wizard. By following these steps we can create Database Block on canvas very easily. For Creating Data Block: Click on “Data Blocks” under the forms hierarchy. Then Click on “+” sign on left side for creating new Database Block. […]

Chapter No.5 What is Block in Forms Builder?

<<Previous Chapter                                                    Next Chapter>> What is Block in Oracle Forms Builder? Block is an area where we put all the items in it. Block is a container we put all the items in it but on Canvas we show up these items. Suppose we have five items in Block then we can show all items […]

Chapter No.4 How to draw a Canvas on form?

<<Previous Chapter                                                    Next Chapter>> Canvas is an area of Oracle Form Builder like a ground area where we draw different items on canvas. Like Text Item, List Item, Radio Button, Image and etc… By following these steps you can draw a canvas on form. Click on “Canvas” that is under the hierarchy of Form. Press […]

Chapter No.3 Just Start with the New Form

<<Previous Chapter                                                    Next Chapter>> We will create new form in Oracle Form Builder by following these steps. Go to” FILE” menu then click “NEW” then click “FORM” A new form will create with default name “module” Save this form on any location. This form will save with extension “.FMB” When we compile this with (CTRL+T) […]

Chapter No.2 Make Tables in Oracle Database for Development

<<Previous Chapter                                                    Next Chapter>> We will develop “Inventory Control System” step by step by using Oracle Forms Builder. We will Create necessary table for this system. Supplier Table, Transaction Master Table and Transaction Detail Table. Just run copy these tables script and draw tables in Oracle Database.   –Supplier Table CREATE TABLE SUPPLIER_INFO ( SUPP_ID […]

Chapter No.1 Introduction of Oracle Form Builder

Next Chapter>> Oracle Form Builder is using for making data entry form or screens. By using Oracle Form Builder we can make any type of data entry screen that will use for any purpose. Basically there are three main things that we will use to develop the application. First Oracle Database that is using for […]

Oracle Error Codes (ORA-01001 to ORA-01915)

ORA-01001: invalid cursor ORA-01002: fetch out of sequence ORA-01003: no statement parsed ORA-01004: default username feature not supported; logon denied ORA-01005: null password given; logon denied ORA-01006: bind variable does not exist ORA-01007: variable not in select list ORA-01008: not all variables bound ORA-01009: missing mandatory parameter ORA-01010: invalid OCI operation ORA-01012: not logged on […]