Can a formula column be obtained through a select statement?

Can a formula column be obtained through a select
statement?
by

1 Answer

Answer :

Yes
by

Related questions

Can a formula column referred to columns in higher group?

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

Last Answer : Yes

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.

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 do u implement the If statement in the Select Statement

Description : How do u implement the If statement in the Select Statement

Last Answer : We can implement the if statement in the select statement by using the Decode statement. e.g select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .

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

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

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

Last Answer : The INST_ID column which indicates the instance in a RAC environment the information came from.

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.

Can you use select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

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

maxvalue.sql Select the Nth Highest value from a table?

Description : maxvalue.sql Select the Nth Highest value from a table?

Last Answer : select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') > 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , max(sal) from emp -- where level=2 -- connect by prior sal > sal -- group by level

minvalue.sql Select the Nth lowest value from a table?

Description : minvalue.sql Select the Nth lowest value from a table?

Last Answer : select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') < 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level

What a SELECT FOR UPDATE cursor represent.?

Description : What a SELECT FOR UPDATE cursor represent.?

Last Answer : SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT] The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of ... the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.

How is it possible to select generate a select set for the query in the query property sheet?

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

What is a difference between pre-select and pre-query?

Description : What is a difference between pre-select and pre-query?

Last Answer : Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires ... the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

Can you audit SELECT statements?

Description : Can you audit SELECT statements?

Last Answer : YES. But beware; you will need a storage mechanism to hold your SQL SELECT audits, a high data volume that can exceed the size of your whole database, every day. SQL SELECT auditing can be ... data in the audit trail must also be audited to see who has selected data from the audit trail.

Will a user be able to modify a table with SELECT only privilege?

Description : Will a user be able to modify a table with SELECT only privilege?

Last Answer : He won’t be able to UPDATE/INSERT into that table, but for some reason, he will still be able to lock a certain table.

Pick up the correct statement from the following (A) The ratio of the up flux and down flux just above the snow surface, is called albedo (B) Spectral albedo of snow is calculated for the semi-infinite snow thickness (C) Water equivalent height of snow is the height of water column obtained by melting snow (D) All of these

Description : Pick up the correct statement from the following (A) The ratio of the up flux and down flux just above the snow surface, is called albedo (B) Spectral albedo of snow is calculated for the semi- ... equivalent height of snow is the height of water column obtained by melting snow (D) All of these

Last Answer : Answer: Option D

Select the correct statement with respect to locomotion in humans. (a) The vertebral column has 10 thoracic vertebrae. (b) The joint between adjacent vertebrae is a fibrous joint. (c) A decreased level of progesterone causes osteoporosis in old people. (d) Accumulation of uric acid crystals in joints causes their inflammation

Description : Select the correct statement with respect to locomotion in humans. (a) The vertebral column has 10 thoracic vertebrae. (b) The joint between adjacent vertebrae is a fibrous joint. (c) A ... osteoporosis in old people. (d) Accumulation of uric acid crystals in joints causes their inflammation

Last Answer : (d) Accumulation of uric acid crystals in joints causes their inflammation.

Select the incorrect statement from the following [ A ] Reinforcing bars in a column should not be less than 12 mm in diameter [ B ] The number of longitudinal bars in a circular column should not exceed four [ C ] The minimum percentage of longitudinal steel in columns should be 0.8% [ D ] None of the above

Description : Select the incorrect statement from the following [ A ] Reinforcing bars in a column should not be less than 12 mm in diameter [ B ] The number of longitudinal bars in a circular column should not ... The minimum percentage of longitudinal steel in columns should be 0.8% [ D ] None of the above

Last Answer : [ B ] The number of longitudinal bars in a circular column should not exceed four

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is: (A) Select *from customers where city=’%GAR%’; (B) Select *from customers where city=’$GAR$’; (C) Select *from customers where city like ‘%GAR%’; (D) Select *from customers where city as ’%GAR’;

Description : Consider a CUSTOMERS database table having a column CITY filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have GAR somewhere in its name, ... *from customers where city like %GAR%'; (D) Select *from customers where city as '%GAR';

Last Answer : Answer: C

The operation of resection involves the following steps 1. Rough orientation of the plane table 2. The three lines form a triangle of error 3. Drawing lines back through the three control points 4. Select a point in the triangle of error such that each ray is equally rotated either clockwise or anti clockwise 5. The points obtained by three rays are the correct location. The correct sequence is (A) 1, 3, 2, 4, 5 (B) 1, 2, 3, 4, 5 (C) 1, 4, 3, 2, 5 (D) 1, 3, 2, 4, 5

Description : The operation of resection involves the following steps 1. Rough orientation of the plane table 2. The three lines form a triangle of error 3. Drawing lines back through the three control points 4. Select a point in the triangle of error ... 2, 3, 4, 5 (C) 1, 4, 3, 2, 5 (D) 1, 3, 2, 4, 5

Last Answer : (A) 1, 3, 2, 4, 5

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.

Can you use a commit statement within a database trigger?

Description : Can you use a commit statement within a database trigger?

Last Answer : No

What will happen after commit statement ?

