Interview Questions Answers in SQL PLSQL, Oracle Forms Reports

rahul khope

{ City } mumbai
< Country > india
* Profession * software engineer
User No # 3501

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 8
Users Marked my Answers as Wrong # 4

Questions / { rahul khope }

Questions Answers Category Views Company eMail

Answers / { rahul khope }

Question { Evosys, 16838 }

How to perform a loop through all tables in pl/sql?

Answer

We can use user_tables view of data dictionary.
create a cursor based on query
select * from user_tables and then use use this cursor
in for loop

Is This Answer Correct ?

3 Yes

4 No

Question { 8552 }

How to call Report from other Report ?

Answer

We can use the following code on the when_button_pressed
trgger of the button taken on the report layout.

SRW.RUN_REPORT

SRW.RUN_REPORT executes the specified R25RUN command.

Type: Procedure

Syntax:

SRW.RUN_REPORT (command_line CHAR);

Parameters:

command_line Is a valid R25RUN command.

Is This Answer Correct ?

5 Yes

0 No