What are the types of calculated columns available?

What are the types of calculated columns available?
by

1 Answer

Answer :

Summary, Formula, Placeholder column.
by

Related questions

How many types of columns are there and what are they

Description : How many types of columns are there and what are they

Last Answer : Formula columns :: For doing mathematical calculations and returning one value Summary Columns :: For doing summary calculations such as summations etc. Place holder Columns :: These columns are useful for storing the value in a variable

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

How do you use the same lov for 2 columns

Description : How do you use the same lov for 2 columns

Last Answer : We can use the same lov for 2 columns by passing the return values in global values and using the global values in the code

How many number of columns a record group can have?

Description : How many number of columns a record group can have?

Last Answer : A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

Can a formula column referred to columns in higher group?

Description : Can a formula column referred to columns in higher group?

Last Answer : Yes

How many columns can table have?

Description : How many columns can table have?

Last Answer : The number of columns in a table can range from 1 to 254.

What is pseudo columns ? Name them?

Description : What is pseudo columns ? Name them?

Last Answer : A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values. This section describes these pseudocolumns: * CURRVAL * NEXTVAL * LEVEL * ROWID * ROWNUM

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Can a primary key contain more than one columns?

Description : Can a primary key contain more than one columns?

Last Answer : Yes

If a break order is set on a column would it affect columns which are under the column?

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

On which columns you should create Indexes?

Description : On which columns you should create Indexes?

Last Answer : In general, you should create an index on a column in any of the following situations: ▪ The column is queried frequently ▪ A referential integrity constraint exists on the column ▪ A UNIQUE key ... ORDER BY clauses ▪ On columns that have few of the same values or unique values in the table

What are different types of modules available in oracle form?

Description : What are different types of modules available in oracle form?

Last Answer : Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

What are the three types of user exits available ?

Description : What are the three types of user exits available ?

Last Answer : Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

What are the two types of views available in the object navigator(specific to report 2.5)?

Description : What are the two types of views available in the object navigator(specific to report 2.5)?

Last Answer : View by structure and view by type .

What are the different plan types available in Fusion Absence Management? Accrual

Description : What are the different plan types available in Fusion Absence Management?

Last Answer : There are three different plan types available in Fusion Absence Management, which are given below: Accrual Use this type to create absence plans that enable workers to accrue time for the ... plan to pay workers if they are not eligible for a standard maternity absence qualification plan.

What are the datatypes a available in PL/SQL ?

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.

What strategies are available for backing-up an Oracle database? (for DBA

Description : What strategies are available for backing-up an Oracle database? (for DBA

Last Answer : The following methods are valid for backing-up an Oracle database: Export/Import - Exports are "logical" database backups in that they extract logical definitions and data from the database to a file. ... , etc. If your database is in ARCGIVELOG mode, you also need to backup archived log files.

What are two virtual tables available during database trigger execution ?

Description : What are two virtual tables available during database trigger execution ?

Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

What are the design facilities available in forms 4.0?

Description : What are the design facilities available in forms 4.0?

Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.

What is a predefined exception available in forms 4.0?

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

List system variables available in forms 4.0, and not available in forms 3.0?

Description : List system variables available in forms 4.0, and not available in forms 3.0?

Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working

List the windows event triggers available in Forms 4.0?

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

What are the options available to refresh snapshots ?

Description : What are the options available to refresh snapshots ?

Last Answer : COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced. FAST - If simple snapshot used then a snapshot log can be used to ... Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.

What are the different absence type patterns available in Fusion Absence Management?

Description : What are the different absence type patterns available in Fusion Absence Management?

Last Answer : An absence pattern contains a predefined set of rules that you can use as a starting point to create an absence type. The pattern that you select determines whether special fields ... patterns available in Fusion Absence Management. ∙Illness or injury ∙Childbirth or placement ∙Generic absence

What type of indexes are available in Oracle?

Description : What type of indexes are available in Oracle?

Last Answer : There are many index types within Oracle: B*Tree Indexes - common indexes in Oracle. They are similar construct to a binary tree; they provide fast access by key, to an individual row or range of ... They allow data to be sorted from big to small (descending) instead of small to big (ascending).

)The total amount of risk that is calculated for a project is found by 1. Multiplying the sum of each the risk times the amount at stake2. Calculating the cumulative sum of the probability for each risk and multiplying this value times the consequence of occurrence of the risk events 3. Cannot be calculated since all risks are not know 4. The amount of project reserves available

Description : )The total amount of risk that is calculated for a project is found by 1. Multiplying the sum of each the risk times the amount at stake 2. Calculating the cumulative sum of the probability for ... 3. Cannot be calculated since all risks are not know  4. The amount of project reserves available

Last Answer : 2. Calculating the cumulative sum of the probability for each risk and multiplying this value times the consequence of occurrence of the risk events

Utiliza Utilization is calculat tion is calculated as: a)Utilization = Actual hours*Scheduled available hours b)Utilization = Actual hours/ Scheduled available hours c)Utilization = Actual hours+Scheduled available hours d) None of the above

Description : Utiliza Utilization is calculat tion is calculated as: a)Utilization = Actual hours*Scheduled available hours b)Utilization = Actual hours/ Scheduled available hours c)Utilization = Actual hours+Scheduled available hours d) None of the above

Last Answer : b)Utilization = Actual hours/ Scheduled available hours

The power factor of a single phase load can be calculated if the instruments available are?

Last Answer : The power factor of a single phase load can be calculated if the instruments available are three ammeters or three voltmeters.

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How many types of Exceptions are there

Description : How many types of Exceptions are there

Last Answer : There are 2 types of exceptions. They are a) System Exceptions e.g. When no_data_found, When too_many_rows b) User Defined Exceptions e.g. My_exception exception When My_exception then

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

What are the different types of segments?

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

What are the types of database links?

Description : What are the types of database links?

Last Answer : Private database link, public database link & network database link.

What r the types of windows (Window style)?

Description : What r the types of windows (Window style)?

Last Answer : Specifies whether the window is a Document window or a Dialog window.

How many types of canvases are there.

Description : How many types of canvases are there.

Last Answer : There are 2 types of canvases called as Content and Stack Canvas. Content canvas is the default and the one that is used mostly for giving the base effect. Its like a plate on which we add items and stacked canvas is used for giving 3 dimensional effect.

What are the types of triggers and how the sequence of firing in text item

Description : What are the types of triggers and how the sequence of firing in text item

Last Answer : Triggers can be classified as Key Triggers, Mouse Triggers ,Navigational Triggers. Key Triggers :: Key Triggers are fired as a result of Key action.e.g :: Key-next-field, Key-up,Key-Down Mouse Triggers :: Mouse ... :: a) pre - text b) when new item c) key-next d) when validate e) post text

How many types of Sql Statements are there in Oracle

Description : How many types of Sql Statements are there in Oracle

Last Answer : There are basically 6 types of sql statments.They are a) Data Defination Language(DDL) :: The DDL statments define and maintain objects and drop objects. b) Data Manipulation Language(DML) :: The DML ... e.g:: Using the Sql Statements in languages such as 'C', Open,Fetch, execute and close

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What are the data types allowed in a table ?

Description : What are the data types allowed in a table ?

Last Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What is an Exception ? What are types of Exception ?

Description : What is an Exception ? What are types of Exception ?

Last Answer : Exception is the error handling part of PL/SQL block. The types are Predefined and user defined. Some of Predefined exceptions are. CURSOR_ALREADY_OPEN ... INVALID_CURSOR INVALID_NUMBER LOGON_DENIED NOT_LOGGED_ON PROGRAM-ERROR STORAGE_ERROR TIMEOUT_ON_RESOURCE VALUE_ERROR ZERO_DIVIDE OTHERS.

How many types of database triggers can be specified on a table ? What are they ?

Description : How many types of database triggers can be specified on a table ? What are they ?

Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.

Explain types of Block in forms4.0?

Description : Explain types of Block in forms4.0?

Last Answer : Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block that is not associated with a database table. ITEMS

What are the types of canvas-views?

Description : What are the types of canvas-views?

Last Answer : Content View, Stacked View.

Give the Types of modules in a form?

Description : Give the Types of modules in a form?

Last Answer : Form Menu Library

What are the different types of windows?

Description : What are the different types of windows?

Last Answer : Root window, secondary window.