When working with SQL, or the structured query language to access or manipulate an Oracle database, a forward slash character is a sound and resourceful command. The forward slash can be a valid alternative and replace the semicolon to terminate a SQL statement. The forward slash is also very effective when using temporary variables in a SQL query.
- Skill level:
Other People Are Reading
Connect and Login to Oracle SQL*Plus.
Click "Start," "All Programs" and "SQLPlus." Once the Oracle SQL*Plus Dialog Box appears, enter your Username and Password, then click "OK."
Use and Terminate a SQL statement using the forward slash character. At the SQL prompt, the type
" select customer_id, first_name, last_name
where customer_id = 1
Run a SQL statement that is stored in the buffer. AT the SQL prompt, Type " (/) the ampersand."
Define and run a temporary variable and then rerun the query using the forward slash character. At the SQL prompt, enter in the SELECT statement shown below:
"SELECT customer_id, first_name, last_name
WHERE customer_id = &customer_id_var;"
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for