Hello everyone ,
PROMPT is able to output strings on SQL*Plus, then how to output character strings with blank space using prompt on it?
Please take a look at the following example,
SQL> PROMPT [02] Another approach is creating trigger on SYS
[02] Another approach is creating trigger on SYS
SQL> PROMPT and then checking the client_info column of v$session.
and then checking the client_info column of v$session.
My intention is asking the first word "and" on the second character strings to align up and down with "Another" on the first character strings.
Could you have a good advice? Thanks in advance!
Best Regards
Quanwen Zhao