Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
create table with check constraint rule in oracl
This is a discussion on create table with check constraint rule in oracl within the Oracle forums, part of the Databases category; i have table with Phone column with char data type, the phone column must be of same format (####)-######. Hence create a Rule by name Rule_Phone and bind the rule ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
11-08-2008
|
|||
|
|||
|
create table with check constraint rule in oracl
i have table with Phone column with char data type, the phone column must be of same format (####)-######. Hence create a Rule by name Rule_Phone and bind the rule to phone columns of all tables.
Check the above by inserting i. 234-2372727 ii. (0821)-2404021 into the phone columns of the table 
|
| Sponsored Links |
|
11-09-2008
|
|||
|
|||
|
Re: create table with check constraint rule in oracl
check constraints ,check for values not formats.
|
|
11-14-2008
|
|||
|
|||
|
Re: create table with check constraint rule in oracl
Try this
CREATE TABLE pp(phone VARCHAR2(13) CONSTRAINT pp_check CHECK( INSTR(SUBSTR(phone,6,1),')') >0 AND INSTR(SUBSTR(phone,1,1),'(') >0 AND INSTR(SUBSTR(phone,7,1),'-') >0 AND TO_NUMBER(REPLACE(REPLACE(REPLACE(phone,')',0),'(',0),'-',0))>0) ); Quote:
__________________
Sireesha
|
| The Following User Says Thank You to susarlasireesha For This Useful Post: | ||
|
03-30-2009
|
|||
|
|||
Re: create table with check constraint rule in oracl
try this
create table t1(phone varchar2(15) constraint pk_check check(translate(phone,' -0123456789()',' '));
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create a table in excel | demo676 | WinRunner | 1 | 02-13-2008 09:08 AM |
| Create same table | JobHelper | Database General | 5 | 08-07-2007 01:03 PM |
| Check the company code entry xxxx in the table 169p | nsymphony | SAP R/3 | 0 | 07-23-2007 11:13 PM |
| Can you create internal table dynamically | Geek_Guest | SAP R/3 | 0 | 07-19-2007 09:55 AM |
| Check Constraint | christia | SQL | 2 | 07-30-2006 07:16 PM |
All times are GMT -4. The time now is 02:56 AM.
