How can I use variable value as a table name?

[bhavanirayala]

Hi All,

I have a variable which stores the table name.
i.e
[code=oracle]

DECLARE
V_TEMP VARCHAR2(10) := 'EMP';
BEGIN
SELECT * FROM V_TEMP;
END;

[/code]


BUT I am getting the error like V_TEMP is not the table name.

How can I access the value of the V_TEMP value?
First of all Is It acceptable or not?

please help me.

Thankyou.

[QVeen72]

Hi,

Take a Look at this Thread

Regards
Veena

[amitpatel66]

Hi All,

I have a variable which stores the table name.
i.e
[code=oracle]

DECLARE
V_TEMP VARCHAR2(10) := 'EMP';
BEGIN
SELECT * FROM V_TEMP;
END;

[/code]


BUT I am getting the error like V_TEMP is not the table name.

How can I access the value of the V_TEMP value?
First of all Is It acceptable or not?

please help me.

Thankyou.

[code=oracle]
SQL> ed
Wrote file afiedt.buf

1 declare
2 v_temp varchar2(10):= 'emp_det';
3 e_rec emp_Det%ROWTYPE ;
4 BEGIN
5 EXECUTE IMMEDIATE 'SELECT * FROM '||v_temp ||' WHERE empno = 1' INTO e_rec;
6 DBMS_OUTPUT.PUT _LINE(e_rec.emp no||','||e_Rec. ename);
7* END;
SQL> /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
1,AAAA

PL/SQL procedure successfully completed.

SQL>
[/code]

[bhavanirayala]

Thankyou.Now I am able to run successfully.

[code=oracle]
SQL> ed
Wrote file afiedt.buf

1 declare
2 v_temp varchar2(10):= 'emp_det';
3 e_rec emp_Det%ROWTYPE ;
4 BEGIN
5 EXECUTE IMMEDIATE 'SELECT * FROM '||v_temp ||' WHERE empno = 1' INTO e_rec;
6 DBMS_OUTPUT.PUT _LINE(e_rec.emp no||','||e_Rec. ename);
7* END;
SQL> /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
1,AAAA

PL/SQL procedure successfully completed.

SQL>
[/code]

[amitpatel66]

Thankyou.Now I am able to run successfully.

You are welcome :)

Happy coding :)