UNION ALL and MINUS

Hi all,
I have in Oracle.

INSERT INTO format ( id, name, description)
SELECT 0, null , 'all' FROM dual UNION ALL
SELECT 1, 'text' ,'sms' FROM dual UNION ALL
SELECT 2, 'melody','melody' FROM dual UNION ALL
SELECT 3, 'logo' ,'logo' FROM dual UNION ALL
SELECT 4, 'ems' ,'ems'
MINUS
SELECT id, name, description FROM format;

"This sentence is for initials values, I can execute twice and I don't
have data duplicate."

But in SyBase I don't found the solution, because I read MINUS
translate with "NOT EXIST", but "UNION ALL and NOT EXIST is not
possible"?

My dream is a sentence that I can execute in ORACLE and SyBase, but one
easy solution in SyBase it's ok for me.

Thanks a lot.

.

Relevant Pages

  • Re: UNION ALL and MINUS
    ... > INSERT INTO format ... > SELECT 2, 'melody','melody' FROM dual UNION ALL ... > But in SyBase I don't found the solution, because I read MINUS ... > My dream is a sentence that I can execute in ORACLE and SyBase, ...
    (comp.databases.sybase)
  • Re: Maybe VLOOKUP?
    ... Valko" wrote: ... Without those "double minus" signs, the formula would return either TRUE ... I need to format my data (for a ... whether or not that date exists in my original dataset or not, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Maybe VLOOKUP?
    ... The "double minus" coerces the TRUE to 1 and FALSE to 0. ... "A" is the original data (I'm using a smaller data ... I need to format my data (for a statistical ... whether or not that date exists in my original dataset or not, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Maybe VLOOKUP?
    ... Valko" wrote: ... The "double minus" coerces the TRUE to 1 and FALSE to 0. ... I need to format my data (for a statistical ... whether or not that date exists in my original dataset or not, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Trendlines
    ... the Power. ... All it means is that it could have been a minus instead. ... Just right click on the trendline equation, select "Format Data Labels" and make the required changes. ...
    (microsoft.public.excel.charting)