Skip to content

Instantly share code, notes, and snippets.

import turtle
left_pad = turtle.Pen()
left_pad.penup()
left_pad.setx(-200)
left_pad.shape("square")
left_pad.shapesize(stretch_wid=3, stretch_len=2, outline=None)
circle = turtle.Pen()
circle.home()
Option Explicit
Sub GETLEIMacro()
Dim rng As Range, lei As Range
Dim objRequest As Object
Dim strUrl As String
Dim blnAsync As Boolean
Dim strResponse As String
Dim strLeiName As String
Option Explicit
Sub GETLEIMacro()
Dim rng As Range, lei As Range
Dim objRequest As Object
Dim strUrl As String
Dim blnAsync As Boolean
Dim strResponse As String
Dim strLeiName As String
Oracle SQLite Example
NVL IFNULL SELECT nome, ifnull(premios, 0) FROM emp;
(+) LEFT OUTER JOIN SELECT e.nome, e.ndep, d.nome FROM dep d left outer join emp e on e.ndep = d.ndep ORDER BY e.ndep;
ASCII Not supported
RPAD Not supported
CHR Not supported
CONCAT Not supported
SYSDATE date('now') SELECT date('now');
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 3.
| Oracle | SQLite | Example |
| NVL | IFNULL | SELECT nome, ifnull(premios, 0) FROM emp; |
| (+) | LEFT OUTER JOIN | SELECT e.nome "Nome", e.ndep "NDep", d.nome "Dep" FROM dep d left outer join emp e on e.ndep = d.ndep ORDER BY e.ndep; |
CREATE TABLE descontos
(
escalao NUMBER(2) PRIMARY KEY ,
salinf NUMBER(7) NOT NULL,
salsup NUMBER(7) NOT NULL
);
CREATE TABLE dep
(
75
95 64
17 47 82
18 35 87 10
20 04 82 47 65
19 01 23 75 03 34
88 02 77 73 07 63 67
99 65 04 28 06 16 70 92
41 41 26 56 83 40 80 70 33
41 48 72 33 47 32 37 16 94 29
@jppg
jppg / Startup.cs
Last active October 24, 2019 18:08
public void ConfigureServices(IServiceCollection services)
{
services.AddControllersWithViews();
services.AddDbContext<MercuryContext>(options =>
options.UseNpgsql(Configuration.GetConnectionString("MercuryContext"))
);
}
{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft": "Warning",
"Microsoft.Hosting.Lifetime": "Information"
}
},
"AllowedHosts": "*",
"ConnectionStrings": {
# dockerfile-postgres.yml
version: '3.1'
services:
db:
image: postgres
restart: always
environment:
POSTGRES_DB: Mercury