Home » SQL & PL/SQL » SQL & PL/SQL » Really its a challenge for experts.....help please (oracle 10g)
Really its a challenge for experts.....help please [message #304759] |
Thu, 06 March 2008 09:05  |
vijay.nimmakuri@gmail.com
Messages: 10 Registered: February 2008 Location: inida
|
Junior Member |
 
|
|
Hi All,
i need a SQL or Pl/sql Statement to solve this problem ,please can any one could help me....
1)i have a table with following columns(TABLE 1)
1,CHANDRA, HYDERABAD
2,SURENDRA,CHENNAI
3,ARUN, BANGALORE
4,VIJAY, SSS
5,JAGGA, MUMBAI
6,SEKHAR, HYDERABAD
7,SURI, MADURAI
2) and another table is (Table 2)
1,2/2/2008
2,2/3/2008
3,2/4/2008
my requirement is the first table recors 1,2,3, should be assigned with 1,2,3 of second table and 1st table 4,5,6 records should be assigned with 1,2,3 of second table and 7,.,. with 1,.,. of second table and so on depending the no.of columns
please any one could help me please...
Thanks in advance
Priya
[Updated on: Thu, 06 March 2008 09:06] Report message to a moderator
|
|
|
|
Goto Forum:
Current Time: Mon Feb 10 11:20:22 CST 2025
|