database-metadata
How to retrieve sequences metadata from JDBC?
I am trying to retrieve different kind of metadata of my Oracle DB from Java code (using basic JDBC). For example, if I want to retrieve the list of tables with _FOO suffix, I can do something like:[详细]
2023-02-25 13:57 分类:问答How to get all columns' names for all the tables in MySQL?
Is there a fast way of getting all column names fr开发者_StackOverflow中文版om all tables in MySQL, without having to list all the tables?select column_name from information_schema.columns[详细]
2023-02-25 10:11 分类:问答How to SHOW COLUMNS from a SELECT query (rather than a table)?
I get a syntax error when I run the following: show columns from (select * fro开发者_运维问答m (select * from my_table) as T)[详细]
2023-01-16 18:40 分类:问答How to get all table names from a database?
I\'d like to retrieve all table names from a database schema, and, if possible, get all table starting with a specified prefix.[详细]
2022-12-29 15:12 分类:问答Use view helpers in controllers in Zend Framework
I have 开发者_Go百科a controller that is called with AJAX (sends JSON data), so I don\'t use a view.[详细]
2022-12-22 01:44 分类:问答JDBC DatabaseMetaData.getColumns() returns duplicate columns
I\'m busy on a piece of code to get alle the column names of a table from an Oracle database. The code I came up with looks like this:[详细]
2022-12-08 21:45 分类:问答