Search results for query: *

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

$ cc filedate.c (Bundled) cc: "filedate.c", line 1: error 1705: Function prototypes are an ANSI feature. (Bundled) cc: "filedate.c", line 3: error 1574: Unknown size for "filestats". (Bundled) cc: "filedate.c", line 7: error 1588: "stderr&quot...

Thanks!! to you both! There is one more dangling problem, which is the year. Once I get the "Mar 13 09:59" value, I need to be able to say which year it is. I am in HP UX, and it is keeping the time stamp for the files which were touched(updated) in the last 6 months and for the rest...

-rw-r--r-- 1 sridh_c oaa 3 Mar 13 09:59 TEST.txt From the above file description, I need to get Mar 13 09:59. There should be a command, more like SED or AWK command? I will appreciate the help. Thx, Sri

DaPi, It is a One to Many relation on each join, I THINK. Now Mark wants to stop the FETCH when the first row fetched for each join to improve the performance. This would CHANGE the purpose of the business meaning behind the SQL, unless the requirement does not CARE about which CHILD row the...

Mark, Good concern. Short answer is NO, there is no simple way. In RDBMS, SQL is designed to get all rows that matched the join condition(equi join) and all rows matched from one table and simply all the rows from the second table with out worrying about a math(outer join). But there are no...