SQL / Oracle

[EVB]

Anyone ever used this before?

Doing uni assignment, and looking at the entity relationship model, I have 11 feet on the entities. Does that mean I have to have 11 foreign keys?

Thanks

[Andy_SRi]

I manage ms sql servers? :| :lol:

Dont know how that helps just thought i'd say :look:

[EVB]

You ever created foreign keys then :lol:

[Andy_SRi]

hmm kinda had to create keys when setting up replication, im not a db person though I just make it work when the developers f*ck everything up (every other day)

[EVB]

Well thats poo.

[Andy_SRi]

you see if you woulda put me on your list of people to meet :cry: I might of gone looking for the answer

[EVB]

:cry:

[gonkowonko]

foriegn keys are links to primary keys in another table

if you need any help drop me a pm as i design databases in MS SQL access and Oracle for a living ;)

[EVB]

Nice one :)

[Duna]

I use a program called Oracle at work and its fooking ****e!

[gonkowonko]

Oracle is the best database system in the world only problem is to use it effectly you have to program it and set it all up in SQL ;)

[Andy_SRi]

aye oracle is the dogs danglies....

Just an arseache to sort out properly as gary said.

[Duna]

Everyone in our company hates oracle with a passion - ive only met one person who likes it! I think we use oracle discoverer and oracle viewer

[Keith]

Everyone in our company hates oracle with a passion - ive only met one person who likes it! I think we use oracle discoverer and oracle viewer

i use oracle and discoverer!

[gonkowonko]

i use sql plus :) love it

[Andy_SRi]

I use ms sql server 2000 stnd and ent edition :| all nice n easy :lol:

[gonkowonko]

use that too only cause our IT department are afraid of the oracle server :P

[EVB]

All done :)

Thanks Gaz :)

[Andy_SRi]

use that too only cause our IT department are afraid of the oracle server :P


I stick by microsoft stuff...... Cos it breaks and keeps me in a job :lol:

[gonkowonko]

No worries mate ;)

Yeah it does tend to always break!!!! but its normally down to the user ;)

[Andy_SRi]

Yup *looks over at developers*

[Duna]

Quote:
Originally Posted by Duna
Everyone in our company hates oracle with a passion - ive only met one person who likes it! I think we use oracle discoverer and oracle viewer


i use oracle and discoverer!


Im not alone then!!!

[andym765]

I use oracle software :)

[gonkowonko]

see andy u know oracle is far superior

:P

[Si]

I use Oracle for a few years at uni too :)

[Andy_SRi]

see andy u know oracle is far superior

:P


Erm yeah......



.....but dodgy m$ products pay my wages :D

[EVB]

You dont need to drop the keys individually do you?

Just drop the tables in correct order?

[pussy-galor]

haven't got a clue but if it is what i think it is then yes i have used oracle....used to work for a mobile phone supplier.....i think i may of confused myself :?

[gonkowonko]

You dont need to drop the keys individually do you?

Just drop the tables in correct order?

Explain a little more please as i dont understand what u mean??

U trying to delete talbles?

[EVB]

Yeh, DROP TABLE TITLE;

For example, I dont have to delete all PK/FK seperately do I?

[gonkowonko]

yep just drop the table with the foreign keys first then drop the others :thumbs:

as u said drop table ........

[CraigM]

I use both SQL and Oracle. :thumbs:

[EVB]

This is gay :lol:

Gotta get this in Wednesday :(

Having problems creating object types

CREATE OR REPLACE TYPE Contact_Details As OBJECT(
Landline VarChar2(12),
Mobile_Phone VarChar2(12),
Fax VarChar2(12),
Work_Phone VarChar2(12))
/

CREATE OR REPLACE TYPE Address As OBJECT(
House_Number VarChar2(4),
Street_Name VarChar2(18),
Town VarChar2(20),
County VarChar2(25),
Postcode VarChar2(10))
/

CREATE TABLE Member(
Member_ID VarChar2(25),
FirstName VarChar2(15),
FamilyName VarChar2(25),
Address REF object_type_name SCOPE IS object_table_name,
Contact_Detail REF object_type_name SCOPE IS object_table_name);

Basically Address and Contact_Details are object tables, and Member is a normal table, with these two objects as columns.

What is the object_type_name * object_table_name in Member table?

LOST :(