Hi i am new on Unix..........
I have to write a ddl and for tables and I am using single quotes in the comment for the table and its column...........but when i see on the unix server the ' dont show .

e.g. DROP TABLE DMR_PURGED;

CREATE TABLE DMR_PURGED
(
HEALTH_SERVICE_ID NUMBER(20) NOT NULL,
HEALTH_SERVICE_ITEM_NO NUMBER(2) NOT NULL,
SYSTEM_CD VARCHAR(2) NOT NULL,
PURGED_DT DATE NOT NULL,
REC_CREATE_TIMESTAMP DATE NOT NULL
);

COMMENT ON TABLE DMR_PURGED IS 'This stores purged member claims from PBS';

COMMENT ON COLUMN DMR_PURGED.HEALTH_SERVICE_ID IS 'Health Service ID';

COMMENT ON COLUMN DMR_PURGED.HEALTH_SERVICE_ITEM_NO IS 'Health Service Item Number';

COMMENT ON COLUMN DMR_PURGED.SYSTEM_CD IS 'System Code';

COMMENT ON COLUMN DMR_PURGED.PURGED_DT IS 'Purged Date';

COMMENT ON COLUMN DMR_PURGED.REC_CREATE_TIMESTAMP IS 'Record Create Timestamp';


CREATE OR REPLACE TRIGGER TRG_DMR_PURGED_TS
BEFORE UPDATE OR INSERT
ON DMR_PURGED
FOR EACH ROW
BEGIN

the comment line quotes either dont show or comes out as special character........plz help

How are you composing the file?

If you edit the file on the UNIX box with vi does the problem go away?

thats the whole problem......i m trying to edit it via Vi editor on unix and it doesnt let me edit.
so i making the changes ona notepad and FTP on unix....it still gives special characters in place of quotes

On the unix machine try:
tr -d '\r' < file.txt > file

Agarwalniru,
If you have the text in Notepad, the quick solution is to just
copy and paste it to unix vi.

Pasting in Vi didnt help .......it showed . in place of ' .........so i edited my script in Vi, i did not know how to use Vi , But i just now figured it out
But i really appreciate your help!!! thanks!!

Do you know how to use vi?

What are the files attributes, is it read-only?

How does vi complain?

What about nano, emacs or any other editor you have?

What about a text editor running under "X"?

What languages/code pages/character sets etc is your Windows box using?