 Problem while Modifying column data type [message #623067] |
Thu, 04 September 2014 01:25  |
 |
mastansky@gmail.com
Messages: 13
Registered: July 2013
Location: INDIA
|
Junior Member |
|
|
I have two tables like Samp1(Parent Table) and Samp2 (Child table)
Parent Table :Samp1
column Datatype Constraint
------------------------------
Id Number(6) Primary Key
Child table :Samp2
column Datatype Constraint
------------------------------
Id Number(6) Foriegn Key
Then how to modify column data type Number to Varchar2(10) both parent and child table at a time, can I one share Your Ideas Please .
Lalit : Added code tags. From next time please do it yourself, read How to use [code] tags
You could simply do DESC table_name in SQL*Plus instead of typing the table description.
[Updated on: Thu, 04 September 2014 02:31] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
