In oracle I ran the deletion script to clean up the particular database using custid.custid is the parameter .&&1 is used in the oracle Inthe same way tried but $1 not possible ?but using function is possible is their any problem with fun to Clean the database I have 100 statements in script ... On Wednesday, August 27, 2014, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 08/27/2014 08:24 AM, Ramesh T wrote: > >> any help... >> > > Honestly, this is basic programming/scripting. I would suggest picking up > an introductory programming book to get the basics down. > In the meantime, you have used a parameter variable ($1) with out actually > supplying a parameter. So Postgres has no idea what $1 represents. Either > hard code the part.custid value i.e part.custid = 1 or find a way to supply > the value. How you do that is going to depend on how you are going to use > the script and where you are expecting to pull the value from. > > thanks, >> ram >> >> >> On Wed, Aug 27, 2014 at 3:22 PM, Ramesh T <rameshparnandit...@gmail.com >> <mailto:rameshparnandit...@gmail.com>> wrote: >> >> Hi, >> I have deletion script to delete particular cust from >> database.I was saved a file name with custde.sql.i need to run from >> command line like putty tool..But have a problem >> >> example : >> >> delete from part where part.custid=$1; >> >> when i ran custde.sql from putty tool >> >> db=#\i custde.sql >> >> it's return error >> psql:custde.sql:9: ERROR: there is no parameter $1 >> LINE 1: ..._ID from part where part.CUST_ID = $1); >> >> please let me know how to run script ..and how to give parameter.. >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