Description : What will happen after commit statement ?

Last Answer : Cursor C1 is Select empno, ename from emp; Begin open C1; loop Fetch C1 into eno.ename; Exit When C1 %notfound;----- commit; end loop; end; The cursor having query as SELECT .... FOR ... after COMMIT/ROLLBACK. The cursor having query as SELECT.... does not get closed even after COMMIT/ROLLBACK.

What is Statement Auditing ?

Description : What is Statement Auditing ?

Last Answer : Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.

Can you see Execution Plan of a statement?

Description : Can you see Execution Plan of a statement?

Last Answer : YES. In many ways, for example from GUI based tools like TOAD, Oracle SQL Developer. Configuring AUTOTRACE, a SQL*Plus facility AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the ... - Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any.

What are the system resources that can be controlled through Profile ?

Description : What are the system resources that can be controlled through Profile ?

Last Answer : The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the ... idle time for the user's session the allowed amount of connect time for the user's session.

What command will you use to navigate through ASM files?

Description : What command will you use to navigate through ASM files?

Last Answer : asmcmd

An optimal solution of an assignment problem can be obtained only if a. Each row & column has only one zero element b. Each row & columns has at least one zero element c. The data is arrangement in a square matrix d. None of the above

Description : An optimal solution of an assignment problem can be obtained only if a. Each row & column has only one zero element b. Each row & columns has at least one zero element c. The data is arrangement in a square matrix d. None of the above

Last Answer : d. None of the above

Rankine Gordon formula for buckling is valid for (A) Long column (B) Short column (C) Short and long column (D) Very long column

Description : Rankine Gordon formula for buckling is valid for (A) Long column (B) Short column (C) Short and long column (D) Very long column

Last Answer : (C) Short and long column

Euler's formula states that the buckling load for a column of length , both ends hinged and whose least moment of inertia and modulus of elasticity of the material of the column are and respectively, is given by the relation (A) P = ²EI/l² (B) P = /EI (C) P = /l² (D) P = ²EI/l

Description : Euler's formula states that the buckling load for a column of length , both ends hinged and whose least moment of inertia and modulus of elasticity of the material of the column are and respectively, is given by the relation (A) P = ²EI/l² (B) P = /EI (C) P = /l² (D) P = ²EI/l

Last Answer : (A) P = ²EI/l²

A vertical column of water will be supported to what height by standard atmospheric pressure. If the Y w = 62.4lb/ft3 po = 14.7 psi.  a. 44.9 ft  b. 33.9 ft  c. 22.9 ft  d. 55.9 ft formula: ho= po/Yw

Description : A vertical column of water will be supported to what height by standard atmospheric pressure. If the Y w = 62.4lb/ft3 po = 14.7 psi.  a. 44.9 ft  b. 33.9 ft  c. 22.9 ft  d. 55.9 ft formula: ho= po/Yw

Last Answer : 33.9 ft

A 30-m vertical column of fluid (density 1878 kg/m3 ) is located where g= 9.65 mps2 . Find the pressure at the base of the column. (Formula: pg= gρhg/k )  a. 543680 N/m2  b. 543.68 kPa (gauge)  c. Both a & b  d. None of the above

Description : A 30-m vertical column of fluid (density 1878 kg/m3 ) is located where g= 9.65 mps2 . Find the pressure at the base of the column. (Formula: pg= gρhg/k )  a. 543680 N/m2  b. 543.68 kPa (gauge)  c. Both a & b  d. None of the above

Last Answer : Both a & b

Euler’s formula is not valid for mild steel column when slenderness ratio is (a) More than 100 (b) Less than 100 (c) Less than 80 (d)More than 80

Description : Euler’s formula is not valid for mild steel column when slenderness ratio is (a) More than 100 (b) Less than 100 (c) Less than 80 (d)More than 80

Last Answer : (c) Less than 80

The Rankine formula holds good for (a) Short column (b) Long column (c) Medium column (d) Both short and long column

Description : The Rankine formula holds good for (a) Short column (b) Long column (c) Medium column (d) Both short and long column

Last Answer : (d) Both short and long column

A gaseous organic compound that is best known for its use in preservative solutions has the chemical formula HCHO (read: H - C - H CHEM-92; Short Answer: Give me the name and atomic number of the element I am thinking about. It occupies the same column in the periodic table as selenium. Under standard conditions of temperature and pressure this element is a clear, odorless gas. This element is one of the essential ingredients in the burning process.

Description : A gaseous organic compound that is best known for its use in preservative solutions has the chemical formula HCHO (read: H - C - H CHEM-92; Short Answer: Give me the name and atomic number ... element is a clear, odorless gas. This element is one of the essential ingredients in the burning process.

Last Answer : ANSWER: OXYGEN ATOMIC NUMBER = 8

Match Column-I with Column-II for housefly classification and select the correct option using the codes given below : new question

Description : Match Column-I with Column-II for housefly classification and select the correct option using the codes given below : new question

Last Answer : Match Column-I with Column-II for housefly classification and select the correct option using the codes given below : new ... ,b,c,d),(iii,ii,iv,i):}`