object_type
namespace.object_name
database
.database.schema
or schema
.use_fully_qualified_names_for_recreated_objects
TRUE
, the generated DDL statements use fully-qualified names for the objects to be recreated.FALSE
.VARCHAR
) containing the text of the DDL statement that created the object.CREATEPROCEDURE
statement did not specify EXECUTEASOWNER
orEXECUTEASCALLER
, the output from GET_DDL
include EXECUTEASOWNER
because that is the default.object_type
and object_name
(including namespace
if specified) must be enclosed in single quotes.object_type
, TABLE
and VIEW
are interchangeable. If a TABLE
object type is specified, and the object specified by name is a view, the function returns the DDL forthe view and vice-versa.object_type
is FUNCTION
(i.e. UDF) and the UDF has arguments, you must include the argument data types as part of the function name, in the form of'function_name([arg_data_type[,...]])'
.object_type
is PROCEDURE
and the stored procedure has arguments, then you must include theargument data types as part of the function name, in the form of'procedure_name([arg_data_type[,...]])'
.books_view
:books_schema
and the objects in the schema (the table books_table
and the view books_view
):multiply
that has twoparameters of type NUMBER
:stproc_1
that has one parameter of type FLOAT
: