Recent content by james777

UPDATE MyTable SET (Col1, Col2,...) = (SELECT n_system_track_id , n_system_track_id FROM ( Your Query) );

Try by changing the CHARCTERSET to UTF8, to see if it works.

Thanks a bunch.Excellent and elegant solution,Worked perfectly with a single FTS, performed very well. But the requirement changed again not to duplicate the pair and to link with parent instead of generating a surrogate key for each key pairs. CREATE TABLE PLAN ( PLAN_ID NUMBER(10)...

Looking for a better alternative solution, as this is costly with five FTS.

Hi Mufasa, CREATE TABLE PLAN ( PLAN_ID NUMBER(10), PLAN_KEY VARCHAR2(25), PLAN_VAL NUMBER(1) CHECK(plan_val < 6) ) INSERT INTO PLAN SELECT 100,'A',1 FROM DUAL UNION ALL SELECT 100,'B',2 FROM DUAL UNION ALL SELECT 100,'C',3 FROM DUAL UNION ALL SELECT 100,'D',4 FROM DUAL UNION...

Tablename should not be a problem (You name it). I am looking for best performed SQL. Thanks Jim

This is like key-value pairs in a set . Walking through the set and making them as links starting from first to last . In a set the maximum links are 5 ( fixed). Business is something related to hierarchial key pairs. Strange requirement though PKID Col1 Col2 100 A 1 100 B...

What are the best ways to transform the below output in SQL. I got the result by outer join the same table multiple times. Any help is appreciated. Col1 Col2 A 1 B 2 C 3 D 4 E 5 Should transform to Col1 Col2 ..................................col10 A 1 A 1 B...

Hi Venu, Thank you for your suggestion. How would i do that, can you send a piece of code. I tried , but unsuccessful. How would i check the value form bean property from jsp function?. I have db call in action class which sets a setter (setRecordFound). If you have some example that would be...

Hello All, I am having trouble getting the field focus in HTML . What i need : When a user comes to form ,the focus is set to Field1. and next to it is a button to do search ,which does a search action( when user clicks) and fills up the field2, field3, field4 and field5. When user clicks the...

I am currently learning Sturts/JSP. Could someone help me by posting a piece of code to display JSP/HTML data in Struts as below. I have a form bean and databean. I was able to use the Sturts logic tld to display the data. The problem i am facing was , all the records were displayed ,But i...

I expect 80 rows from the query. I have no idea why this is hanging forever. I am on 9iR2. Basically i want to update and tried the for loop before updating.. Is it costly to convert the lob to variable (V). Any over head of creating temp lobs when convertion. Thanks

Hello All, Below code hangs and coming out at all. I commented out the UPDATE part and did a dbmsout but even hanging for ever. are there any performance problems.. declare c clob; type tt_id is table of vega.id%type; type tt_val1 is table of vega.val1%type; type tt_val2 is table of...

Thank You Wishdiak . I downloaded from Microsoft msdn and i guess w2k3 is not an evaluation version. I will to restore using Safe Mode..

I can not even logon to server after booting up the machine. I got win98/w2k3 on same machine. I use w2k3 as standalone machine either i logon to win98/w2k3. It's not on a network. Recently i installed Active directory and uninstalled it again successfully. I sent the above log after logging on...