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: Create a table for fields and record type
Next Topic: Huge Data extract-need suggestions
Goto Forum:
  


Current Time: Mon Feb 10 11:20:22 CST 2025