Is it possible to modify an external query in a report which contains it?

Is it possible to modify an external query in a report which contains it?
by

1 Answer

Answer :

No.
by

Related questions

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

Where is the external query executed at the client or the server?

Description : Where is the external query executed at the client or the server?

Last Answer : At the server.

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.

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.

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.

What is a Query Record Group?

Description : What is a Query Record Group?

Last Answer : A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns ... rows retrieved by the query associated with that record group. What is a Non Query Record Group?

What is the Difference between a post query and a pre query

Description : What is the Difference between a post query and a pre query

Last Answer : A post query will fire for every row that is fetched but the pre query will fire only once.

How you will avoid your query from using indexes?

Description : How you will avoid your query from using indexes?

Last Answer : SELECT * FROM emp Where emp_no+' '=12345; i.e you have to concatenate the column name with space within codes in the where condition. SELECT /*+ FULL(a) */ ename, emp_no from emp where emp_no=1234; i.e using HINTS

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

What is correlated sub-query ?

Description : What is correlated sub-query ?

Last Answer : Correlated sub query is a sub query which has reference to the main query.

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 '%'.

How you will avoid duplicating records in a query?

Description : How you will avoid duplicating records in a query?

Last Answer : By using DISTINCT

My query was fine last week and now it is slow. Why? (for DBA

Description : My query was fine last week and now it is slow. Why? (for DBA

Last Answer : The likely cause of this is because the execution plan has changed. Generate a current explain plan of the offending query and compare it to a previous one that was taken when the query was ... the plan should be? Run the query with hints to see if this produces the required performance.

A query fetched 10 records How many times does a PRE- QUERY Trigger and POST-QUERY Trigger will get executed ?

Description : A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

Last Answer : PRE-QUERY fires once. POST-QUERY fires 10 times.

When is PRE-QUERY trigger executed ?

Description : When is PRE-QUERY trigger executed ?

Last Answer : When Execute-query or count-query Package procedures are invoked.

Why query fails sometimes ?

Description : Why query fails sometimes ?

Last Answer : Rollback segment dynamically extent to handle larger transactions entry loads. A single transaction may wipeout all available free space in the Rollback Segment Tablespace. This prevents other user using Rollback segments.

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.

What is a query?

Description : What is a query?

Last Answer : A query with respect to DBMS relates to user commands that are used to interact with a data base. The query language can be classified into data definition language and data manipulation language.

What is meant by query optimization?

Description : What is meant by query optimization?

Last Answer : The phase that identifies an efficient execution plan for evaluating a query that has the least estimated cost is referred to as query optimization.

What is Query evaluation engine?

Description : What is Query evaluation engine?

Last Answer : It executes low-level instruction generated by compiler.

s it possible to disable the parameter from while running the report?

Description : s it possible to disable the parameter from while running the report?

Last Answer : Yes

f four hosts on anetworkbelong tothesame group, a totalof _______ sent inresponse to a general query message. A) one membership report is B) two membership reports are C) three membership reports are D) noneof the above

Description : f four hosts on anetworkbelong tothesame group, a totalof _______ sent inresponse to a general query message. A) one membership report is B) two membership reports are C) three membership reports are D) noneof the above

Last Answer : two membership reports are

The _______ is used by a router in response to a received leave report. A) general query message B) special query message C) membershipreport D) noneof the above

Description : The _______ is used by a router in response to a received leave report. A) general query message B) special query message C) membershipreport D) noneof the above

Last Answer : special query message

How many minimum groups are required for a matrix report

Description : How many minimum groups are required for a matrix report

Last Answer : The minimum number of groups in matrix report are 4

Can a field be used in a report without it appearing in any data group?

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

What are the minimum number of groups required for a matrix report

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

Can u run the report with out a parameter form

Description : Can u run the report with out a parameter form

Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null

Can u have more than one layout in report

Description : Can u have more than one layout in report

Last Answer : It is possible to have more than one layout in a report by using the additional layout option in the layout editor.

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

What are the various methods of performing a calculation in a report ?

Description : What are the various methods of performing a calculation in a report ?

Last Answer : 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model.

At what point of report execution is the before Report trigger fired?

Description : At what point of report execution is the before Report trigger fired?

Last Answer : After the query is executed but before the report is executed and the records are displayed.

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

How can a button be used in a report to give a drill down facility?

Description : How can a button be used in a report to give a drill down facility?

Last Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

How can a text file be attached to a report while creating in the report writer?

