‘NOT LIKE’ in an SQL query

You have missed out the field name id in the second NOT LIKE. Try: The AND in the where clause joins 2 full condition expressions such as id NOT LIKE ‘1%’ and can’t be used to list multiple values that the id is ‘not like’.

Hibernate dialect for Oracle Database 11g?

Use the Oracle 10g dialect. Also Hibernate 3.3.2+ is required for recent JDBC drivers (the internal class structure changed – symptoms will be whining about an abstract class). Dialect of Oracle 11g is same as Oracle 10g (org.hibernate.dialect.Oracle10gDialect). Source: http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/session-configuration.html#configuration-optional-dialects

grant select on view

The error message should be written like this: ORA-01720: “grant option” does not exist for COLLDESK.GESTIONES. Here’s how it works: You have 3 schemas: Schema1 – Holder of a table named “table1” Schema2 – Holder of a view “view1” selecting from schema1.table1 Schema3 – User, selecting from schema2.view1 – has no select granted on schema1.table1. … Read more

tech