difference between stored procedure and function?
Answer Posted / arkchowdary
PL/SQL------------- It is a named PL/SQL Block.
------------- Which can take 1 or more values.
------------- It accepts Parameters.
Usage-------------- Reusability.
-------------- Precompatibility.
Whereas
Functions----------- It is a named PL/SQL Block.
----------- Which can take 1 or more values.
----------- It must a Returns value by using
return statement.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What do you mean by Drill down and Drill Up?
What is called materialized view?
How do we convert from Numeric to be Words?
Define dimensions?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
what is the difference between list report and crosstab report?
what are the features in cognos8ui
What is the complex report you faced in real time?
what is the difference between filter and condition?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
-----------Diff b/w OLAP and RDBMS?
How to apply securities for reports in cognos connection?
can we insert all types of charts in a list report? what r the realtime prompts?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com