Module 3: Modeling for Time Series Source https://github.com/DataTalksClub/stock-markets-analytics-zoomcamp/tree/main/03-modeling Homework https://github.com/garjita63/stock-market-analytics-zoomcamp/blob/main/homework/module-3/homework-3.ipynb
Change bytes into char inside data type of VARCHAR2 begin for r in (select owner, table_name, column_name, data_length from all_tab_columns where data_type = 'VARCHAR2' and char_used = 'B' and owner = 'SCHEMA') loop execute immediate 'alter table ' || r.owner || '.' || r.table_name || ' modify ' || r.column_name || ' varchar2(' || r.data_length || ' char)'; end loop; end; / Note: Replace SCHEMA with owner of the tables
Remove the spurious CR characters The ^M is a carriage return character. Linux uses the line feed character to mark the end of a line, whereas Windows uses the two-character sequence CR LF. Your file has Windows line endings, which is confusing Linux. You can remove the spurious CR characters with the following command: sed -i -e 's/\r$//'
Comments
Post a Comment