SQL Plugin copied from Quantum plugin and refactored for PHPEclipse

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

diff --git a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/OracleAdapter.java b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/OracleAdapter.java
new file mode 100644 (file)
index 0000000..493b820
--- /dev/null
+++ b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/OracleAdapter.java
@@ -0,0 +1,20 @@
+package net.sourceforge.phpdt.sql.adapters;
+
+
+public class OracleAdapter extends DatabaseAdapter {
+    public String getShowTableQuery(DatabaseInfo info) {
+        return "SELECT TABLE_NAME FROM USER_TABLES";
+    }
+    public String getShowViewQuery(DatabaseInfo info) {
+        return "SELECT VIEW_NAME FROM USER_VIEWS";
+    }
+    public String getShowSequenceQuery(DatabaseInfo info) {
+        return "SELECT SEQUENCE_NAME FROM USER_SEQUENCES";
+    }
+    public String getNextValue(String sequence) {
+        return "SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME = '" + sequence + "'";
+    }
+       public DatabaseAdapter getInstance() {
+               return new OracleAdapter();
+       }
+}
\ No newline at end of file