prompt the user to insert a new customer

[Deven Oza]

Hi,
All

Construct an SQL statement that will prompt the user to insert a new customer. Assume your table is called cust_info_tab. The customer information is as follows:

Column Data
CustID X25
CustName Gillian Ames
CustAddress 123 Mockingbird Lane
CustCity Arlington
CustState VA
PartsOrdered 12
PartNum 2323
DateOrdered 10-Oct-23

please help me

thanks
Deven Oza

[Reshmi Jacob]

hello

Try this ,

INSERT into table_nme Values (&CustID,&CustName,&CustAddress,&CustCity,&CustSta te,&PartsOrdered,&PartNum,&DateOrdered)

When the query is executed , it will ask for the values of variables, which you can give in quotation marks(eg : 'X25') if varchar

Regards
Reshmi