Deepthi Bittu
Last Activity: May 9 '11, 10:27 AM
Joined: Mar 22 '11
Location:
-
Deepthi Bittu started a topic how to set default value for column of new created table from select statement in 11gin Oraclehow to set default value for column of new created table from select statement in 11g
I create a table in oracle 11g with the default value for one of the columns. Systax is "create table xyz(emp number,ename varchar2(100),s alary number default 0);". This created successfully. For some reasons I need to create another table with same old table structure and data. So i created a new table with name "abc" as "create table abc as select * from xyz". Here "abc" created successfully with same structure... -
Deepthi Bittu started a topic Increase the length of the table_name cloumn in USER_TAB_COLUMNS tablein OracleIncrease the length of the table_name cloumn in USER_TAB_COLUMNS table
I am migrating the data structure from MS SQL SERVER to ORACLE 11g database. The length of the table names,column names and key names are big in length in MS SQL SERVER. But, when i am migrating the data structure to oracle, the tables and its columns and keys are not creating because as you all know in oracle table name accepts only 30 characters/bytes and column names and key names too.This we can check from DESC all_tab_columns or DESC USER_TAB_COLUMN S....
No activity results to display