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'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 3.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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; | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE descontos | |
( | |
escalao NUMBER(2) PRIMARY KEY , | |
salinf NUMBER(7) NOT NULL, | |
salsup NUMBER(7) NOT NULL | |
); | |
CREATE TABLE dep | |
( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public void ConfigureServices(IServiceCollection services) | |
{ | |
services.AddControllersWithViews(); | |
services.AddDbContext<MercuryContext>(options => | |
options.UseNpgsql(Configuration.GetConnectionString("MercuryContext")) | |
); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"Logging": { | |
"LogLevel": { | |
"Default": "Information", | |
"Microsoft": "Warning", | |
"Microsoft.Hosting.Lifetime": "Information" | |
} | |
}, | |
"AllowedHosts": "*", | |
"ConnectionStrings": { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# dockerfile-postgres.yml | |
version: '3.1' | |
services: | |
db: | |
image: postgres | |
restart: always | |
environment: | |
POSTGRES_DB: Mercury |