Re: Need advice on SQL*Plus Command - ACCEPT
From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 24 Jul 1999 23:22:25 +0200
Message-ID: <932851330.24384.0.pluto.d4ee154e_at_news.demon.nl>
Date: Sat, 24 Jul 1999 23:22:25 +0200
Message-ID: <932851330.24384.0.pluto.d4ee154e_at_news.demon.nl>
You need to 'escape' them. Put an extra quote
before every quote and a double quote before every double quote
Hth,
Sybrand Bakker, Oracle DBA
Received on Sat Jul 24 1999 - 23:22:25 CESTKate <iktsui_at_learn.senecac.on.ca> wrote in message news:379A28FC.49CAACB3_at_learn.senecac.on.ca...Hi,I'm a college student now taking an Oracle course, and I have a problem in displaying the following sentence using ACCEPT command : -
Please enter the customer's name :I cannot use single quote/apostrophe, nor double quotes in the prompt.
Can anyone please help me? Thanks
Kate