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
over 10 years ago
80
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
A-Level Physics: Course Overview
cian.buckley+1
Biology Unit 1
hannahsanderson1
Plant Structure and Photosynthesis
Evangeline Taylor
Forces and their effects
kate.siena
New Possibilities with ExamTime's Flashcard Maker
Andrea Leyden
GCSE AQA Citizenship Studies: Theme 1
I Turner
OCR AS Biology
joshbrown3397
Animal Farm Chapter Overview
10jgorman
Key Biology Definitions/Terms
jane zulu
Input, output and storage devices
Mr A Esch
GCSE Maths: Algebra & Number Quiz
Andrea Leyden
Browse Library