Way of passing of variables to a SQL routine
Define the way of passing of variables to a SQL routine.
Expert
Level: Low
By employ of the & symbol. For passing within variables the numbers 1 to 8 can be utilized (as &1, &2,...,&8) to pass the values after the exact command in the SQLPLUS session. So, to be prompted for an exact variable, place the ampersand variable within the code itself:
"choose * by dba_tables where owner=&owner_name;". Employ of twice ampersands informs SQLPLUS to reconstitute the value for every subsequent employ of the variable, a particular ampersand will cause a re-prompt for the value if not an ACCEPT statement is used to acquire the value by the user.
Specify the types of the tracing level?
Write down the Target Types on the Server?
Illustrate out some of the standard Business Intelligence tools in the market?
What are two types of implementation as a centrally located logical architecture? Answer: There two types of implementation are as follows: firstly gives a single ve
Explain Data Page Locking in Sybase.
Write down the differentiation between Power Center and Power Mart?
Describe briefly the term ODBC?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
explain binary relationship set and terenary relationship set
Illustrates the definition of Economics?
18,76,764
1924250 Asked
3,689
Active Tutors
1453993
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!