-
PL/SQLta
Hi everybody !!!!
How I write FUNCTION IN Oracle, I want to Execute query with Field And table pass by parameter, Example
v_Field NVARCHAR2
v_Table NVARCHAR2
BEGIN
-- Variable pass form cell function.
v_Field = 'Salary';
v_Table = 'Employees'
EXECUTE IMMEDIATE 'SELECT '||v_Field||' FROM '|| v_Table
INTO v_GetValue ;
RETURN v_GetValue ;
END
Thank a lot ...............
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|