Home » SQL & PL/SQL » SQL & PL/SQL » line continuation character
line continuation character [message #382] Fri, 08 February 2002 10:08 Go to next message
drewmoo
Messages: 6
Registered: February 2002
Junior Member
is there not a line continuation character in PL/SQL ? I think i've searched everywhere to no avail ... maybe there isn't one.

i want to write something like:
sql_stmt := "select column1, column2, column3"
" from table1"

instead of having to write the SQL statement on one line
Re: line continuation character [message #385 is a reply to message #382] Fri, 08 February 2002 11:03 Go to previous message
INTROV
Messages: 20
Registered: February 2002
Junior Member
sql_stmt := 'select column1, column2, column3
from table1'

This will work. No need to have quotes for every line.
Previous Topic: Parsing out SQL from an App Engine
Next Topic: Fill a field with an alpha plus the info from another field
Goto Forum:
  


Current Time: Thu Apr 18 20:15:07 CDT 2024