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 Go to next message
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

Re: Really its a challenge for experts.....help please [message #304763 is a reply to message #304759] Thu, 06 March 2008 09:18 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Not really an expert challenge if you ask me Wink

Look at MOD()-function
Previous Topic: wrong data of query result
Next Topic: summation of result of two queries
Goto Forum:
  


Current Time: Mon Aug 21 10:36:48 CDT 2017

Total time taken to generate the page: 0.05170 seconds