archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/OracleAdapter.java

   1 package net.sourceforge.phpdt.sql.adapters;
   2
   3
   4 public class OracleAdapter extends DatabaseAdapter {
   5     public String getShowTableQuery(DatabaseInfo info) {
   6         return "SELECT TABLE_NAME FROM USER_TABLES";
   7     }
   8     public String getShowViewQuery(DatabaseInfo info) {
   9         return "SELECT VIEW_NAME FROM USER_VIEWS";
  10     }
  11     public String getShowSequenceQuery(DatabaseInfo info) {
  12         return "SELECT SEQUENCE_NAME FROM USER_SEQUENCES";
  13     }
  14     public String getNextValue(String sequence) {
  15         return "SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME = '" + sequence + "'";
  16     }
  17         public DatabaseAdapter getInstance() {
  18                 return new OracleAdapter();
  19         }
  20 }