Guest User

Untitled

a guest
Mar 12th, 2014
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.83 KB | None | 0 0
  1. Connected TO Oracle DATABASE 10g Enterprise Edition Release 10.1.0.3.0
  2. Connected AS msq
  3.  
  4. SQL>
  5. SQL>
  6. SQL> CREATE TABLE test_mirko (colA VARCHAR(20), colB VARCHAR(20));
  7.  
  8. TABLE created
  9.  
  10. SQL> INSERT INTO test_mirko VALUES ('test', 'Test');
  11.  
  12. 1 ROW inserted
  13.  
  14. SQL> INSERT INTO test_mirko VALUES ('test', 'test');
  15.  
  16. 1 ROW inserted
  17.  
  18. SQL> INSERT INTO test_mirko VALUES ('test', 'testAAA');
  19.  
  20. 1 ROW inserted
  21.  
  22. SQL> INSERT INTO test_mirko VALUES ('test', 'tesT');
  23.  
  24. 1 ROW inserted
  25.  
  26. SQL> commit;
  27.  
  28. Commit complete
  29.  
  30. SQL> SELECT * FROM test_mirko WHERE colA = colB;
  31.  
  32. COLA                 COLB
  33. -------------------- --------------------
  34. test                 test
  35.  
  36. SQL> SELECT * FROM test_mirko WHERE colA LIKE colB;
  37.  
  38. COLA                 COLB
  39. -------------------- --------------------
  40. test                 test
  41.  
  42. SQL>
Advertisement
Add Comment
Please, Sign In to add comment