Home » SQL & PL/SQL » SQL & PL/SQL » Using variables for accessing tables in pl/sql
Using variables for accessing tables in pl/sql [message #37324] Wed, 30 January 2002 19:34 Go to next message
Syed Mushtaq Ahmed
Messages: 1
Registered: January 2002
Junior Member
I have a problem. I wrote different activities of several persons in a separate table. These tables are named with the real name of concerned persons. So when I wish to check the activities of a person, I take his/her name through keyboard in a memory variable. Then fetch all the records of that person from their concerned tables, using that memory variable as the table name. I tried a lot, but I couldn't be able to access the table(s) using memory variables. So I wish someone to help me in this regard. Thanks.
Re: Using variables for accessing tables in pl/sql [message #37334 is a reply to message #37324] Thu, 31 January 2002 10:11 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Is this an SQL script??
Previous Topic: How can I use count(*) with out sorting ?
Next Topic: unix date to "oracle date"
Goto Forum:
  


Current Time: Thu Mar 28 19:16:37 CDT 2024