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 […]

Oracle Error Codes (ORA-00601 to ORA-00999)

ORA-00601: cleanup lock conflict ORA-00602: internal programming exception ORA-00603: fatal ORACLE error occurred; unwise to proceed ORA-00604: error occurred at recursive SQL level num ORA-00700: maximum number of row cache object (parameter ‘name’) exceeded ORA-00701: object necessary for warmstarting database cannot be altered ORA-00702: maximum number of row cache enqueues exceeded ORA-00703: maximum number of […]

Oracle Error Codes (ORA-00446 to ORA-00600)

ORA-00301: error in adding log file ‘name’ – file cannot be created ORA-00302: limit of num logs exceeded ORA-00305: log ‘name’ inconsistent; belongs to another database ‘name’ ORA-00306: limit of num log writer instances exceeded ORA-00308: cannot open offline log‘name’ ORA-00309: offline log belongs to wrong database ‘name’ ORA-00310: offline log ‘name’ contains sequence num; […]

Oracle Error Codes (ORA-00000 to ORA-00300)

ORA-00000: normal, successful completion ORA-00001: duplicate key in index ORA-00014: there no session number num in this process ORA-00017: maximum number of calls exceeded ORA-00018: maximum number of sessions exceeded ORA-00019: maximum sessions per process (num) exceeded ORA-00020: maximum number of processes (num) exceeded ORA-00051: timeout occurred while waiting for resource ORA-00052: maximum number of […]

How make LOV in oracle forms builder?

You can make LOV step by step 1- Open form builder draw two fields 1st filed name “UOM_ID” and second field name “UOM_NAME” 2- Just Click on LOV option in list and click on green “+” button for new. 3- Click next and write the query in it. 4- select fields in it by using […]

Oracle Database Questions & Answers 3

61. What constitute an ORACLE Instance ? SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process. 62. What is SGA ? The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. 63. What are […]

Oracle Database Questions & Answers 2

What is Network Database link ? Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition. What is Data Block ? ORACLE database’s data is […]

Oracle Questions and Answers (Main Categories)

Oracle General Question & Answers Oracle SQL/PLSQL Question & Answers Oracle Database Question & Answers Oracle Forms Builder Question & Answers Oracle Reports Builder & Answers

Oracle Reports Builder (Main Categories)

How to make tabular report? How to make group by report? How to make address report? How to make matrix report? How to make function in report? How to call image on report? Call parent report to child report?

What’s New in Oracle Database Solutions?

You’re invited to join senior Oracle Database leaders for a live chat explaining what the latest product innovations coming out of Oracle OpenWorld mean for you and your business. Get real-time advice and answers to your top questions: • In-Memory Databases or Big Data? • Engineered or DIY Systems? • Appliances or machines? • Private […]

Oracle Public Cloud

The Oracle Database Cloud Service gives you the world’s leading database, instantly available, which you can use with your choice of development tools. The Database Cloud Service can grow as your needs change. The Database Cloud Service comes with Oracle Application Express, a rapid application development (RAD) tool, full support for Java applications, and a […]

Oracle Buys Endeca

On October 18, 2011, Oracle announced it has entered into an agreement to acquire Endeca, a leading provider of unstructured data management, web commerce and business intelligence solutions. The transaction is subject to customary closing conditions and is expected to close before the end of 2011. After the transaction closes, Oracle with Endeca plans to […]

How to make first Oracle Report? (Tabular Report)

1- Open Oracle Reports Builder 2- Press (CTRL+N) 3- A dialog box will appear then select option “Use the report wizard” 4-  Choose Report by wizard and click OK. 5- Click Next 6- Choose Tabular and click Next 7- Write Query and Click Next 8-Click on ” >>” to select no. of columns that will […]