1) why we need to do Validations when the Standard Conc.
Prog or the API will do all the validations
2) How can we display more then 1 column data in a formula
column (Ex displaying Empno, Ename, sal data in one Formula
column)
3) is it possible to give 2 out paramaters in a function
Answers were Sorted based on User's Feedback
Answer / amarnath reddy govind
1) For Business validations or we need to validate data
before inserting data in to interface tables.
2) We can display more than one column data in formula by
taking one placeholder column. By using the formula column
always returns value right, so based on the formula column
we can display the data for placeholder column.
3)
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / emmanuel
1) Std. C/P will not take care the Business and custom
Validations. So, we need do validations before inserting in
to Interface table.
2) As formula column is function. we can display only one
string. with concatenate we can display more that one
column data. But this will treat it as string.
3) Yes, with one return value, we can give OUT parameters
also
| Is This Answer Correct ? | 5 Yes | 1 No |
What is Place holder Columns?
q)what are the validations in sql*loader
How to attach the multiple templates in XML Pub Report?
Tell me how to debug the report?
How do u customize the Reports?
what is po approval hierarchy?
List the various types of value set.
whats the use of after parameter form and before report?
what is meant by Drill Down in Discoverer report? why it will be use?
List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
what is the defference between credit memo and debit memo