What do you want to save?
Add Code snippet
New code examples
-
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 -
SQL 2021-08-27 17:15:02
connect to sql server with python
import pyodbc # Some other example server values are # server = 'localhost\sqlexpress' # for a named instance # server = 'myserver,port' # to specify an alternate port server = 'tcp:myserver.database.windows.net' database = 'mydb' username = 'myusernam... Add solution