User Profile

Collapse

Profile Sidebar

Collapse
koos
koos
Last Activity: Feb 11 '08, 12:34 PM
Joined: Feb 11 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • koos
    replied to Space constant
    in Oracle
    No problem using it like this. I just want to know why you would do this.
    Is it not the same to say. Does the constant make it quicker?

    mySpace CONSTANT VARCHAR2(1) := ' ';
    begin
    select ....into x

    exeption
    no_data_found then
    x:= ' ';

    end;...
    See more | Go to post

      Leave a comment:

    • koos
      started a topic Space constant
      in Oracle

      Space constant

      Hi
      Is it good practice to declare a space constant (' ') and use it in a procedure? Does it make the execution faster??? Why would you do something like that?
      See more | Go to post
      No activity results to display
      Show More
      Working...