Hi, I appreciate you helping me.
> Is the table read-only? If yes then it is possible to create a > workaround, for example by creating a view on top of the linked table: > yes, I would like to use LinkedTable as read-only. > CREATE LINKED TABLE TEST(...) > CREATE VIEW TEST2 AS SELECT LEFT(NAME || SPACE(15), 15) NAME FROM TEST; > > Would that be a solution? LINKED TABLE + VIEW solution seems to cause performance issue. Am I right? In that case, I'd rather program My Application not to depend on the trailing spaces. Anyway, I would be happy If I can specify CHAR column value in WHERE clause such as 'test1 ' for Oracle LinkedTable as other DBs. Sincerely, On Sep 25, 5:21 am, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > Hi, > > > My application would not like to > > care whether the data is extracted from Oracle DB > > directly or through LinkedTable object for the table. > > I understand, it is a compatibility problem. > > Is the table read-only? If yes then it is possible to create a > workaround, for example by creating a view on top of the linked table: > > CREATE LINKED TABLE TEST(...) > CREATE VIEW TEST2 AS SELECT LEFT(NAME || SPACE(15), 15) NAME FROM TEST; > > Would that be a solution? > > Regards, > Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
