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 { MBT, 15206 }

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 { 7697 }

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