d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Oracle 11g Is Pissing Me Off Y'all. > Table Name Length Truncated.
Prev123Next
Add Reply New Topic New Poll
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
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 :evil:

This post was edited by carteblanche on Mar 2 2014 09:56pm
Member
Posts: 35,456
Joined: Jan 25 2009
Gold: 1,173.00
Mar 2 2014 10:03pm
I knew it was cascade but i didnt know how to write it.
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
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
Member
Posts: 1,995
Joined: Jun 28 2006
Gold: 7.41
Mar 2 2014 10:14pm
Quote (carteblanche @ Mar 2 2014 11:06pm)
you are a disgrace to CHD.


Coronary Heart Disease?

Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
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
Member
Posts: 35,456
Joined: Jan 25 2009
Gold: 1,173.00
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
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
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
Member
Posts: 1,995
Joined: Jun 28 2006
Gold: 7.41
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.
Member
Posts: 35,456
Joined: Jan 25 2009
Gold: 1,173.00
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.
Member
Posts: 11,637
Joined: Feb 2 2004
Gold: 434.84
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
Prev123Next
Add Reply New Topic New Poll