Home » SQL & PL/SQL » SQL & PL/SQL » Need suggestion
Need suggestion [message #344225] Fri, 29 August 2008 02:31 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi all,

Thank you.


[Updated on: Fri, 29 August 2008 02:32]

Report message to a moderator

Re: Need suggestion [message #344229 is a reply to message #344225] Fri, 29 August 2008 02:35 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
What suggestion?
Re: Need suggestion [message #344254 is a reply to message #344229] Fri, 29 August 2008 04:14 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

I am sorry , the data was missed.Here is my query.
Daily I have to sent one report to my client regarding the employees in and out timings.These timings are depends on the
card swiping.Daily I want to read the data . There is no 
particular table. The table got generated dynamically.
so this will read the data for EMPNO,ENAME,In-Time,Out-Time.
so I want to generate a report .
can any one please let me know how the records will generated 
into some table (the table which is created dynamically).

I have created one trigger but it will read the data from one
particular table. But there is no particular table . The table got generated dynamically..

Thank you.

[Updated on: Fri, 29 August 2008 04:15]

Report message to a moderator

Re: Need suggestion [message #344255 is a reply to message #344254] Fri, 29 August 2008 04:24 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
It is really confusing.
1.Is oracle creating a table and populating data?
2.What code populates the creates the table and populates data?
Post the code

[Updated on: Fri, 29 August 2008 04:26]

Report message to a moderator

Re: Need suggestion [message #344270 is a reply to message #344254] Fri, 29 August 2008 04:54 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Your requirement is not clear.


Regards,
Oli
Re: Need suggestion [message #344489 is a reply to message #344270] Sat, 30 August 2008 01:01 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
user71408 may be requiring the following.

in our office too, finger swipe card reader has got some buffer memory which stores employee number, in / out time in ascii format in line sequential. Whenever it is downloaded (once in four days ) some temporary table created through data has been pooled and transfered. I think user71408 is referring as dynamic handling etc.

yours
dr.s.raghunathan
Re: Need suggestion [message #344525 is a reply to message #344254] Sat, 30 August 2008 03:32 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
user71408 wrote on Fri, 29 August 2008 11:14

But there is no particular table . The table got generated dynamically..


DATA is dynamic. Tables are static.
In a proper application your data-model should not change at runtime.
Why can't you load the data into an existing table instead of creating a new table? If the data is loaded from an external file, use an external table.
Re: Need suggestion [message #344532 is a reply to message #344525] Sat, 30 August 2008 04:47 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The way I understood the requirement:

So you have "some data" that is created dynamically "somewhere" in "some way" and stored in "some format" "somewhere else", and you want to do "something" with it.

Well. Good luck. I'm crossing my fingers for you. That's about all I can do.
Previous Topic: strange to_char result.
Next Topic: Min function not working for minimum date
Goto Forum:
  


Current Time: Fri Dec 02 14:16:21 CST 2016

Total time taken to generate the page: 0.12781 seconds