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
Themes in Lord of the Flies
lowri_luxton
HSC Maths: Algebra Quiz
Brad Hegarty
An Inspector Calls: Mrs Sybil Birling
Rattan Bhorjee
An Inspector Calls: Sheila Birling
Rattan Bhorjee
GCSE Science - B1 - You and Your Genes - Genes, Chromosomes and DNA
GeorgeHaines
GCSE REVISION TIMETABLE
neharaniga
Navegacion
Adriana Forero
Macbeth Quotes/Themes
Michael LEwis
The GoConqr Guide to End of Term Exams
Sarah Egan
A Christmas Carol (Key Quotes)
Samira Choudhury
Unit 1.1 Systems Architecture
Mathew Wheatley
Browse Library