Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

difference between NULL and ''

NeilCSEMar 30 2010 — edited Mar 30 2010
Hi All,

Is the below right?

NULL is not stored as a value in a field. Its an internal bit that is set to indicate that the value is unknown.
Blank is stored as a value in the field. Because of that we can perform all kinds of comparisons with blank value, while we cant do the same with NULLs

Regards,
aak

Comments

Mahmoud_Rabie
Answer

Finally, found the solution in this nice article

https://gerardnico.com/wiki/apex/security_group

I hope the following function helps someone

create or replace FUNCTION  "IS_VALIDUSER"(

          p_workspace in VARCHAR2,

          in_username in VARCHAR2,

          in_password in VARCHAR2)

return NUMBER

is

  l_workspace_id      NUMBER;

begin

    l_workspace_id := apex_util.find_security_group_id (p_workspace => p_workspace);

    apex_util.set_security_group_id (p_security_group_id => l_workspace_id);

  

    if(APEX_UTIL.IS_LOGIN_PASSWORD_VALID(in_username,in_password) ) then

        return 1;

    else

        return 0;

    end if;

end;

Regards

Mahmoud

Marked as Answer by Mahmoud_Rabie · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 27 2010
Added on Mar 30 2010
13 comments
25,604 views