|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Creating Dynamic table names in PL/SQL
Hello,
I am trying to write dynamic queries inside an oracle package. The problem I am facing is I want to have one procedure to access to different schemas But contain the same table names. For example One set of tables is for data that needs to go through a review process. Then the data is migrated to a permanent set of the same tables. I want one procedure to access both. Does anyone know of a way that I can generate dynamic tables based on a passed in value. Any help on this matter would be greatly appreciated. Thanks in advance. |
|
#2
|
|||
|
|||
|
dynamic
i don't quite understand what you are trying to do but to create a dynamic sql:
execute immediate 'create table '||your_schema||'.'||table_n; the schema and table_n are parameter you can enter as a parameter. Galit. |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Creating Dynamic table names in PL/SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|