Subject | Re: How do I use quoted fields? |
---|---|
Author | rrokytskyy |
Post date | 2002-04-18T14:48:05Z |
> ResultSet rs = st.executeQuery("select * from ???;");ResultSet rs = st.executeQuery("select * from \"myTable\";");
If you need to include quotes in string constant, you have to escape
them using backslash according to Java language specification.
There's nothing JDBC specific.
But if you want to be JDBC compliant, use
java.sql.DatabaseMetaData.getIdentifierQuoteString() value to
represent quotes.
Best regards,
Roman Rokytskyy