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

German- Intermediate

PatrickNoonan

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 over 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

BIOLOGY B1 4

x_clairey_x

CHEMISTRY C1 4

x_clairey_x

GCSE Biology, Module B4

jessmitchell

TOEFL Practice

aliking

A-level Psychology Revision

philip.ellis

GCSE AQA Chemistry - Unit 2

James Jolliffe

GCSE REVISION TIMETABLE

Joana Santos9567

1PR101 2.test - Část 1.

Nikola Truong

Specific topic 7.5 Timber (Stock forms)

T Andrews

General Pathoanatomy Final MCQs (401-519)- 3rd Year- PMU

Med Student

Browse Library