Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL> SELECT tname from tab where tname='OPERATION';
- no rows selected
- SQL> SELECT tname from tab where tname like 'OPERATION%';
- TNAME
- --------------------------------------------------------------------------------
- OPERATION
- SQL> SELECT length('OPERATION') from tab where tname like 'OPERATION%';
- LENGTH('OPERATION')
- ------------------------
- 9
- SQL> SELECT length(tname) from tab where tname like 'OPERATION%';
- LENGTH(TNAME)
- -------------
- 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement