plsql 150

  1. What is the difference between SQL, PL-SQL and T-SQL?
  2. Is there a combination of “LIKE” and “IN” in SQL?
  3. What is the string concatenation operator in Oracle?
  4. Number of rows affected by an UPDATE in PL/SQL
  5. Oracle PL/SQL - How to create a simple array variable?
  6. What does it mean by select 1 from table?
  7. Search All Fields In All Tables For A Specific Value (Oracle)
  8. What is the Oracle equivalent of SQL Server's IsNull() function?
  9. Printing the value of a variable in SQL Developer
  10. How can I get the number of records affected by a stored procedure?
  11. Splitting string into multiple rows in Oracle
  12. Oracle SQL Query for listing all Schemas in a DB
  13. PL/SQL, how to escape single quote in a string?
  14. SQL error “ORA-01722: invalid number”
  15. How can I drop a “not null” constraint in Oracle when I don't know the name of the constraint?
  16. What is the difference between function and procedure in PL/SQL?
  17. Oracle PL/SQL - Raise User-Defined Exception With Custom SQLERRM
  18. DBMS_OUTPUT.PUT_LINE not printing
  19. How to select into a variable in PL/SQL when the result might be null?
  20. How can I loop through Exception getCause() to find root cause with detail message
  21. How do I get column datatype in Oracle with PL-SQL with low privileges?
  22. BEGIN - END block atomic transactions in PL/SQL
  23. Is it possible to output a SELECT state from a PL/SQL block?
  24. How to use BOOLEAN type in SELECT statement
  25. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  26. create table with sequence.nextval in oracle

  27. Truncating a table in a stored procedure
  28. How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?
  29. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  30. IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation
  31. Oracle: how to INSERT if a row doesn't exist
  32. How to execute an oracle stored procedure?
  33. PL/SQL block problem: No data found
  34. How to check if a column exists before adding it to an existing table in PL/SQL?
  35. Is there a function to split a string in PL/SQL?
  36. Is there any way to flush output from PL/SQL in Oracle?
  37. Get a list of all functions and procedures in an Oracle database
  38. SQL to generate a list of numbers from 1 to 100
  39. Can you SELECT everything, but 1 or 2 fields, without writer's cramp?
  40. What does the colon sign “:” do in a SQL query?
  41. Functions vs procedures in Oracle
  42. check if “it's a number” function in Oracle
  43. How to query a CLOB column in Oracle
  44. Oracle Pl/SQL: Loop through XMLTYPE nodes
  45. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  46. How to catch a unique constraint error in a PL/SQL block?
  47. MODIFY COLUMN in oracle - How to check if a column is nullable before setting to nullable?
  48. Convert comma separated string to array in PL/SQL
  49. Oracle “ORA-01008: not all variables bound” Error w/ Parameters
  50. PL/SQL print out ref cursor returned by a stored procedure