On Mar 1, 12:40 pm, andalou <[email protected]> wrote: > On Mar 1, 11:46 am, vimlover <[email protected]> wrote: > > > > > Hello, > > > I have hundreds of rows in a files like: > > > ALTER TABLE "PCDTST"."ACCOUNTINGSTATUS" ADD CONSTRAINT > > "PK_ACCOUNTINGSTATUS" PRIMARY KEY ("ACCOUNTINGSTATUS") USING INDEX PCTFREE > > 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST > > GROUPS 1) TABLESPACE "PESDBO_INDEXES" LOGGING ENABLE ; > > > how can I change to: (just delet 'USING' clause till ';' in each line) > > > ALTER TABLE "PCDTST"."ACCOUNTINGSTATUS" ADD CONSTRAINT > > "PK_ACCOUNTINGSTATUS" PRIMARY KEY ("ACCOUNTINGSTATUS"); > > > Thank you > > vimlover > > > -- > > View this message in > > context:http://www.nabble.com/How-to-do-this--tp22274905p22274905.html > > Sent from the Vim - General mailing list archive at Nabble.com. > > :%s/ USING.*/ > > Regards, > Cesar
I've forgotten something: :%s/ USING.*/; Regards, Cesar --~--~---------~--~----~------------~-------~--~----~ You received this message from the "vim_use" maillist. For more information, visit http://www.vim.org/maillist.php -~----------~----~----~----~------~----~------~--~---
