Existing user? Sign in
Sign up
Games
Servers
Useful
User
Pass
2FA
iacademy3 oracle
Freakz Forum Index
->
Trash Bin
->
Trash
->
Homework zone
Author
Message
3166
DirtyShirt
[Banned user]
Status: Offline
(since 06-10-2015 17:38)
Joined: 25 Nov 2014
Posts: 144
,
Topics: 25
Location:
Romania
Reputation:
22.8
Votes
: 3
Posted: 09-05-2015, 09:12:49
| Translate post to:
... (
Click for more languages
)
Salutare, vreun cunoscator de oracle pe aici? Marti trebuie sa sustin un atestat si am cam uitat anumite functii oracle (m-am concentrat asupra proiectului in powerpoint mai mult). Poate cineva sa-mi explice cum sta treaba cu functiile update si delete? Cum se apeleaza? As vrea un raspuns rapid caci ma cam grabesc. Multumesc anticipat.
0
0
Back to top
HarDer123
[The Addict]
Status: Offline
(since 27-10-2023 10:49)
Joined: 24 Apr 2010
Posts: 10133
,
Topics: 132
Location:
trag in piept aerul jegos de bucuresti :]
Reputation:
1748.3
Votes
: 117
Posted: 09-05-2015, 12:29:46
| Translate post to:
... (
Click for more languages
)
Comenzi DML (Data Manipulation Language
; limbaj de manipulare a datelor)
Comanda - Scop
SELECT - Regãseºte înregistrãri în tabele sau vederi;
DELETE - ªterge înregistrãri din tabele;
INSERT - Adaugã o nouã înregistrare in tabelã;
UPDATE - Modificã valorile unor înregistrãri din tabele;
MERGE - Adaugã un tuplu(cuplu) in funcþie de o anumitã condiþie.
Ce atestat ai de prezentat mai exact,care este tema?
Îþi pot face un sql care,odata importat in contul de ilearning, sã-þi creeze automat tabelele dacã ai probleme cu chestia asta.
ex:
Spoiler:
Code:
CREATE TABLE "ANGAJAT"
(
"ID_ANGAJAT" NUMBER(9,0) NOT NULL ENABLE,
"NUME" VARCHAR2(20) NOT NULL ENABLE,
"PRENUME" VARCHAR2(20) NOT NULL ENABLE,
"TELEFON" VARCHAR2(20) NOT NULL ENABLE,
"SALARIU" NUMBER(5,0) NOT NULL ENABLE,
"DATA_NASTERE" DATE NOT NULL ENABLE,
"ADRESA" VARCHAR2(100) NOT NULL ENABLE,
"LOCALITATE" VARCHAR2(30) NOT NULL ENABLE,
"CODPOSTAL" VARCHAR2(6) NOT NULL ENABLE,
CONSTRAINT "ANGAJAT_PK" PRIMARY KEY ("ID_ANGAJAT") ENABLE
)
0
0
Back to top
DirtyShirt
[Banned user]
Status: Offline
(since 06-10-2015 17:38)
Joined: 25 Nov 2014
Posts: 144
,
Topics: 25
Location:
Romania
Reputation:
22.8
Votes
: 3
Posted: 09-05-2015, 13:15:41
| Translate post to:
... (
Click for more languages
)
la atestat am de prezentat un proiect in powerpoint despre gestiunea unui magazin de casete video (la asta m-am descurcat). dar pe langa proiect mai am de facut 3 probleme:una de c++, una de oracle si una de creat niste fisiere pe desktop (chestii esentiale). eu ma incurc la problemele de oracle ca nu mai stiu cum era cu clauzele delete si update.
0
0
Back to top
HarDer123
[The Addict]
Status: Offline
(since 27-10-2023 10:49)
Joined: 24 Apr 2010
Posts: 10133
,
Topics: 132
Location:
trag in piept aerul jegos de bucuresti :]
Reputation:
1748.3
Votes
: 117
Posted: 09-05-2015, 13:38:16
| Translate post to:
... (
Click for more languages
)
Cred cã te referi la CRUD Analysis a ERDului.
C
RUD
- INPUT, ENTER, LOAD, IMPORT, RECORD, & CREATE
C
R
UD
-VIEW, LOOK UP, BRING UP, FIND , PRINT, READ, & REPORT
CR
U
D
- CHANGE, MODIFY, ALTER, & UPDATE
CRU
D
- DISCARD, REMOVE, TRASH, PURGE, & DELETE
Cred cã ºtii ce e ãla un erd, deci delete & update o sã-þi foloseascã doar la erd .
Media de obþinere a atestatului este minim 7 (se calculeaza cu nota de la atestatul propriu zis + notele de la cele 3 probe ).În caz cã nu te descurci la problema de sql nu te panica, încearcã sa faci bine proba de c++ ºi cea de microsoft office ºi o sã iei atestatul (atestat care oricum nu prea te ajutã cu nimic cã expirã dupã un an
).
0
0
Back to top
DirtyShirt
[Banned user]
Status: Offline
(since 06-10-2015 17:38)
Joined: 25 Nov 2014
Posts: 144
,
Topics: 25
Location:
Romania
Reputation:
22.8
Votes
: 3
Posted: 10-05-2015, 10:36:42
| Translate post to:
... (
Click for more languages
)
HarDer123 wrote:
atestat care oricum nu prea te ajutã cu nimic cã expirã dupã un an
.
profesoara ne-a spus ca atestatul e permanent
0
0
Back to top
PsychoLove
[Silence In The Snow]
Status: Offline
(since 05-01-2024 17:19)
Joined: 12 Aug 2013
Posts: 5177
,
Topics: 299
Location:
Behind you.
Reputation:
1306.4
Votes
: 480
Posted: 10-05-2015, 12:18:30
| Translate post to:
... (
Click for more languages
)
Din câte ºtiu este permanent, acum probabil depinde de tipul lui. Dacã profesoara aºa v-a zis, înseamnã cã aºa este.
Dreams.. That's all we have.
0
0
Back to top
DirtyShirt
[Banned user]
Status: Offline
(since 06-10-2015 17:38)
Joined: 25 Nov 2014
Posts: 144
,
Topics: 25
Location:
Romania
Reputation:
22.8
Votes
: 3
Posted: 10-05-2015, 14:51:48
| Translate post to:
... (
Click for more languages
)
Oricum am mai intampinat niste probleme la exercitiile de word si sper ca puteti sa ma ajutati (stiu ca e offtopic, dar incerc sa mentin curatenie aici, sa nu fac n! topicuri). Cum numerotez paginiile pare la stanga la footer si cele impare la dreapta tot in footer? Cum inserez pt paginiile pare numele documentului si pt cele impare numele autorului? Cum as putea seta decat pentru o singura pagina fontul Courier?
0
0
Back to top
Topic locked
Topic is closed, you cannot post any messages in it anymore
Locked by
PsychoLove
, 29 December 2015 19:00
Freakz Forum Index
->
Trash Bin
->
Trash
->
Homework zone
The time now is 19-04-2024, 07:39:15
Copyright info
Based on phpBB
ro
/
com
B
Login
I forgot my password
World of Warcraft
Login for more...
Download WoW 7.3.5
Misc
eSports
Achievements
Buy reputation with votes
Reputation trades
Forum rules
Ban list
Members list
User guide (FAQ)
World of Warcraft
View details