Oracle Magazine, July/August 2017
Database Application Developer and DBA BEYOND SQL 101 EMPLOYEE Betsy James Don Rose Donald Newton Frances Newton Matthew Michaels Roger Friedli Sasha Meyer Theresa Wong mark leblanc michael peterson ORACLE MAGAZINE JULY AUGUST 2017 110 10 rows selected The query in Listing 7 demonstrates how to re execute the Listing 6 statement that is now in the SQL Plus buffer When you use a forward slash character the SQL statement is reissued to the SQL execution environment and you are prompted for a value for the substitution variable without having to copy and paste the original SQL statement Additionally Listing 8 shows how the use of substitution variables is not limited to the WHERE clause of a statement Code Listing 7 Re executing the statement with the forward slash character SQL Enter value for v_ salary 90000 old 3 where salary v_ salary
You must have JavaScript enabled to view digital editions.