plsql - Replace the value -


we have column 'a' in 'x' , 'y' table. if value of column 'a' not null need consider in 'x' table otherwise need consider in 'y' table.

based on requirement how achieve it?

thanks in advance

sounds you're asking nvl function. based on limited information go on work you...

create table x(id int, varchar(255)); insert x(id, a) values(1, 'one'); insert x(id, a) values(2, null); insert x(id, a) values(3, 'three');  create table y(id int, varchar(255)); insert y(id, a) values(1, 'one'); insert y(id, a) values(2, 'two'); insert y(id, a) values(3, 'three');  select x.id, nvl(x.a,y.a) x, y x.id = y.id;

results in...

id  ========== 1   1 2   2 3   3

Comments

Post a Comment

Popular posts from this blog

authentication - Mongodb revoke acccess to connect test database -

i have ec2 instance mongodb 3.2.0 installed. have user admin access. can connect user , perform operation remotely. 1 can connect database test remote if knows ip mongo 11.11.11.11. although not able make operations, want restrict access user credentials can connect server. first need create users , grant roles users, example: use admin db.createuser( { user: "myuseradmin", pwd: "abc123", roles: [ { role: "useradminanydatabase", db: "admin" } ] } ) then need start server --auth parameter mongod --auth more information here
Read more

python - GitPython: check if git is available -

gitpython depends on having command line version of git installed (otherwise, issue in question: oserror: [errno 2] no such file or directory on gitpython ). is there way gitpython api check if executable found, or, need wrap gitpython calls in exception handling account possibility? i don't particularly recommend this, did @ least once: try 1 git command while catching oserror case see if can run git (and running it, capture git version number well, in case). if git fails run, complain , disable further invocations of git (or exit or whatever). if not, assume further invocations continue work.
Read more

c# - ASP.NET MVC Enumerable to delimited HTML in Razor -

this question has answer here: looping through list in razor , adding separator between items 4 answers i discovered can use string.join(", ", string[] enumerable) turn list of strings single comma delimited string. similar produce example list of hyperlinks in razor view? instead of like: @foreach(var item in enumerable) { <a href="@item.url">@item.title</a> if(item != enumerable.last()) { <span>, </span> } } and if so, advisable or should stop being lazy? @html.raw(string.join("<span>, </span>", enumerable.select(item => string.format("<a href=\"{0}\">{1}</a>", item.url, item.title))))
Read more