A Data Ware house is a system that extracts, cleans, Conforms, and delivers source data into a dimensional,fact data store and then supports, implements querying and analysis for the purpose of decision making.
Feb 11, 2011
if the value is in mb or CLOB data type
SUBSTR(REPLACE(REPLACE(REPLACE(SUBSTR(COLUMN_NAME,INSTR(COLUMN_NAME,'to')+3),CHR(10),' '),CHR(13),' '),CHR(124),' '),1,40) AS DESCRIPTION
or
No comments:
Post a Comment