Guest User

Untitled

a guest
Jan 19th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. SQL> show parameter BLANK_TRIMMING;
  2.  
  3. NAME TYPE VALUE
  4. ------------------------------------ ----------- ------------------------------
  5. blank_trimming boolean FALSE
  6.  
  7.  
  8. SQL> alter system set BLANK_TRIMMING=true scope=spfile;
  9.  
  10. System altered.
  11.  
  12. Then bounce the database.
  13.  
  14. SQL> startup force;
  15.  
  16. SQL> update tblchar set col1=TRIM(col1);
  17.  
  18. SQL> alter table tblchar modify col1 char(16 byte);
  19.  
  20. Table altered.
  21.  
  22. ALTER TABLE t
  23. ADD (col2 CHAR (16));
  24.  
  25. UPDATE t
  26. SET col2 = TRIM (col1);
  27.  
  28. ALTER TABLE t
  29. DROP (col1);
  30.  
  31. ALTER TABLE t
  32. RENAME COLUMN col2 TO col1;
Add Comment
Please, Sign In to add comment