Recent content by mythologyrocks

Hi all, Can any 1 here tell me whats the maximum # of command line arguments a C++ program can have in a multiprocessing environment, i.e. we keep creating child processes based on argc in main(int argc, char **argv)..., before v hit stack overflow error... Thankx in advance.

Hi all, This is my given query: Select * From T1, T2 where T1.PK = T2.C2 and T1.C3 = T2.C3 where T1 table has the integer fields P1,C1,C2 and T2 has integer fields PK1,C21,C31. I need to implement the above as a sort-merge join in C or C++ or Java, etc. Language ain't the problem. I can't...

Hi, I am sorry if not clear. Actually, can some 1 cite some example to illustrate equi-join operation as 1) nested-loop join. 2) sort-merge join. 3) hash join. in ORACLE. Thankx in advance. Mythologyrocks!!!

Hi all, I am kinda new to ORACLE. Can some 1 here throw me some light on what 1) Nested-loop join. 2) Sort-merge join. 3) Hash join. are with some simple SQL examples. Thankx in advance. Mythologyrocks!!!

Hey there, I guess u just need to interchange the statements Close conn and RS.close. Close the connection to database after u close the record set u used.... I am not sure how helpful this is. Just try it... Mythologyrocks!!!

Hi, I am actually using ASP to write onto the oracle table. First of all, how shud i be creating a table that has 'FILE' as its data type? Say for example I want to create a table test with fields A,B and C with A and B being number(10) and C has to a FILE. (any type of file, say doc, pdf...

Hi, As a part of my project work, I need to upload files onto the oracle tables. For example, let's say I have a table called 'Assignment' to which the students in a particular course can upload their assignment files. The fields in the table are, Assignment number,Course number,Student...

Thx a lot dave...I got it. Regards, A new-comer...

Hi, Now does that mean the patiene_Id in table patient is an array? i.e. I can access it as patient_id(number)? Regards, Beginner....

Hi all, I am kinda new to Oracle. I'd like to create a table with one of the fields (say a numeric field) as an array. Any help is appreciated. Thanks in advance. Regards, A Beginner.