Home » SQL & PL/SQL » SQL & PL/SQL » Data retrieving (9.0.4.0)
Data retrieving [message #344789] Mon, 01 September 2008 04:54 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

Here I am attaching the document.Please look into the document and give me your suggestion to resolve the issue.

Thank you.
Re: Data retrieving [message #344790 is a reply to message #344789] Mon, 01 September 2008 04:57 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Since you asked :

ࡱ                >  	               i          k      .....


I answer :

   0                      0                      0                      0             ......     


Post in a READABLE format!
Re: Data retrieving [message #344792 is a reply to message #344789] Mon, 01 September 2008 04:58 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Sorry - it won't open on my system either.

Re: Data retrieving [message #344796 is a reply to message #344790] Mon, 01 September 2008 05:03 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

oh! I am sorry. Here I will post the requirement.
[code]
In Pubs database we have table like below
Card table with data as shown below
Cardno	bincardno	name	dept	userfld2
1	N/A             	MAHENDRA GOTTI                	9	5702
10	N/A             	PRIYANKA SHARMA               	9	5700
793	N/A             	SURESH KUMAR G                	2	2325
50	N/A             	ARUN SHANKAR V                	2	2327
23	N/A             	SURJIT MUKHERJEE              	3	6249
65	N/A             	BASAVASREENIVAS               	2	1449

[\code]
and in Master database we have table like below
Card table with data as shown
[code]

cardno		name		Empno
1	             	MAHENDRA GOTTI                		5702
10	             	PRIYANKA SHARMA               		5700
793	             	SURESH KUMAR G                		2325
50	             	ARUN SHANKAR V                		2327
        23	             	SURJIT MUKHERJEE              		6249
65	          	BASAVASREENIVAS               		1449
[/code]

In the pubs database the card transactions is going on daily 
thus means one can add the card, delete the card….etc… when 
this modifications reflect in the card table in Pubs database 
it should automatically  reflect in the Card table which is there in the Master database.
And it have to access the fields which is required for the Card 
table in master database.

Other Requirement

In Model database we have a table like below
 T2008717 table with data
[code]
Time	       site	        tcu	       dcu	transcodea	transcodeb	cardnum	descriptn								
0:02:00	1	2	1	2	0	793	17 Jun 2008    00:02:00     MAIN ENTRANCE 11TH FL            793                 VISITOR 21, Access Granted
0:02:10	1	2	1	2	0	793	17 Jun 2008    00:02:10     MAIN ENTRANCE 11TH FL            793                 VISITOR 21, Access Granted
0:06:46	1	2	1	2	0	65	17 Jun 2008    00:06:46     MAIN ENTRANCE 11TH FL            65                  security 1, Access Granted
0:07:18	1	2	1	2	0	793	17 Jun 2008    00:07:18     MAIN ENTRANCE 11TH FL            793                 VISITOR 21, Access Granted
0:08:49	1	2	1	2	0	793	17 Jun 2008    00:08:49     MAIN ENTRANCE 11TH FL            793                 VISITOR 21, Access Granted
[/code]
and in Master database we have table like below
Transaction table syntax with data as shown
[code]
Cardno	Empname	Firstdate	Timein	Timeout	
793	Soumya Babu	07/17/2008	0:02:00	0:08:49	
65	Gunupuru Gandhi	07/17/2008	0:06:46	21:42:44	
[/code]
In the T2008717 is the table in Model database, which take the 
transactions daily for no of times like shown above in the 
sample data. Thus we have to pick the data in [Time] filed as 
starting time as Timein and ending time as Timeout with the cardnum and date.
I have to store that data in the Transaction table which is 
there in Master Database as shown in the format.
Daily in the Model database the different table will create as 
T2008718, T2008719……………and soon…..and thus end of the month the syntax of the table name is automatically changes to T2008801, T2008802, T2008803……………etc…………soon thus daily at schedule time 
at 10:30 the system automatically create the above table. And 
after that schedule time it has to automatically retrieves the 
data in that Model database and it should store the data daily in Transaction table in Master database.

	Thus it is my requirement…………….. how to store in to my 
database………..  pls. help me by providing the solution……. I 
think what I’m going to say to you by this document you got I 
think…. Pls. write the quires and process to me so that it is 
very helpful to me. For the above process



PS::I know this is not thw way to post the issue. But I am not abke to upload the cocument. So I pasted the requirement.

Thank you.



[Updated on: Mon, 01 September 2008 05:05]

Report message to a moderator

Re: Data retrieving [message #344799 is a reply to message #344796] Mon, 01 September 2008 05:08 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
This is not a "Post your requirement and get people to completely code for you for for free" site.

Where are you stuck? What is your specific problem?
Previous Topic: Standards for Stored Procedures
Next Topic: concatnating the second table data in single column of first table
Goto Forum:
  


Current Time: Wed Dec 07 20:27:59 CST 2016

Total time taken to generate the page: 0.16034 seconds