Oracle SQL Tutorial#79 Runtime input to SQL query |substitution operator Oracle Database
In this tutorial explaining how to give input at runtime ( bind variable /substitution operator ) in where clause of Oracle SQL query
Substitution variables are a feature of the SQL*Plus tool. They have nothing to do with the way SQL is processed by the database server. When a substitution variable is used in a statement, SQL*Plus requests an input value and rewrites the statement to include it. The rewritten statement is passed to the database. As a result, the database server knows nothing of the substitution variable
Oracle SQL Complete Tutorial/Training/Course for the beginner:
• Tutorial#1 Basics Of Oracle SQL for B...
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-3193...
Contacts Email:
[email protected]
Instagram:
/ equalconnect
Twitter:
/ lrnwthr
#equalConnectCoach #rakeshmalviya #OracleTutorial