☰
d2jsp
Rules
Help
Forum Gold FAQ
Live Streams
Photo Gallery
Hourly Raffle
Ladder Slasher
Log In
Register
Log In
Register
Account Recovery
Resend Validation Email
d2jsp Forums
>
Off-Topic
>
Computers & IT
>
Programming & Development
> Oracle 11g Is Pissing Me Off Y'all. > Table Name Length Truncated.
Prev
1
2
3
Next
Add Reply
New Topic
New Poll
Views: 3155
Replies: 21
Track Topic
carteblanche
Member
Posts: 32,925
Joined: Jul 23 2006
Gold
:
3,804.50
#11
Mar 2 2014 09:55pm
they want you to delete cascade
http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php
Quote
Maybe you can help before I put my fist through my computer monitors.
on second thought, maybe i'll wait a bit longer to help
This post was edited by carteblanche on Mar 2 2014 09:56pm
NinjaSushi
Member
Posts: 35,456
Joined: Jan 25 2009
Gold
:
1,173.00
#12
Mar 2 2014 10:03pm
I knew it was cascade but i didnt know how to write it.
carteblanche
Member
Posts: 32,925
Joined: Jul 23 2006
Gold
:
3,804.50
#13
Mar 2 2014 10:06pm
Quote (NinjaSushi2 @ Mar 2 2014 11:03pm)
I knew it was cascade but i didnt know how to write it.
you are a disgrace to CHD.
step 1 -> go to www.google.com
step 2 -> type in oracle delete cascade in the search bar
step 3 -> i'm feeling lucky
Minkomonster
Member
Posts: 1,995
Joined: Jun 28 2006
Gold
:
7.41
#14
Mar 2 2014 10:14pm
Quote (carteblanche @ Mar 2 2014 11:06pm)
you are a disgrace to CHD.
Coronary Heart Disease?
carteblanche
Member
Posts: 32,925
Joined: Jul 23 2006
Gold
:
3,804.50
#15
Mar 2 2014 10:17pm
Quote (Minkomonster @ Mar 2 2014 11:14pm)
Coronary Heart Disease?
Children who Have Down syndrome
Computer Hardware Discussion forum. everyone there can google problems
NinjaSushi
Member
Posts: 35,456
Joined: Jan 25 2009
Gold
:
1,173.00
#16
Mar 2 2014 10:31pm
Quote (carteblanche @ 2 Mar 2014 23:17)
Children who Have Down syndrome
Computer Hardware Discussion forum. everyone there can google problems
Meh. I was googling the wrong stuff.
Edit: I must be fucking tired or something because I just found it in my book.
Quote
Code
ALTER TABLE orders
ADD CONSTRAINT orders_customer#_fk FOREIGN KEY (customer#)
REFERENCES customers (customer#) ON DELETE CASCADE;
#FML
This post was edited by NinjaSushi2 on Mar 2 2014 10:32pm
carteblanche
Member
Posts: 32,925
Joined: Jul 23 2006
Gold
:
3,804.50
#17
Mar 2 2014 10:36pm
Quote (NinjaSushi2 @ Mar 2 2014 11:31pm)
Meh. I was googling the wrong stuff.
Edit: I must be fucking tired or something because I just found it in my book.
#FML
#RTFM
on a more serious note, you should try doing assignments a few days early. if you get frustrated like today, then you could go to sleep and look at it the next day with fresh eyes. you'll often find it's much easier than you first thought
Minkomonster
Member
Posts: 1,995
Joined: Jun 28 2006
Gold
:
7.41
#18
Mar 2 2014 10:51pm
Quote (carteblanche @ Mar 2 2014 11:36pm)
#RTFM
on a more serious note, you should try doing assignments a few days early. if you get frustrated like today, then you could go to sleep and look at it the next day with fresh eyes. you'll often find it's much easier than you first thought
That and I belive the first hour after you wake up is prime time for studying. Brain is full active ready for input parsing. Cramming the night before is detrimental. Always better to get a full night's sleep and then gloss over notes the following morning.
NinjaSushi
Member
Posts: 35,456
Joined: Jan 25 2009
Gold
:
1,173.00
#19
Mar 3 2014 01:06am
That is very true and I have recently realized it. I'm just behind due to a string of unfortunate events the past few weeks. Back to homework.
rockonkenshin
Member
Posts: 11,637
Joined: Feb 2 2004
Gold
:
434.84
#20
Mar 3 2014 06:56am
Fuck, I must have slept through this thread. Yeah, cascade delete was the answer and if you can I would definitely use SQLDeveloper just so you don't have to fuck around with output formatting every time you start SQL*PLUS.
Go Back To
Programming & Development
Topic List
Prev
1
2
3
Next
Add Reply
New Topic
New Poll
© 2003-2026 d2jsp
Contact