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

A2 Geography- Energy Security

sophielee0909

Copy and Edit

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

	Created by Léo Zimmer about 11 years ago

(0)

Resource summary

Oracle SQL Fundamental

COMANDOS
1. DML
  1. SELECT INSERT UPDATE DELETE MERGE
    1. Select é DML mas não modifica dados
2. DDL
  1. CREATE ALTER DROP RENAME TRUNCATE COMMENT
3. DCL
  1. GRANT REVOKE
4. TCL
  1. COMMIT ROLLBACK SAVEPOINT
ESTRUTURA RELACIONAL
1. 3a.Forma Normal é a modelagem adequada para o processamento
2. Diagrama Relacional é BI-Dimensional
3. NUMBER(8,2) aceita no máximo 8
4. Uma coluna VARCHAR(30) pode receber dados de uma coluna VARCHAR(50)
LINGUAGEM SQL
1. Não possui interator DO..WHILE, FOR..NEXT, IF..THEN..ELSE
2. COMANDOS
  1. LIKE aceita % e _ (_ ignora o caracter na posição) ESCAPE

Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

To join the discussion, please sign up for a new account or log in with your existing account.

Want to create your own Mind Maps for free with GoConqr? Learn more.

Similar

CHEMISTRY C1 4

x_clairey_x

Year 11 Psychology - Intro to Psychology and Research Methods

stephanie-vee

FCE Opposites Practice

miminoma

Cells - Biology AQA B2.1.1

benadyl10

Hitler's Chancellorship

c7jeremy

Evolution

rebeccachelsea

BELIEVING IN GOD- UNIT 1, SECTION 1- RELIGIOUS STUDIES GCSE EDEXCEL

Khadijah Mohammed

Musical Terms

Abby B

AQA GCSE Product Design Questions

Bella Statham

Examen nefrologie partea 1

Dan Croitoru

Browse Library