On 09/07/11 1:45 PM, Arun Nadar wrote:
>
> but it work by putting " ", like this SELECT "Id", "Name" FROM
> "Student" ORDER BY "Id";
>
> in java String, inside of double inverted commas another is does not
> possible.
String sql="SELECT \"Id\", \"Name\" FROM \"Student\" ORDER BY \"Id\"";
Alternately, create your table with all lower case names, and you won't
have this problem.
alter table "Student" rename to student;
alter table student rename column "Id" to id;
alter table student rename column "Name" to name;
--
john r pierce N 37, W 122
santa cruz ca mid-left coast