Thanks,
That fixed the problem I was having. Now, I just have to figure out how to read something like this.
CREATE TABLE "a2k"."DA2404_DISCREPANCY"
(
"MR_CONTROL_NO" varchar(30) NOT NULL,
"DISCREP_NO" integer NOT NULL,
"TM_ITEM" varchar(4) NULL,
"STATUS" varchar(1) NULL,
"DEFICIENCY" varchar(30) NULL,
"CORRECTION" varchar(30) NULL,
"INITIALS" varchar(3) NULL,
PRIMARY KEY ("MR_CONTROL_NO", "DISCREP_NO") WITH HASH SIZE 10
)
go
I want to change VARCHAR to VARCHAR2. I know that the ^ is to anchor at the beginning of a line. What does the $ do, exactly?
Thanks,
Bobby | [reply] [d/l] |