Started with PHP/HTML Formatter menu => doesn't work right now
[phpeclipse.git] / 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 }