Home » SQL & PL/SQL » SQL & PL/SQL » Integer number type
Integer number type [message #274322] Mon, 15 October 2007 10:17 Go to next message
tech291083
Messages: 3
Registered: October 2007
Junior Member
Hi,

I am trying to make a small table in Oracle with the following columns

BookID - Only intergers and positives only -Primary key
BookTitle - Characters
PublisherName - Characters

Can any one please give me the right sql syntax for this? Thanks.
Re: Integer number type [message #274323 is a reply to message #274322] Mon, 15 October 2007 10:22 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
The homework forum is down near the bottom of this page.
Re: Integer number type [message #274324 is a reply to message #274322] Mon, 15 October 2007 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE TABLE
If you can't do it with that, post you try and why it fails.

Regards
Michel
Re: Integer number type [message #274794 is a reply to message #274322] Wed, 17 October 2007 03:02 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Also look at DataTypes
Previous Topic: drop all tables belong to a user
Next Topic: SQL Query doubt
Goto Forum:
  


Current Time: Sun Dec 04 08:46:46 CST 2016

Total time taken to generate the page: 0.07298 seconds