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

How to set Item property in oracle forms builder?

You can easily set Item’s property of different items in form builder. For restrict Insert/Update in item: SET_ITEM_PROPERTY(‘TRANS_ID’,INSERT_ALLOWED,PROPERTY_FALSE); SET_ITEM_PROPERTY(‘TRANS_ID’,UPDATE_ALLOWED,PROPERTY_FALSE); For set required property No in item: SET_ITEM_PROPERTY(‘TRANS_ID’,REQUIRED,PROPERTY_FALSE); For set Enabled/Disabled item: SET_ITEM_PROPERTY(‘TRANS_ID’,ENABLED,PROPERTY_FALSE); For any color to Item: Set_Item_Instance_Property( ‘TRANS_ID’, CURRENT_RECORD,VISUAL_ATTRIBUTE,’VISUAL_ATTRIBUTE_NAME’);    

How to set Form’s Builder windows property?

By using this code we will set window property of the form. Just paste this code on form level in “WHEN-NEW-FORM-INSTANCE”. When you will run form then it will automatically set the property of the windows. ———————————————- set_window_property(forms_mdi_window, window_state, maximize); set_window_property(‘window1’, window_state, maximize); set_window_property(‘window1’, title, ‘Form Header Name’); ———————————————- * If you like this article […]

Pass Parameter from One Form to another

You can easily pass parameters from one form to another form by using this code. we need to transfer values of parent form to child form for different purposes for example for Login name ect…. 1- Make one parent form in oracle forms builder 2- Write this code behind the button of parent form that […]

How to call report through form builder and pass parameter.

You can call report through form builder also you can pass parameters through form to report. Just paste this code behind the button on form builder then call a report On report parameter name: “indent_id” On form parameter name :    “indent_trans_id” Report Name and location: D:\INDENTS.REP ——————————————– declare temp_id paramlist; begin temp_id := CREATE_PARAMETER_LIST(‘V_A’); ADD_PARAMETER(temp_id,’indent_id’,text_parameter,:indent_trans_id); […]

Dynamic List of Values

By using this code you will create dynamic List of values in oracle forms builder. 1- Create table and insert data in to. create table uom ( uom_id number, uom_name varchar2(25) ); insert into uom values(1,’pieces’); insert into uom values(2,’meters’); insert into uom values(3,’yards’); 2- Open forms builder and draw one field on forms builder […]

Download Java 7 Today

      On July 7, 2011, Oracle hosted multiple events around the world to celebrate an important milestone—the release of Java Platform, Standard Edition (Java SE) 7. With contributions from Java users around the world, Java 7 is an affirmation of the vibrancy of the Java community and of Oracle’s ongoing commitment to the […]

Oracle Databases

Introduction of Oracle Database: Oracle is one of the power databases in the world. In Oracle database there is collection of data treated as a small no. of units. The main aim of the oracle database is to store and retrieve related information with high rate. Oracle database servers have lot of information about solving […]

Oracle Certification Program Categories

Oracle Certified Associate: The Oracle Certified Associate (OCA) credential is typically the first step toward achieving the flagship Oracle Certified Professional certification. The OCA credential ensures that the individual is equipped with fundamental skills, providing a strong foundation for supporting Oracle products. An OCA credential is available for several of today’s most in-demand technology job […]

Data Warehouse

In Data Warehouse we can store data for analysis and security purpose. Data warehouse contain historical data that is coming from running systems data is also coming from different sources. In data warehouse we have lot of data and consolidate these data that is coming from different data sources analysis this data then get final […]

Oracle SQL/PLSQL Questions & Answers4

Oracle SQL/PLSQL Questions & Answers: Explain in detail use of OCI in oracle? OCI is an API that provides functions you can use to access the database server and control SQL execution. OCI supports the data types, calling conventions, syntax, and semantics of the C and C++ programming languages. You compile and link an OCI […]

Oracle SQL/PLSQL Questions & Answers3:

Oracle SQL/PLSQL Questions & Answers: Can we design one view on another view? Yes we can design one view on the other view.  What are aggregate functions in Oracle? Aggregate function are using in oracle with group by clause and with having clause. Avg, count, max, min, sum,   How can we sort out our […]

Oracle SQL/PLSQL Questions & Answers2:

Oracle SQL/PLSQL Questions & Answers: What are cursors and how many types of cursors? Cursor is a pointer variable in a memory and use for DML operations. Cursor basically is a private SQL memory area it is also use to improve the performance of the database. There are two types of cursors. 1- Implicit cursor […]

Oracle SQL/PLSQL Questions & Answers:

Oracle SQL/PLSQL Questions & Answers: What is SQL statement? SQL stands for Structured Query Language that is use for updating, deleting and inserting the  information from databases. SQL is an ANSI and ISO standard and is the de-facto standard database query language. Oracle database also support this language. What are database triggers and how many […]

Oracle Reports Builder Questions & Answers

What are the different types of reports? Tabular Master Detail Reports Form Reports Form Letter Reports Mailing Labels Reports Matrix Reports What are Anchors in reports builder? An anchor defines the actual position of an object. Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. What […]

Oracle Forms Builder Questions & Answers

Oracle Forms Builder Questions & Answers Oracle Forms Builder Questions & Answers are coming soon…..   Other Related Questions & Answers: Oracle General Question & Answers Oracle SQL/PLSQL Question & Answers Oracle Database Question & Answers Oracle Forms Builder Question & Answers Oracle Reports Builder & Answers

Oracle Database Questions & Answers

 What are the components of Physical database structure of Oracle Database? ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files. What are the components of Logical database structure of ORACLE database? Tablespaces and the Database’s Schema Objects. What […]

Oracle General Question & Answers:

Oracle General Question & Answers:   What is data? Data is a collection of raw, facts and figures that is use in different place we can store anything in database is called data. What is database? Collection of organized data which can easily managed access, understand, and update. What is database management system? Any programming […]

Database Management System

Database management system has some base on different pillars that are given below in detail. What is Data? Data is a collection of facts, such as values or measurements. It can be numbers, words, measurements, observations or even just descriptions of things. Data can exist in a variety of forms as numbers or text on […]