sql - Oracle nullable and non nullable column in a view -


i have table in oracle. table has amongst others: employee_id (number, nullable, number of nulls 0) , employee_number (varchar2, nullable, number of nulls 0).

now create view on table:

create or replace force view apps.xxke_l2e_employee (    person_id,    employee_number,    ... )    select employee_id,           employee_number,           ...      xxke.xxke_employees e           inner join xxke.xxke_organizations o on e.organization_id = o.organization_id           inner join xxke.xxke_operating_units ou on e.org_id = ou.org_id;  alter view apps.xxke_l2e_employee add constraint xxke_l2e_employee_v_pk primary key(person_id) disable;

how on earth possible in view person_id becomes nullable (even when using nvl trick), employee_number not nullable

question: how can make oracle create view in way, person_id column becomes not nullable in view? or how can make wcf odata service query view. after updating edmx file following:

errors: oracle.ssdl(227,6) : error 0075: key part: 'person_id' type xxke_l2e_employee not valid. parts of key must non nullable.

the reason why becomes nullable when creating view query used nvl on employee_id. employee not nullable in query why not. in view, oracle makes resulting column nullable. views not static query. if want not have issue can create materialized view of table nvl pre applied in query query not have null possible selected. can indexes , queries faster.


Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers
Read more

keyboard - Smiles and long press feature in Android -

i've created android keyboard. how add features inserting smilies, , using long keypresses display symbols? to create long-press behavior allows select several options pop-up menu, follow guide (specifically pop-up menu section): http://developer.android.com/guide/topics/ui/menus.html smileys (also known emoticons) combination of keys, understood programs , parsed same way. have do, when clicks smiley face on keyboard, simulate pressing of key combination matching emoticon. example, when clicks smiley, should simulate key presses ':' , ')' :). here's list of emoticons: http://en.wikipedia.org/wiki/list_of_emoticons
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());
Read more