How is link tool operation different bet. reports 2 & 2.5?

1 Answer

Answer :

In Reports 2.0 the link tool has to be selected and then two fields to be
linked are selected and the link is automatically created. In 2.5 the first
field is selected and the link tool is then used to link the first field to
the second field.

Related questions

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.

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

Last Answer : No

Description : What is the lock option in reports layout

Last Answer : By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields .

Description : How can I message to passed to the user from reports?

Last Answer : By using SRW.MESSAGE function. (Continued on next part...)

Description : Is forms 4.5 object oriented tool ? why?

Last Answer : yes , partially. 1) PROPERTY CLASS - inheritance property 2) OVERLOADING : procedures and functions.

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

Description : What is STATSPACK tool?

Last Answer : STATSPACK is a performance diagnosis tool provided by Oracle starting from Oracle 8i and above. STATSPACK is a diagnosis tool for instance-wide performance problems; it also supports application tuning ... . More information about STATSPACK, can be found in file $ORACLE_HOME/rdbms/admin/spdoc.txt.

Description : What Oracle tool will you use to transform datafiles into text files?

Last Answer : Trick question: you can’t do that, at least with any Oracle tool. A very experienced DBA should perfectly know this.

Description : Which of the following is the task of a Test Lead / Leader: i. Interaction with the Test Tool Vendor to identify best ways to leverage test tool on the project. ii. Write Test Summary Reports based on the ... is true and ii,iii,iv are false d) iii and iv is correct and i and ii are incorrect

Last Answer : a) i, ii, iii is true and iv is false

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Description : What is network database link?

Last Answer : Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.

Description : What is public database link?

Last Answer : Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.

Description : What is private database link?

Last Answer : Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

Description : What is Database Link ?

Last Answer : A database link is a named object that describes a "path" from one database to another.

Description : What is a database link ?

Last Answer : Database Link is a named path through which a remote database can be accessed.

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

Description : What are the sql clauses supported in the link property sheet?

Last Answer : Where start with having.

Description : Are the resulting relations of PRODUCT and JOIN operation the same?

Last Answer : No. PRODUCT: Concatenation of every row in one relation with every row in another. JOIN: Concatenation of rows from one relation and related rows from another

Description : When was the most recent occasion you struck a bet & how often do you gamble in this way?

Last Answer : I usually don’t bet for cash….just cruel and unusual punishments.Ask Vunessuh.XD

Description : Have you placed a bet on tonight's superbowl & do you stand to win big?

Last Answer : No bet, but if I did I would pick the Saints (with my heart) and the Colts (with my head).

Description : Brunauer, Emmet and Teller (BET) equation is used to determine the specific surface area of a porous particle but not the pore volume & the porosity of the catalyst bed. Which of the following postulates ... (except the first one) is involved in each of the evaporation process (D) None of these

Last Answer : (B) There is no dynamic equilibrium between successive layer

Description : The tool of an NC machine has to move along a circular arc from (5, 5) to (10, 10) while performing an operation. The centre of the arc is at (10, 5). Which one of the following NC tool path command performs the ... b.N010 GO3 X10 Y10 X5 Y5 R5 c.N010 GO1 X5 Y5 X10 Y10 R5 d.N010 GO2 X5 Y5 X10 Y10 R5

Last Answer : a.N010 GO2 X10 Y10 X5 Y5 R5

Description : n an NC machining operation, the tool has to be moved from point (5, 4) to point (7, 2) alonga circular path with centre at (5, 2). Before starting the operation, the tool is at (5, 4). The G and N codes for this motion ... 0 I5.0 J2.0 c.N010 GO1 X7.0 Y2.0 I5.0 J2.0 d.N010 GOO X7.0 Y2.0 I5.0 J2.0

Last Answer : b.N010 GO2 X7.0 Y2.0 I5.0 J2.0

Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.

Description : What is difference between TRUNCATE & DELETE ?

Last Answer : TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

Description : Difference between an implicit & an explicit cursor.?

Last Answer : only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor FOR loop. Explicit cursor is a cursor in which the cursor name is explicitly ... statements An implicit cursor is used to process INSERT, UPDATE, DELETE and single row SELECT. .INTO

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

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.

Description : What is the frame & repeating frame?

Last Answer : A frame is a holder for a group of fields. A repeating frame is used to display a set of records when the no. of records that are to displayed is not known before.

Description : What is a physical page ? & What is a logical page ?

Last Answer : A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.

Description : What is the difference between OLE Server & Ole Container?

Last Answer : An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate ... are created by ole server applications. Ex. oracle forms is an example of an ole Container.

Description : What is the difference between object embedding & linking in Oracle forms?

Last Answer : In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.

Description : What are the difference between lov & list item?

Last Answer : Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.

Description : Spurious tuples may occur due to i. Bad normalization ii. Theta joins iii. Updating tables from join a) i& ii b) ii & iii c) i& iii d) ii & iii

Last Answer : a) i& ii b) ii & iii

Description : Choose proper machine tool and explain operation method for the following: (i) Producing a hole (ii) Finishing previously drilled hole

Last Answer : MACHINE TOOL : Drilling Machine (i) Producing a hole: Drilling operation (Fig 1 mark ,explanation 2 mark) : It is an operation of producing a circular hole in a work piece by forcing a drill against ... is held in the tailstock and it is fed into the hole in the similar way as for drilling.  

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

Description : What are the different types of segments?

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

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

Description : What are the Different Optimisation Techniques

Last Answer : The Various Optimisation techniques are a) Execute Plan :: we can see the plan of the query and change it accordingly based on the indexes b) Optimizer_hint :: set_item_property('DeptBlock', ... SQL statements reuse the cursor. f45run module = my_firstform userid = scott/tiger optimize_Tp = No

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

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)

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.

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

Description : What are different Oracle database objects?

Last Answer : TABLES -VIEWS INDEXES -SYNONYMS -SEQUENCES -TABLESPACES etc

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

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.