oracle

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

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

How to make Data Base Trigger in Oracle?

What is Database Trigger Database triggers are designed and applied on tables to execute an event in the database. When we perfume a transaction on table then trigger execute and perfume the specific task. Database trigger are same like stored procedures but stored procedures are call explicitly on the other hand database triggers are call […]

How to make View in Oracle?

Table No.1 CREATE TABLE GRN_MASTER ( GRN_NUM       NUMBER, GRN_DATE      DATE, SUPPLIER_ID   NUMBER, GATE_PASSS_ID NUMBER, STORE_ID      NUMBER, APPROVED_ID   NUMBER, CONSTRAINTS PK_GRN_NUM PRIMARY KEY (GRN_NUM) ); Table No.2 CREATE TABLE GRN_DETAIL ( GRN_NUM       NUMBER, SR_NUM        NUMBER, ITEM_CODE     NUMBER, ITEM_UOM      NUMBER, ITEM_RATE     NUMBER, ITEM_VALUE    NUMBER, CONSTRAINT FK_GRN_NUM_DTL FOREIGN KEY (GRN_NUM) REFERENCES GRN_MASTER(GRN_NUM) ); View: -CREATE OR REPLACE VIEW […]

How to Rename Column Name in Oracle?

Code: ALTER TABLE GRN_MASTER RENAME COLUMN CHECKED_ID TO CHECKED_NAM;

How to Drop Column in Oracle?

Code: ALTER TABLE GRN_MASTER DROP COLUMN APPROVED_DATE;

How to add Column in Oracle?

What is table Column? A table column is a field of an entity that are using to store data, one table have multiple columns. Code: ALTER TABLE GRN_MASTER ADD   APPROVED_DATE DATE; ALTER TABLE GRN_MASTER ADD   (CHECKED_ID NUMBER, CHECKED_DATE DATE);  

How to add Foreign key in Oracle?

What is Foreign Key? Foreign key means value copy from one table to another table. If one table have primary key then we can use that table column in another table as a foreign key. The table that have primary key is called master table and the table that is using this column is called […]

How to add Primary Key in oracle?

What is Primary key? Primary key is on single field or on multiple fields that is using for uniqueness of the record. One table always has one primary key. Primary key at the stage of table creation: CREATE TABLE GRN_MASTER ( GRN_NUM       NUMBER, GRN_DATE      DATE, SUPPLIER_ID   NUMBER, GATE_PASSS_ID NUMBER, STORE_ID      NUMBER, APPROVED_ID   NUMBER, CONSTRAINTS PK_GRN_NUM […]

How to create Table in Oracle?

What is table? Table is a logical structure in database that is using for store the data in databases. We can create table in oracle by using this syntax. Code: CREATE TABLE GRN_MASTER ( GRN_NUM       NUMBER, GRN_DATE      DATE, SUPPLIER_ID   NUMBER, GATE_PASSS_ID NUMBER, STORE_ID      NUMBER, APPROVED_ID   NUMBER, CONSTRAINTS PK_GRN_NUM PRIMARY KEY (GRN_NUM) );