the name of a table inside a function

[Chatbour]

Hello :)
I have this query :

select MyFunction(MyColumnName)
from MyTableName

How can I get the name of the table MyTableName inside the function MyFunction ?
Also, is this correct under Oracle 7 ?

create or replace function MyFunction(N out number)return number
is
 buffer varchar2(512);
Begin
 buffer := 'select count(*) from Client_Table';
 execute immediate buffer into N; --Especially this
 return N;
End;
/
 

Thank you for answering :)

[Dave44]

Hello :)
I have this query :

select MyFunction(MyColumnName)
from MyTableName

How can I get the name of the table MyTableName inside the function MyFunction ?
Also, is this correct under Oracle 7 ?

create or replace function MyFunction(N out number)return number
is
 buffer varchar2(512);
Begin
 buffer := 'select count(*) from Client_Table';
 execute immediate buffer into N; --Especially this
 return N;
End;
/
 

If you know what MyTableName is why not just code it into the function.  or do you not know it until run time.  If that is the case then you need some dynamic sql.
 
for the second part of your question in 10G it is:
 
 
 
    Expand|Select|Wrap|Line Numbers
 
 
 
    
 
 
[152]dave@ORADB> DECLARE
 
  2       var      VARCHAR2(2000) := 'select count(*) from dual';
 
  3       var2     VARCHAR2(4000);
 
  4  BEGIN
 
  5       EXECUTE IMMEDIATE var
 
  6       INTO              var2;
 
  7  
 
  8       DBMS_OUTPUT.put_line(var2);
 
  9  END;
 
 10  /
 
1
  
 
PL/SQL procedure successfully completed.
  
 
Elapsed: 00:00:00.00
 
[152]dave@ORADB>