What do you want to save?
Add Code snippet
New code examples in category SQL
-
Jacob Lockett 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 -
Skippy 2021-08-28 06:56:02
Enum in SQL Server
USE WorldofWarcraft; CREATE TABLE [users] ( ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY, username nvarchar(255), password nvarchar(255), mail nvarchar (255), [rank] nvarchar (255) NOT NULL CHECK ([rank] IN('Fresh meat', 'Intern','Janitor','... Add solution -
Barbara Paterson 2021-08-28 06:51:01
insert overwrite table in mysql in nifi
with partition_list as(select order_date, count(distinct input__file__name) cnt from ordersgroup by order_date having cnt > 5)insert overwrite table orders partition (order_date)select * from orderswhere order_date in (select order_date from partitio... Add solution -
-
ItsKiddow 2021-08-28 03:50:01
postgresql date at timezone
SET TIME ZONE 'Europe/Moscow'; Add solution -
Javiator 2021-08-28 03:23:02
intellij mysql set timezone
value="jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC" in MYSQL do :(for french people, change the zone for u) SET GLOBAL time_zone = 'Europe/Paris'; SET time_zone = 'Europe/Paris'; + see spring configuration : https://www.baeldung... Add solution