What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-01 00:55:31
oracle get 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 2022-01-23 09:20:08
oracle get partition name by high value
-- Sortable (by high_value) list of partitions / subpartitions in a table -- For partitions, change ALL_TAB_SUBPARTITIONS to ALL_TAB_PARTITIONS SELECT TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, HIGH_VALUE FROM ( WITH xml_s AS ( SELECT dbms... Add solution -
SQL 2022-01-22 18:46:11
oracle export view ddl
-- 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', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution -
SQL 2021-11-05 17:03:16
how to get ddl for materialized view
-- 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', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution -
SQL 2021-11-02 16:38:10
ddl materialized view
-- 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', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution -
SQL 2021-10-24 08:29:06
How to get number of months between 2 dates sql server
CREATE FUNCTION FullMonthsSeparation ( @DateA DATETIME, @DateB DATETIME ) RETURNS INT AS BEGIN DECLARE @Result INT DECLARE @DateX DATETIME DECLARE @DateY DATETIME IF(@DateA < @DateB) BEGIN SET @DateX = @DateA ... Add solution