Description : How can a text file be attached to a report while creating in the report writer?

Last Answer : By using the link file property in the layout boiler plate property sheet.

How can a square be drawn in the layout editor of the report writer?

Description : How can a square be drawn in the layout editor of the Report writer?

Last Answer : By using the rectangle tool while pressing the (Constraint) key.

What are the ways to monitor the performance of the report?

Description : What are the ways to monitor the performance of the report?

Last Answer : Use reports profile executable statement. Use SQL trace facility.

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 .

Is the After report trigger fired if the report execution fails?

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

What does a control file contains?

Description : What does a control file contains?

Last Answer : Database name - Names and locations of a database's files and redolog files. - Time stamp of database creation.

Is it possible to modify the weather?

Description : Is it possible to modify the weather?

Last Answer : Itâ⠬⠢s hard to say. While we canâ⠬⠢t change daily temperatures, thereâ⠬⠢s some evidence that we can modify precipitation with a method called cloud seeding. The United States uses ... temperatures, theyâ⠬⠢ll melt into raindrops.Further, we seed fog with dry ice to increase visib

Is it possible to modify the weather?

Description : Is it possible to modify the weather?

Last Answer : Itâ⠬⠢s hard to say. While we canâ⠬⠢t change daily temperatures, thereâ⠬⠢s some evidence that we can modify precipitation with a method called cloud seeding. The United States uses ... temperatures, theyâ⠬⠢ll melt into raindrops.Further, we seed fog with dry ice to increase visib

In flight, it is possible to: i. File an IFR flight plan ii. Modify an active flight plan iii. Cancel a VFR flight plan iv. Close a VFR flight plan (rules of the air ann2 3.3.5) a. i and ii b. i, ii, iii and iv c. ii, iii and iv d. i and iv

Description : In flight, it is possible to: i. File an IFR flight plan ii. Modify an active flight plan iii. Cancel a VFR flight plan iv. Close a VFR flight plan (rules of the air ann2 3.3.5) a. i and ii b. i, ii, iii and iv c. ii, iii and iv d. i and iv

Last Answer : b. i, ii, iii and iv

In flight, it is possible to: i. File an IFR flight plan ii. Modify an active flight plan iii. Cancel a VFR flight plan iv. Close a VFR flight plan (rules of the air ann2 3.3.5) a. i and ii b. i, ii, iii and iv c. ii, iii and iv d. i and iv

Description : In flight, it is possible to: i. File an IFR flight plan ii. Modify an active flight plan iii. Cancel a VFR flight plan iv. Close a VFR flight plan (rules of the air ann2 3.3.5) a. i and ii b. i, ii, iii and iv c. ii, iii and iv d. i and iv

Last Answer : b. i, ii, iii and iv

Transparency A . The large set of candidate solutions possible for a problem B. The information stored in a database that can be retrieved with a single query C. Worth of the output of a machine learning program that makes it understandable for humans D . None of these

Description : Transparency A . The large set of candidate solutions possible for a problem B. The information stored in a database that can be retrieved with a single query C. Worth of the output of a machine learning program that makes it understandable for humans D . None of these

Last Answer : C. Worth of the output of a machine learning program that makes it understandable for humans

Shallow knowledge A . The large set of candidate solutions possible for a problem B. The information stored in a database that can be, retrieved with a single query C. Worth of the output of a machine learning program that makes it understandable for humans D . None of these

Description : Shallow knowledge A . The large set of candidate solutions possible for a problem B. The information stored in a database that can be, retrieved with a single query C. Worth of the output of a machine learning program that makes it understandable for humans D . None of these

Last Answer : B. The information stored in a database that can be, retrieved with a single query

Search space A . The large set of candidate solutions possible for a problem B. The information stored in a database that can be, retrieved with a single query. C. Worth of the output of a machine learning program that makes it understandable for humans D . None of these

Description : Search space A . The large set of candidate solutions possible for a problem B. The information stored in a database that can be, retrieved with a single query. C. Worth of the output of a machine learning program that makes it understandable for humans D . None of these

Last Answer : A . The large set of candidate solutions possible for a problem

Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height>180); If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Description : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Last Answer : (C) 10

s it possible to set a filter condition in a cross product group in matrix reports?

Description : s it possible to set a filter condition in a cross product group in matrix reports?

Last Answer : No

Is it possible to insert comments into sql statements return in the data model editor?

Description : Is it possible to insert comments into sql statements return in the data model editor?

Last Answer : Yes