how to use sql variable in oracle || oracle sql tutorial 13
in this video i will show you how to use variable in oracle sql plus for more detail join our facebook group , / 242999206136244
The basics: & and &&
Just about everyone has defined a variable in SQL*Plus using &. The basics:
& and && indicate substitution variables in SQL*Plus scripts or commands.
&variablename is used to refer to the variable variablename in SQL*Plus, much the same way $variablename is used in shell scripts. If variablename is undefined, then SQL*Plus prompts the user for a value.
Everything from the & to the following space is considered the variable name. For example, in select &foo from dual;, &foo refers to the variable foo.
If you run the LIST_INDEXES script again, you won’t be prompted for a table name at all. Instead, the value entered earlier will be reused, and you will again see information about the project_hours table and its indexes. The reason for this is that once you define a variable, that definition sticks around until you either exit SQL*Plus or explicitly undefine the variable.
.----------------------------------------------------------------------------------------------------------.
video courses- list of playlist :
tips and trics
link► • tips and tricks
command prompt commands:
link► • command prompt commands
oracle sql:
link► • oracle sql
c programming:
link► • c++ programming
.-----------------------------------------------------------------------------------------------------------.
watch more videos:
learn oracle sql online overview tutorail :
• learn oracle sql online overview tuto...
how to fix or repair a corrupted usb flash drive or cd card using command prompt:
https://www.youtube.com/edit?video_id...
how to copy a folder using cmd:
https://www.youtube.com/watch?v=Lblhb...
how to move a folder using cmd:
https://www.youtube.com/watch?v=YFfHZ...
how to dell files in cmd:
https://www.youtube.com/watch?v=3-lqg...
how to make and remove directory:
https://www.youtube.com/edit?video_id...
how to change color and title in cmd:
https://www.youtube.com/edit?video_id...
how to change directory in command prompt:
https://www.youtube.com/watch?v=SmLYx...
.-----------------------------------------------------------------------------------------------------------.
social media links:
join our group:
► / 24299. .
► Follow on Google+: http://[email protected]
► Follow on Twitter: / @rananavi4766669 :