Home / Software / Computer programming / oracle
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] - (Bottom) Print
Author Topic: oracle  (Read 551 times)
ragini
Topic Starter
Greenhorn



Posts: 5


« on: September 04, 2010, 09:27:14 AM »

hi
could u please tell me when we create a table in oracle and if table is already exists then what type of error should it displayed,? actualy i want exactly error message..
IP logged
jonirock
Newbie



Posts: 1

Experience: Beginner
OS: Unknown

« Reply #1 on: September 25, 2010, 10:59:08 PM »

Usually, if we refer to tables, we mean heap tables, although there are other types as well.
A heap table is created like this:
create table t (
  a number,
  b varchar2(10)
)

It is possible to create the constraints together with the create statement. As a foreign key references a known type, it is not necessary to specify the foreign key's column type.
create table orders (
  order_id   number primary key
  order_dt   date,
  cust_id    references customers
)




PA health plans | Health Insurance Pittsburgh PA

IP logged
banana_crazeeee
Newbie



Posts: 2

Experience: Beginner
OS: Unknown

« Reply #2 on: October 22, 2010, 11:48:38 AM »

I am not sure if my computer drivers are up to date.  I am having issues with yahoo game rooms/ games.  When in a card game or dominoes when I click on a card or domino - my screen flickers/ flashes or goes to the bottom of my screen.  I constantly get kicked out of the game rooms several times while in a game.  Anybody know why this is happening and what I can do to fix it?  I have cc cleaner and have ran it.  Also I have ad-aware and avg.
IP logged
Pages: [1] - (Top) Print 
Home / Software / Computer programming / oracle « previous next »
 


Login with username, password and session length

Old Forum Search | Forum Rules
Copyright © 2010 Computer Hope ® All rights reserved.
Powered by SMF 2.0 RC3 | SMF © 2006–2010, Simple Machines LLC
Page created in 0.097 seconds with 20 queries.