New answers tagged

1

I want all 200 rows between 400 and 600 regardless of if the value in the second table column exists So given two joined tables, "left" and "right", you want to include every row from the "left" table and matching rows in the "right" table if they happen to be there? That's called a Left [Outer] Join. You'll have to ...


0

For the "isexpired" column, don't store it as a literal column: use a view to determine that status dynamically. That way status is accurate to the second, at runtime. create table passwordResetLink( link_id number(5) primary key, link_date timestamp(0) default sysdate NOT NULL, email varchar2(110) UNIQUE NOT NULL, linkUsed number(2)...


0

Rather than query a table, why not query a view that has your rules built in? CREATE VIEW vwPasswordResetLink AS SELECT link_id, link_date, CASE WHEN sysdate > link_date + INTERVAL '1' DAY THEN 1 ELSE 0 END AS isExpired, email, linkUsed FROM PasswordResetLink WHERE link_date >= sysdate - INTERVAL '7' ...


-1

my answer is just write table name with login credentials of "sys" or/and "xe" like for my program change ur table name is EMP then write XE.EMP like "select * from XE.EMP"


-1

Please see this link in Stack Overflow answers all question - agg distinct - is now built in some versions and this post also shows work around (polyfill) for older versions. https://stackoverflow.com/a/22624072/334106


Top 50 recent answers are included