What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-10-24 04:30:10
oracle ddl
-- 4000 characters max SELECT dbms_metadata.get_ddl('TABLE', 'table_name', 'owner') FROM DUAL; SELECT dbms_metadata.get_ddl('VIEW', 'view_name', 'owner') FROM DUAL; SELECT dbms_metadata.get_ddl('PACKAGE', 'pkg_name', 'owner') FROM DUAL; SELECT dbms_meta... Add solution -
SQL 2021-09-25 22:22:04
query has no destination for result data
/* you cannot junt do the select, you're supposed to use it in the return as the code below */ CREATE OR REPLACE FUNCTION fun() RETURNS text AS $$ BEGIN --- .... RETURN(SELECT dblink_disconnect()); END $$ LANGUAGE plpgsql; Add solution -
SQL 2021-09-13 12:56:04
dbms_metadata.get_ddl table
-- 4000 characters max SELECT dbms_metadata.get_ddl('TABLE', 'table_name', 'owner') FROM DUAL; SELECT dbms_metadata.get_ddl('VIEW', 'view_name', 'owner') FROM DUAL; SELECT dbms_metadata.get_ddl('PACKAGE', 'pkg_name', 'owner') FROM DUAL; SELECT dbms_meta... Add solution -
SQL 2021-09-07 03:57:02
how to get the query of a view in oracle
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'FLEX_TRADE_AGREG', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEW... Add solution -
SQL 2021-09-02 00:27:01
check index sql server
create procedure _ListIndexes(@tableName nvarchar(200)) as begin /* exec _ListIndexes '<YOUR TABLE NAME>' */ SELECT DB_NAME(DB_ID()) as DBName,SCH.name + '.' + TBL.name AS TableName,IDX.name as IndexName, IDX.type_desc AS IndexType,COL.Name as Colum... Add solution -
SQL 2021-08-28 07:15:02
oracle get view definition
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'FLEX_TRADE_AGREG', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEW... Add solution