Search results for query: *

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...

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...

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...

Hi All, I tried logging into W2K3 server, after entering username/password. it gives a message password is incorrect or checks username , domain name.. Very positive that my username/password are correct. I installed paragon utility to see the NTFS file system from Win98. Below is one of the...

I need to collapse rows into one appened columns Example: Input col1 col2 col3 col4 1 A YY Oracle 1 A YY Siebel 1 A YY Sysbase OutPut: Should be in single row as 1 A YY Oracle,Siebel,Sysbase.. There might be 1.. n Col4 values Unknown.. Thanks

Sometime back i ran a paragon utility to see the NTFS(WinNT) file system on FAT(Win98) and it does giving me lot of problems now while windows update ( failing). I dont want to see the NTFS file system on FAT(win98). Is there a way that i can do that. Please help.. Thanks Jim.

Query Help: I have three tables which were joined on non-unique index key. Tables: Tab1 has 2 Million Rows. Tab2 has 50K Tab3 has 1K.. select distinct Tab1.col1 , Tab1.col2 from Tab1 T1 where not exists ( select '1' from Tab2 T2 where T2.col1 = T1.col1 ) and not...

Hello All, Can anyone help me how to change the download DESTINATION folder for running windows update. "Success IUENGINE Download destination root folder is: k:\WUTemp" I want to change this K:\WuTemp to C:\WUTemp. I searched registry and could not find any references.. I checked the...

Hello all I got 2 pl/sql tables with the following data as below and i want to do a full outer join on the result.. ,which..Pl/sql Tables are populated with lot of business logic which is not achievable by SQL queries. PL/SQL Table1: ---------------------- Code D-Code 1 D1 2 D2 3...

How to return boolean value in decode statement.... select decode(a.col1,b.col1,true,false) from dual; Values returned by decode are characters. Is there a way to return boolean true false .. Thanks Jim.

I am trying to write a query to get the results that were marked with "--+" in one sql. The table got nearly Million rows and tried with different sql queries but hanging and the results are not coming out. Can anyone tell me to write an efficient query. Col1 Col2 Col3 1 18 1011--+...

I am trying to write a query to get the results that were marked with "--+" in one sql. The table got nearly Million rows and tried with different sql queries but hanging and the results are not coming out. Can anyone tell me to write an efficient query. Col1 Col2 Col3 1 18 1011--+ 1 27...

Hello All, I got 40Gb drive and partitioned as below C: 1.9GB -- FAT16 -- Primary 38GB extended -- Primary. 10GB - NTFS -- Logical 10GB - NTFS -- Logical 5GB - FAT32-- Logical 5GB - FAT32-- Logical 1GB - LinuxSwap 7GB - Linux I Installed Win98 and...

HI,<br>Can any of you tell me how to write a unix shell script using AWK or general scripting<br>to append 3 files horizontally into a single file with two fields common in each file and the common fields doesn't repeat in the final file.<br><br>Example...

HI,<br>Can any of you tell me how to write a unix shell script (i'm learning now)<br>using AWK or general scripting<br>to append 3 files horizontally into a single file with two fields common in each file and the common fields doesn't repeat in the final file.<br><br>Example...