adding primary key to sql view

by

We can add a disabled primary key constraint to a view. That is, the constraint does not fire if an insert or update is run against the view. The database expects integrity to be maintained through constraints on the underlying tables. So the constraint exists solely for the purposes of documentation.

SQL> create view emp_view as select * from emp
  2  /


View created.

SQL> alter view emp_view add constraint vemp_pk primary key (empno) disable
  2  /

View altered.

SQL>

Caveat: I have never tried this with Hibernate, so I don’t know whether it would work in your scenario. However, I do know sites which use Hibernate exclusively against a layer of views, so I presume it does. Please experiment with the syntax and report back.

More Related Contents:

  1. What is the difference between Views and Materialized Views in Oracle?
  2. Does ‘Select’ always order by primary key?
  3. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  4. Retrieve Oracle last inserted IDENTITY
  5. How to create id with AUTO_INCREMENT on Oracle?
  6. LISTAGG in Oracle to return distinct values
  7. Fetch the row which has the Max value for a column
  8. Oracle SQL: Update a table with data from another table
  9. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  10. Fetch the rows which have the Max value for a column for each distinct value of another column
  11. SQL to generate a list of numbers from 1 to 100
  12. How to use BOOLEAN type in SELECT statement
  13. How to show all privileges from a user in oracle?
  14. SQL – How to select a row having a column with max value [duplicate]
  15. Oracle: loading a large xml file?
  16. IF EXISTS condition not working with PLSQL
  17. Using pivot on multiple columns of an Oracle row
  18. Sleep function in ORACLE
  19. Solution to “cannot perform a DML operation inside a query”?
  20. Why can’t I seem to force Oracle 11g to consume more CPUs for a single SQL query
  21. How to query a CLOB column in Oracle
  22. Oracle (Old?) Joins – A tool/script for conversion?
  23. update columns values with column of another table based on condition [duplicate]
  24. how to select even records from a table in oracle?
  25. Return number from Oracle Select statement after parsing date
  26. How do you interpret a query’s explain plan?
  27. How to call Oracle MD5 hash function?
  28. Oracle Convert TIMESTAMP with Timezone to DATE
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment