What column differentiates the V$ views to the GV$ views and how?

What column differentiates the V$ views to the GV$ views
and how?
by

1 Answer

Answer :

The INST_ID column which indicates the instance in a RAC environment
the information came from.
by

Related questions

What background process refreshes materialized views?

Description : What background process refreshes materialized views?

Last Answer : The Job Queue Processes.

Explain materialized views and how they are used.

Description : Explain materialized views and how they are used.

Last Answer : Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or decision support systems.

What are snap shots and views

Description : What are snap shots and views

Last Answer : Snapshots are mirror or replicas of tables. Views are built using the columns from one or more tables. The Single Table View can be updated but the view with multi table cannot be updated

What are the types of canvas-views?

Description : What are the types of canvas-views?

Last Answer : Content View, Stacked View.

List the built-in routines for the controlling canvas views during run-time?

Description : List the built-in routines for the controlling canvas views during run-time?

Last Answer : Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

What is relation between the window and canvas views?

Description : What is relation between the window and canvas views?

Last Answer : Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

Explain about stacked canvas views?

Description : Explain about stacked canvas views?

Last Answer : Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

Explain about horizontal, Vertical tool bar canvas views?

Description : Explain about horizontal, Vertical tool bar canvas views?

Last Answer : Tool bar canvas views are used to create tool bars for individual windows. Horizontal tool bars are display at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window

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 .

Which of the two views should objects according to possession?

Description : Which of the two views should objects according to possession?

Last Answer : view by structure.

How does one get the view definition of fixed views/tables?

Description : How does one get the view definition of fixed views/tables?

Last Answer : Query v$fixed_view_definition. Example: SELECT * FROM v$fixed_view_definition WHERE view_name='V$SESSION';

What are the advantages of views?

Description : What are the advantages of views?

Last Answer : Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. - Hide data complexity. - Simplify commands for the user. - Present the data in a different perspective from that of the base table. - Store complex queries.

What is the difference between normal views and RAC views?

Description : What is the difference between normal views and RAC views?

Last Answer : RAC views has the prefix ‘G’. For example, GV$SESSION instead of V$SESSION

Use the add_group_column function to add a column to record group that was created at a design time?

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

Can a formula column be obtained through a select statement?

Description : Can a formula column be obtained through a select statement?

Last Answer : Yes

Can a formula column referred to columns in higher group?

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

Last Answer : Yes

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Last Answer : It won't, Because SYSDATE format contains time attached with it.

There is a % sign in one field of a column. What will be the query to find it?

Description : There is a % sign in one field of a column. What will be the query to find it?

Last Answer : '' Should be used before '%'.

Write the order of precedence for validation of a column in a table ?

Description : Write the order of precedence for validation of a column in a table ?

Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?

What is the use of hidden column? What are the various sub events a mouse double click event involves?

Description : What is the use of hidden column? What are the various sub events a mouse double click event involves?

Last Answer : A hidden column is used to when a column has to embed into boilerplate text.

What is the use of place holder column? What are the various sub events a mouse double click event involves?

Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?

Last Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

To execute row from being displayed that still use column in the row which property can be used?

Description : To execute row from being displayed that still use column in the row which property can be used?

Last Answer : Format trigger.

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

What is the Maximum allowed length of Record group Column?

Description : What is the Maximum allowed length of Record group Column?

Last Answer : Record group column names cannot exceed 30 characters.

What is the purpose of the product order option in the column property sheet?

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

A Column is having many repeated values which type of index you should create on this column, if you have to?

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Last Answer : The table has a BLOB column.

What differentiates a ferrous mineral from a non-ferrous mineral? -Geography

Description : What differentiates a ferrous mineral from a non-ferrous mineral? -Geography

Last Answer : The term ferrous' means containing or consisting of iron. Ferrous minerals are those minerals that contain iron while non-ferrous minerals are those that do not contain iron. In the following table, ... Include iron-ore, manganese etc. Examples include copper, bauxite, lead , zinc, gold etc.

Which differentiates a sperm from egg

Description : Which differentiates a sperm from egg

Last Answer : Which differentiates a sperm from egg A. Cytoplasm is more abundant in sperm than in egg B. Accessory ... form a sheath in egg and diffused in sperm.

What central principle of Islam that differentiates it from Judaism and Christianity is its belief in the most important Islamic guidelines for Muslims?

Description : What central principle of Islam that differentiates it from Judaism and Christianity is its belief in the most important Islamic guidelines for Muslims?

Last Answer : the five pillarsAPEX

What differentiates western art criticism from others traditions of critique?

Description : What differentiates western art criticism from others traditions of critique?

Last Answer : Western art criticism focuses on theory and philosophy.

Which factor differentiates between weather and climate?

Description : Which factor differentiates between weather and climate?

Last Answer : Answer this question… The length of time over which conditions are measured

What differentiates blood types from all other blood types?

Description : What differentiates blood types from all other blood types?

Last Answer : The difference in blood type comes from the antigen or the marker present on the red blood cell. They are different from each other based on the different shape and size of the marker on the blood cells.

What is the typical morphological feature of nematodes that differentiates them from platyhelminthes?

Description : What is the typical morphological feature of nematodes that differentiates them from platyhelminthes?

Last Answer : Nematodes are also known as roundworms. As the name indicates they are not flat like platyhelminthes. In evolutionary grounds with the nematodes the first complete digestive system appears, with mouth and anus, and the pseudocoelom is also a novelty.

What is the main external morphological feature that differentiates platyhelminthes from other worms (nematodes)?

Description : What is the main external morphological feature that differentiates platyhelminthes from other worms (nematodes)?

Last Answer : Platyhelminthes are also known as flatworms because they are worms with a flat body. This is the main external morphological feature that differentiates them from nematodes (roundworms).

The strategy of identifying an attractive market segment and serving it in a way that differentiates the retailer from others in consumers' minds is termed : 1. product positioning 2. niche retailing 3. retail positioning 4. merchandise policy 5. none of these

Description : The strategy of identifying an attractive market segment and serving it in a way that differentiates the retailer from others in consumers' minds is termed : 1. product positioning 2. niche retailing 3. retail positioning 4. merchandise policy 5. none of these

Last Answer : retail positioning

Which of the following is one of the properties that differentiates cloud computing? a) scalability b) virtualization c) composability d) all of the mentioned

Description : Which of the following is one of the properties that differentiates cloud computing? a) scalability b) virtualization c) composability d) all of the mentioned

Last Answer : composability

The strategy of identifying an attractive market segment and serving it in a way that differentiates the retailer from others in consumers' minds is termed: A)product positioning B)niche retailing C)retail positioning D)merchandise policy

Description : The strategy of identifying an attractive market segment and serving it in a way that differentiates the retailer from others in consumers' minds is termed: A)product positioning B)niche retailing C)retail positioning D)merchandise policy

Last Answer : C)retail positioning

Which of the following differentiates between overloaded functions and overridden functions ? (A) Overloading is a dynamic or runtime binding and overridden is a static or compile time binding. (B) Overloading is a static or compile time binding and overriding is dynamic or runtime binding. (C) Redefining a function in a friend class is called overloading, while redefining a function in a derived class is called as overridden function. (D) Redefining a function in a derived class is called function overloading, while redefining a function in a friend class is called function overriding.

Description : Which of the following differentiates between overloaded functions and overridden functions ? (A) Overloading is a dynamic or runtime binding and overridden is a static or compile time binding. ... function overloading, while redefining a function in a friend class is called function overriding.

Last Answer : (B) Overloading is a static or compile time binding and overriding is dynamic or runtime binding.

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

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

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.