Recent content by srishan

Nevermind, I got it. ASCCI() function gives the ASCII value, FYI. srishan

7.37²-20.00²-3.00 0²6²1 The data is delimited by the superscript 2 character as shown above. Anybody knows the ASCII value of this? I need to Instring the ASCII value to separate the fields. Thanks, srishan

If we wrap pl/sql programs in UNIX one after another, want them to run in back ground. Want to check for the status of one program for successful completion before kicking the next pl/sql program. How can we do this in UNIX? How to check background process's exit condition before we start an...

aperson, Thanks again. regards, Sri

aperson, I am not able to open the diagram you sent. It says the file has unrecognized version, is there any other way that you can send the vsd in visio verion 5.0? Or Let me know what version of visio you used to create it. thx, sri

aperson, Did not receive the document so far. Do not know if you sent it yet, could you update this thread once you sent it accross? My hotmail is unreliable some times, I may have to give an alternative email, so. Thx, Sri

-- create a new table with same structure as emp SQL> create table emp2 as select * from emp where 1 = 2; Table created. -- create a trigger on new table SQL> create or replace trigger emp2_tgr1 2 before insert on emp2 3 for each row 4 begin 5 update emp set ename = :new.ename...

Thanks once again. Please do send it to srishan@hotmail.com I shall discuss the diagram with you if I have any doubts once I receive it. regards, Sri

OK. Any generic SQL statmetns you may have written to map old tables to NEW tables? Probably help me to get started. Let me know. Thx, Sri

aperson, Thx for the reply. I gather all this information interim(btw I posted the thread and you gave the reply), nevertheless, I appreciate your interest in replying. I am just wondering about these views. Even if Oracle takes them out some time, we can preseve them as custom views(copy the...

Any idea about this? Thx, Sri

Actually, I think I got it. Please ignore my previous post. Thanks a lot for all the help. Thx, Sri

Sambones, Very helpful!! Thanks again!! Could you tell me the difference of these two, time_t st_mtime; /* Last modification time */ time_t st_ctime; /* Last file status change time */ What I need is the last time it is modified and saved DATE. Thx, Sri

Changed the main funciton as the following, main(argc, argv) int argc; char *argv[]; { ... And it works like a charm!! Thx a LOT!! Sri

Oops!!!! I forgot to include the #include files, Yet, the following error remains, (Bundled) cc: "filedate.c", line 6: error 1705: Function prototypes are an ANSI feature. Please advise. Thx, Sri