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.
What is meant by the term business objects?
Write down a short note on Website security issues?
Explain the method removes the value by the top of a stack? Answer: The pop () member method eliminates the value from the top of a stack, that is then returned by t
Illustrate the use and application of the DB Miner.
Explain the designer objects?
Provide a brief introduction of the term ‘Data warehousing ’?
Specify the chief components of the Transaction-based Systems?
In Sybase does table Partitioning needs user-defined segments?
Describe some of the chrematistics of good data definitions.
Specify the data units at the different layers of TCP / IP protocol suite?
18,76,764
1927490 Asked
3,689
Active Tutors
1411948
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!