8000 Unordered cursor compare with NULLS value fails · Issue #914 · utPLSQL/utPLSQL · GitHub
[go: up one dir, main page]

Skip to content
Unordered cursor compare with NULLS value fails #914
Closed
@lwasylow

Description

@lwasylow

Unordered with nulls fails due to using a direct compare of values it should use a :

function generate_equal_sql(a_col_name in varchar2) return varchar2 is
  begin
    return ' decode(a.'||a_col_name||','||' e.'||a_col_name||',1,0) = 1 ';
  end;

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0