What is mean by stored procedure ? and how we can generate
stored procedure universe?

Answer Posted / gowthami

Store procedure is used to execute a set of sql queries.
It is used in the scenario where the query is used mulitple times.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What Is The Difference Between Oltp And Olap?

857


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1689


Explain about alerts in bos, under what situation we need to use alerts?

757


What is thumbnail?

733


Explain in detail about type 2(scd),

787


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4056


Explain how to execute the plsql procedure from the report by clicking with mouse?

804


in sap bi we have wad, then why we go for sap bo

3030


What is the difference between user and versatile user?

758


What is the difference between the public object&schema object?

756


Explain is there any default username & pwd for bo designer & supervisor?

779


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1245


Difference between zabo and webi?

842


Explain is data mart?

752


What is the difference between datawarehousing and businessintelligence?

837