Home » SQL & PL/SQL » SQL & PL/SQL » sql basic questions
sql basic questions [message #192613] Wed, 13 September 2006 00:24 Go to next message
Messages: 138
Registered: October 2005
Location: chennai
Senior Member
Hi friends,

I have some basic doubts , I think only u guys can clear it.

1. what is difference between IS and AS when we create a procedure ,anyway there will be some difference right...

2.Creating a table with datatype of INTEGER and NUMBER
if i give integer ,it takes as a NUMBER(38).
any other diff in oracle.

3.while creating constraints,it s always showing constriant type is C , it wont show U-unique and P-primary..

Kindly share ur idea

Re: sql basic questions [message #192660 is a reply to message #192613] Wed, 13 September 2006 03:24 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
1) No difference between them. Use whichever makes you feel happier.

2) The main difference is that you can't put decimal values into an integer column. If you look in USER_TAB_COLUMNS for the integer column, you'll see that the SCALE (number of allowable dps) is zero for the integer.

3) I suspect that you are using some tool to describe tables to you, and it is just showing the column level check constraints. If you could let us know what you are actually doing, we might be able to help.
Previous Topic: how to import.....
Next Topic: using analytic function
Goto Forum:

Current Time: Fri Oct 21 06:26:32 CDT 2016

Total time taken to generate the page: 0.07707 seconds