Advertisement
Guest User

Untitled

a guest
Apr 18th, 2015
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. SQL> desc emp
  2. Name Null? Type
  3. ----------------------------------------- -------- ----------------------------
  4. EMPNO NOT NULL NUMBER(4)
  5. ENAME NOT NULL VARCHAR2(10)
  6. JOB VARCHAR2(9)
  7. MGR NUMBER(4)
  8. HIREDATE DATE
  9. SAL NUMBER(7,2)
  10. COMM NUMBER(7,2)
  11. DEPTNO NUMBER(2)
  12.  
  13. SQL> insert into emp (empno, ename) values (9999, ' ')
  14. 2 /
  15.  
  16. 1 row created.
  17.  
  18.  
  19. SQL> select length(ename) from emp
  20. 2 where empno = 9999
  21. 3 /
  22.  
  23. LENGTH(ENAME)
  24. -------------
  25. 6
  26. SQL>
  27.  
  28. public void setSURNAME(String SURNAME) {
  29. this.SURNAME = SURNAME == null ? null : SURNAME.trim();
  30. }
  31.  
  32. public void setSURNAME(String SURNAME) {
  33. this.SURNAME = SURNAME == null ? null : SURNAME;
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement