Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL> select * 2 from book;

Status
Not open for further replies.

props

Technical User
Nov 22, 2003
17
GB
SQL> select *
2 from book;

BOK_ISBN BOK_TITLE BOK_DATE BOK_EDIT BOK_TYPE BOK_AUTH
---------- ------------------ --------- -------- ------------ ------------
PU_ID
----------
333645510 Comp Architecture 03-AUG-99 Fifth Algorithms B.S Chalk
1

789548455 C++ for beginners 04-JUN-03 Nineth Programming T.Gordon
1

any idea how this table to look better
i used smallint but doesn't work, the PU_ID column comes undernith .

this is the table:

create table book(Bok_ISBN smallint not null,
Bok_Title varchar(18),
Bok_Date date,
Bok_Edit varchar(8),
Bok_Type varchar(12),
Bok_Auth varchar(12),
Pu_ID smallint,
primary key (Bok_ISBN),
foreign key (Pu_ID) references publisher(Pu_ID));
Thank You
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top