Editing SH.PRODUCTS (table)

Jump to: navigation, search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
Line 21: Line 21:
 
|- valign="top"
 
|- valign="top"
 
| PROD_ID
 
| PROD_ID
−
| NUMBER(6, 0)
+
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
Line 27: Line 27:
 
|- valign="top"
 
|- valign="top"
 
| PROD_NAME
 
| PROD_NAME
−
| VARCHAR2(50)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 33: Line 33:
 
|- valign="top"
 
|- valign="top"
 
| PROD_DESC
 
| PROD_DESC
−
| VARCHAR2(4000)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 39: Line 39:
 
|- valign="top"
 
|- valign="top"
 
| PROD_SUBCATEGORY
 
| PROD_SUBCATEGORY
−
| VARCHAR2(50)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 51: Line 51:
 
|- valign="top"
 
|- valign="top"
 
| PROD_SUBCATEGORY_DESC
 
| PROD_SUBCATEGORY_DESC
−
| VARCHAR2(2000)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 57: Line 57:
 
|- valign="top"
 
|- valign="top"
 
| PROD_CATEGORY
 
| PROD_CATEGORY
−
| VARCHAR2(50)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 69: Line 69:
 
|- valign="top"
 
|- valign="top"
 
| PROD_CATEGORY_DESC
 
| PROD_CATEGORY_DESC
−
| VARCHAR2(2000)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 75: Line 75:
 
|- valign="top"
 
|- valign="top"
 
| PROD_WEIGHT_CLASS
 
| PROD_WEIGHT_CLASS
−
| NUMBER(3, 0)
+
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
Line 81: Line 81:
 
|- valign="top"
 
|- valign="top"
 
| PROD_UNIT_OF_MEASURE
 
| PROD_UNIT_OF_MEASURE
−
| VARCHAR2(20)
+
| VARCHAR2
 
| null
 
| null
 
|  
 
|  
Line 87: Line 87:
 
|- valign="top"
 
|- valign="top"
 
| PROD_PACK_SIZE
 
| PROD_PACK_SIZE
−
| VARCHAR2(30)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 93: Line 93:
 
|- valign="top"
 
|- valign="top"
 
| SUPPLIER_ID
 
| SUPPLIER_ID
−
| NUMBER(6, 0)
+
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
Line 99: Line 99:
 
|- valign="top"
 
|- valign="top"
 
| PROD_STATUS
 
| PROD_STATUS
−
| VARCHAR2(20)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 105: Line 105:
 
|- valign="top"
 
|- valign="top"
 
| PROD_LIST_PRICE
 
| PROD_LIST_PRICE
−
| NUMBER(8, 2)
+
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
Line 111: Line 111:
 
|- valign="top"
 
|- valign="top"
 
| PROD_MIN_PRICE
 
| PROD_MIN_PRICE
−
| NUMBER(8, 2)
+
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
Line 117: Line 117:
 
|- valign="top"
 
|- valign="top"
 
| PROD_TOTAL
 
| PROD_TOTAL
−
| VARCHAR2(13)
+
| VARCHAR2
 
| not null
 
| not null
 
|  
 
|  
Line 135: Line 135:
 
|- valign="top"
 
|- valign="top"
 
| PROD_EFF_FROM
 
| PROD_EFF_FROM
−
| DATE(7)
+
| DATE
 
| null
 
| null
 
|  
 
|  
Line 141: Line 141:
 
|- valign="top"
 
|- valign="top"
 
| PROD_EFF_TO
 
| PROD_EFF_TO
−
| DATE(7)
+
| DATE
 
| null
 
| null
 
|  
 
|  
Line 147: Line 147:
 
|- valign="top"
 
|- valign="top"
 
| PROD_VALID
 
| PROD_VALID
−
| VARCHAR2(1)
+
| VARCHAR2
 
| null
 
| null
 
|  
 
|  

Please note that all contributions to dbscript Online Help may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see Project:Copyrights for details). Do not submit copyrighted work without permission!

Cancel | Editing help (opens in new window)
Retrieved from "http://dbshelp.devio.at/index.php/SH.PRODUCTS_(table)"