|
The following SQL can be used to query your database system tables for function DDL.
Sybase ASE
SELECT A.text
FROM syscomments A
WHERE A.id = Object_Id(:sFunction)
Oracle
SELECT SUBSTR(text,1,Length(text) - 1), line
FROM all_source
WHERE type = 'FUNCTION'
AND Owner = :sOwner
AND NAME = :sFunction
UNION
SELECT SUBSTR(text,1,Length(text) - 1), line
FROM user_source
WHERE type = 'FUNCTION'
AND user = :sOwner
AND NAME = :sFunction
ORDER BY line
SQL Server
SELECT A.text
FROM syscomments A, sysobjects B
WHERE A.id = B.id
AND B.id = Object_Id(:sFunction)
ORDER BY colid
SQL Anywhere
SELECT A.text
FROM syscomments A
WHERE A.id = Object_Id(:sFunction)
|
|
QweryBuilder is an SQL Editor and Query Tool. Its purpose is
to make accessing information from a database simple, quick, accurate and
efficient.
Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in
one single application.
|
"QweryBuilder is a great, easy to use tool, that is a part of my everyday programmer life."
Read More Testimonials
|
|
|
