Home » SQL & PL/SQL » SQL & PL/SQL » Re: About insert data into a table which created in pl/sql
Re: About insert data into a table which created in pl/sql [message #39554] Tue, 23 July 2002 07:22
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
to do this inside pl/sql
give the quotes after u accept the values itself,
so that you no need to give quote during the insert.
for example
instead of giving

v_cust_id CHAR(5) := &v_cust_id;


give
v_cust_id CHAR(5) := '&v_cust_id';

you need to give singgle quotes only for the character and date data.
But u cannot directly change the manner it asking for the input.
SQL*plus has its own limitations.
If you want to, then u need to write more complicated routines just to hande this.

Report message to a moderator

Previous Topic: how can i print name
Next Topic: Re: Scheduling of procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 16:43:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.