Check if a variable is null in plsql

by 
if var is NULL then
  var :=5;
end if;

Related Contents:

  1. Is there a combination of “LIKE” and “IN” in SQL?
  2. What is the string concatenation operator in Oracle?
  3. SQL error “ORA-01722: invalid number”
  4. Search All Fields In All Tables For A Specific Value (Oracle)
  5. Splitting string into multiple rows in Oracle
  6. How can I get the number of records affected by a stored procedure?
  7. Is it possible to output a SELECT statement from a PL/SQL block?
  8. How to check if a column exists before adding it to an existing table in PL/SQL?
  9. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  10. Select multiple columns into multiple variables
  11. SQL to generate a list of numbers from 1 to 100
  12. What does the colon sign “:” do in a SQL query?
  13. PL/SQL block problem: No data found error
  14. IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation [duplicate]
  15. How to query a CLOB column in Oracle
  16. create table with sequence.nextval in oracle [duplicate]
  17. How to use BOOLEAN type in SELECT statement
  18. Is there any way to flush output from PL/SQL in Oracle?
  19. How can you tell if a value is not numeric in Oracle?
  20. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  21. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  22. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  23. Sleep function in ORACLE
  24. Why does Oracle 9i treat an empty string as NULL?
  25. ORA-00979 not a group by expression
  26. How do I spool to a CSV formatted file using SQLPLUS?
  27. How do I get textual contents from BLOB in Oracle SQL
  28. Search an Oracle database for tables with specific column names?
  29. What does “select count(1) from table_name” on any database tables mean?
  30. How do I select all the columns from a table, plus additional columns like ROWNUM?
  31. SQL Error: ORA-01861: literal does not match format string 01861
  32. How do you interpret a query’s explain plan?
  33. Oracle SQL – DATE greater than statement
  34. OVER clause in Oracle
  35. Foreign key reference to table in another schema
  36. LISTAGG function: “result of string concatenation is too long”
  37. how to increase sqlplus column output length?
  38. Oracle SQL : timestamps in where clause
  39. Best way to reset an Oracle sequence to the next value in an existing column?
  40. Favorite SQL*Plus tips and tricks [closed]
  41. SQL to add column and comment in table in single command
  42. Alternatives to LIMIT and OFFSET for paging in Oracle [duplicate]
  43. Oracle date “Between” Query
  44. Update statement using with clause
  45. alter the size of column in table containing data [duplicate]
  46. Convert timestamp to date in Oracle SQL
  47. How to insert a string which contains an “&”
  48. Changing precision of numeric column in Oracle
  49. Efficient way to update all rows in a table
  50. What is the difference between CLOB and NCLOB?

Leave a Comment