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.
Explain the extended, standard and secured mode?
Specify various tools in the Business Objects 5.1?
Why there is a need to create the user object?
What types of tables derived from the ERD?
Define the class?
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
Explain about a Cartesian product?
Explain the Slice and Dice attribute in the Business Objects?
Explain Data Only Page Locking in Sybase.
Write down a short note on the term concurrency transparency?
18,76,764
1941985 Asked
3,689
Active Tutors
1451949
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!