[This topic is migrated from our old forums. The original author name has been removed]
Hi,
Anybody know how can create a Table-Valued User-Defined Functions in DBvisualizer.
If kwon please help me.
Edited by: sonal on 2014-apr-09 13:49
1 Comment
Hans Bergsten
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: How Create Table-Valued User-Defined Functions
Hi Son,
The exact syntax depends o the database, but you can typically use the Create Function action (in Pro edition only) and then use the Function Editor (in Pro edition only) to adjust parameters and/or return type. Alternatively, you can execute the CREATE FUNCTION statement in the SQL Commander with Execute Buffer, please see this for more details:
http://confluence.dbvis.com/display/UG91/Executing+Complex+Statements
Best Regards,
Hans
anonymous