-
What is the difference between Property Pallete and Visual Attributes ?Also explain what is Object Group in Oracle Forms ?
santhisistla
- Jul 29th, 2010
Property pallete is used to apply changes to only that object item, as visual attributes are used in more generic manner. Visual attributes are used in the projects in which common specific...
kyuvarajbe
- Jun 11th, 2010
Visual Attribute is the property in Property Pallete of object which deals with only text font,colour.
-
Hi,what is place holder column?where we can use other than formula column?
sumanpani
- Sep 16th, 2008
A placeholder is a column for which you set the datatype and value in PL/SQL that you define. You can set the value of a placeholder column in the following places: n the Before Report Trig...
rampratap409
- Dec 6th, 2006
Place holder column is the name of variable which can hold a calculated value like ( sum, avg..) or the value can be set by function or by a pl/sql block.use of place holder column for aggrigate function is not advised, for that use summary column.
-
How can you call a form on a form
muniyuga
- Oct 24th, 2009
The communication between forms can be done in the following 3 wayslet say Form A calls FormB1.Using New_Form: this Terminates Form A and activates Form BThe NewForm will terminates your current activ...
sumanpani
- Sep 16th, 2008
By using Gobal Variable we can call  Form to Form Form to Report Form to Graph
-
What are User Exits ?
sumanpani
- Sep 16th, 2008
A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.
Devi Prasad Mishra
- Sep 30th, 2005
User Exits is a program which is used to pass the control from the Report Builder to a third generation language for performing complex calculations and returning the value back to the Report Builder.
-
What are the type of User Exits ?
ORACLE Precompliers user exitsOCI (ORACLE Call Interface)Non-ORACEL user exits. Page :
sumanpani
- Sep 16th, 2008
You can write the following types of user exits: ORACLE Precompiler user exits OCI (ORACLE Call Interface) user exits Non-ORACLE user exits User exits can perform the following tasks: ...
-
How you will avoid duplicating records in a query?
By using DISTINCT
kethinenisarath
- Apr 9th, 2011
Hi! I think its best option to avoid duplicating records in a queryselect * from empwhere sal in ( select sal from emp &nbs...
-
Can a primary key contain more than one columns ?
Suresh Babu Nallamothu
- Nov 8th, 2018
No,Because only one primary key is available for the one table. If you want to use morethan one primary key in a table,it is called as composite primary key.
CodeMark Haynes
- Sep 23rd, 2011
Yes, a primary key can contain more than one one column. Per EF Cobb's definition, a primary key is the sole candidate key on a relation variable (table) formed from one or more attribute values (c...
-
What is difference between UNIQUE and PRIMARY KEY constraints?
A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically defined to be mandatory must also specify the column is NOT NULL.
Read Best Answer
Editorial / Best Answer
Answered by: Vijay Raj Jaiswal
- Sep 20th, 2005
Hi this is modified answer ,pls post this instead of previous which i post
Primay Key Unique key
----------- ------------------
There is only one there may be more than 1
Primary key for Unique Key in table
1 tableIt can not contain It Can contain Null Value
Null valueLakshmanan
- Jun 30th, 2017
Primary key is combination of not null and unique. Primary key does not insert a null value and insert value is unique. Unique is one time accepted null value and insert a data is uniquely
ankitagujrati28
- Apr 30th, 2010
Unique key means we have to enter unique value but we can enter null.But in case of Primary key we should have to enter Unique + Not Null value in that particular column.
-
What is a view ?
A view is stored procedure based on one or more tables, it’s a virtual table.
Suresh Babu Nallamothu
- Nov 8th, 2018
A view is a virtual table,Because it doesn't have its own data and it doesn't occupy the database memory.
ankitagujrati28
- Apr 30th, 2010
A view is a mirror image of one or more table. View provides data access privilages.
-
What is difference between Rename and Alias?
Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.
-
What are different Oracle database objects?
TABLESVIEWSINDEXESSYNONYMSSEQUENCESTABLESPACES etc
suresh
- Mar 13th, 2015
Table,view,procedure,function,package,synonums,triggers,index,sequencess
