oracle11g - Casting a String to a Symbol in PLSQL -



oracle11g - Casting a String to a Symbol in PLSQL -

i've created anonymous plsql block test , i'm running issue formatting.

set serveroutput on begin in (select distinct do.subobject_name dba_objects do.object_name='my_table' , do.object_type='table partition') loop dbms_output.put_line(i.subobject_name); select t.field some_var my_table partition(i.subobject_name) t; end loop; end;

however several compilation errors, believe related fact i.subobject_name string. believe partition function wants actual partition symbol(proper term this?), can't give in loop.

is there kind of casting function can perform i'm looking for?

partition is not function. partition keyword in context whole statement static , cannot pass partition name it; partition name must specified @ compile time. you can re-create statement dynamically , pass partition name in loop - a-la doing it. create sure concatenate string , not utilize bind variables, or statement @ run time won't parsed , won't run.

name symbol table partition

plsql oracle11g

Comments

Post a Comment

Popular posts from this blog

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

c# - Create a Notification Object (Email or Page) At Run Time -- Dependency Injection or Factory -

c# - Create a Notification Object (Email or Page) At Run Time -- Dependency Injection or Factory - i have code emails me notification when happens. trying add together page , also remove dependency on email. for reference; have name of notification want send stored string in database. @ runtime have list of people , string representation of want receive. i thought dependency injection ninject, kernel bindings got big , seemed hacking together. then thought simple factory, activator.createinstance(email/page) inotifcation, don't know how handle differing constructor parameters (unless utilize common, complex property, employee, has info need). so far have this: public interface inotification { void sendmessage(); } public class email: inotification { private readonly string _toemailaddress; private string body { { homecoming "email"; } } private static string smtphost { ...
Read more

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more