| CHECK CONSTRAINT - HARD FOR ME, EASY FOR YOU [message #374283] |
Mon, 04 June 2001 10:30 |
LEVIATHAN
Messages: 8
Registered: June 2001
|
Junior Member |
|
|
I'M NEW TO SQL ORACLE, I HAVE 2 PROBLEMS
FIRSTLY, IS THERE A WAY WHEN CREATING A DATA TYPE SO THAT THE FIRST 3 CHARACTERS ARE NUMBER AND THE LAST 3 CHARCTERS ARE LETTERS, WITHOUT EXCEPTIONS.
IE. 999BUS
SECONDLY I WANT TO CREATE A CONSTRAINT SO THAT A DATE CAN ONLY BE AFTER A CERTAIN DATE AND BEFORE THE PRESENT DATE. I SUSPECT IT USES CHECK BUT I CANT QUITE GET IT RIGHT.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
