Fellow Bobber's come on in. This is a community site to ask and share your knowledge about almost anything.
HomePortalCalendarGalleryFAQSearchMemberlistUsergroupsRegisterLog in

Share | 

 test blog only

Go down 

Posttest blog only

test blog only
set linesize 400
set heading off
set pagesize 9999
select column_name
,(case when (data_type='CHAR' or data_type='VARCHAR2')
then ','||lower(column_name)||' '||'position('||start_pos||':'||end_pos||')'
when data_type='NUMBER'
then ','||lower(column_name)||' '||'position('||start_pos||':'||end_pos||')
integer external defaultif ('||st!art_pos||':'||end_pos||')=blanks'
when data_type='DATE'
then ','||lower(column_name)||' '||'position('||start_pos||':'||end_pos||') date nullif
('||start_pos||':'||end_pos||')=blanks' end) as scr
from (select column_name, data_type, len, ((end_pos-len)+1) as start_pos, end_pos
from (select column_name, data_Type, len, sum(len) over (order by column_id) as end_pos
from (select column_name
,substr(data_type,1,10) data_Type
'NUMBER',(case when length(column_name) <= 10
then 10
when length(column_name) > 10
then length(column_name)
! ! end)
,'DATE',length(sysdate)) as len
from user_tab_cols
where table_name='&table_name'
order by column_id)));
Back to top Go down

 Similar topics

» Chakra Test
» Image upload test
» Open Scroll Blog: Burning Man, worship to avoid!
» 2nd Am English test (2nd Term)
» Formal Test N°1 (2nd Term) Level MS3
Share this post on: diggdeliciousredditstumbleuponslashdotyahoogooglelive

test blog only :: Comments

No Comment.

test blog only

Back to top 

Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
 :: Blogs-
Jump to: