Advertisement
Guest User

Untitled

a guest
Jul 12th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. RIGHE DOVE OTTIENE I DATI
  2.  
  3. com1 = ['SELECT ' str_data, ' '];
  4. com2 = ['FROM ' str_container, ' '];
  5. if length(where)>2
  6. com3 = ['WHERE ' where, ' '];
  7. com4 = ['ORDER BY ' str_order, ' '];
  8. curs = exec(conn, [com1 com2 com3 com4]);
  9. else
  10. com3 = ['ORDER BY ' str_order, ' '];
  11. curs = exec(conn, [com1 com2 com3]);
  12. end
  13.  
  14. curs = fetch(curs);
  15. close(curs);
  16.  
  17. COSA SONO com1, com2, com3 e conn? Ecco qui:
  18.  
  19. conn =
  20.  
  21. Instance: ''
  22. UserName: 'mmacchin'
  23. Driver: 'oracle.jdbc.driver.Oracle...'
  24. URL: 'jdbc:oracle:thin:@( DESCR...'
  25. Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
  26. Message: []
  27. Handle: [1x1 oracle.jdbc.driver.T4CConnection]
  28. TimeOut: 0
  29. AutoCommit: 'on'
  30. Type: 'Database Object'
  31.  
  32.  
  33. com1 =
  34.  
  35. SELECT
  36.  
  37.  
  38. com2 =
  39.  
  40. FROM
  41.  
  42.  
  43. com3 =
  44.  
  45. ORDER BY
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement