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:
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
I get a syntax error when I run the following: show columns from (select * fro开发者_运维问答m (select * from my_table) as T)
I\'d like to retrieve all table names from a database schema, and, if possible, get all table starting with a specified prefix.
I have 开发者_Go百科a controller that is called with AJAX (sends JSON data), so I don\'t use a view.
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: