null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
577610
Oracle SQL Fundamental
Description
Mind Map on Oracle SQL Fundamental, created by Léo Zimmer on 24/02/2014.
Mind Map by
Léo Zimmer
, updated more than 1 year ago
More
Less
Created by
Léo Zimmer
about 10 years ago
79
1
0
Resource summary
Oracle SQL Fundamental
COMANDOS
DML
SELECT INSERT UPDATE DELETE MERGE
Select é DML mas não modifica dados
DDL
CREATE ALTER DROP RENAME TRUNCATE COMMENT
DCL
GRANT REVOKE
TCL
COMMIT ROLLBACK SAVEPOINT
ESTRUTURA RELACIONAL
3a.Forma Normal é a modelagem adequada para o processamento
Diagrama Relacional é BI-Dimensional
NUMBER(8,2) aceita no máximo 8
Uma coluna VARCHAR(30) pode receber dados de uma coluna VARCHAR(50)
LINGUAGEM SQL
Não possui interator DO..WHILE, FOR..NEXT, IF..THEN..ELSE
COMANDOS
LIKE aceita % e _ (_ ignora o caracter na posição) ESCAPE
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
Transforming Graphs
james_hobson
GCSE Biology AQA
isabellabeaumont
Tipologia Textual
Rodrigo Vinicius Ferreira da Silva
med chem 2
lola_smily
Geography AQA Revison topics Migration, Population Change, Youthful Populations and more
dburns8731
Business Studies GCSE
phil.ianson666
GCSE REVISION TIMETABLE
Joana Santos9567
AQA Physics: A2 Unit 4
Michael Priest
AS Sociology - Education Theories
HannahLB
C Programming
Miki Rana
Primary School Mathematics
lara.greenberg
Browse Library