Loading [MathJax]/jax/output/HTML-CSS/fonts/TeX/fontdata.js

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

OCR GATEWAY CHEMISTRY C1 TEST

Olivia Farrow

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

Cells, Tissues and Organs

yusanr98

CHEMISTRY C1 4

x_clairey_x

Hitler's Chancellorship

c7jeremy

Of Mice and Men Quotes

_Jess_

PuKW - STEP 1 (mögliche Prüfungsfragen/Prüfungsvorbereitung)

Steven Lee

Financial Statements

Sharon Yates

Prep Like a Pro with GoConqr's Revision Timetable

Mike Nervo

DNA Basics

Sarah Juliette B

Types of Learning Environment

Brandon Tuyuc

10 Ways to Improve Your Productivity

Rebecca Tarpey

Browse Library