plsql 349

  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. How can I get the number of records affected by a stored procedure?
  10. Printing the value of a variable in SQL Developer
  11. Oracle SQL Query for listing all Schemas in a DB
  12. How can I drop a “not null” constraint in Oracle when I don't know the name of the constraint?
  13. What is the difference between function and procedure in PL/SQL?
  14. Oracle PL/SQL - Raise User-Defined Exception With Custom SQLERRM
  15. PL/SQL, how to escape single quote in a string?
  16. sql error “ORA-01722: invalid number”
  17. Splitting string into multiple rows in Oracle
  18. DBMS_OUTPUT.PUT_LINE not printing
  19. How to select into a variable in PL/SQL when the result might be null?
  20. Differences between SQL and PL-SQL
  21. BEGIN - END block atomic transactions in PL/SQL
  22. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  23. Is it possible to output a SELECT state from a PL/SQL block?
  24. Truncating a table in a stored procedure
  25. How do I get column datatype in Oracle with PL-SQL with low privileges?
  26. How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?
  27. Oracle: how to INSERT if a row doesn't exist
  28. create table with sequence.nextval in oracle
  29. IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation
  30. PL/SQL block problem: No data found
  31. How to use BOOLEAN type in SELECT statement
  32. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  33. How can I loop through Exception getCause() to find root cause with detail message
  34. Is there a function to split a string in PL/SQL?
  35. check if “it's a number” function in Oracle
  36. Oracle Pl/SQL: Loop through XMLTYPE nodes
  37. Is there any way to flush output from PL/SQL in Oracle?
  38. What does the colon sign “:” do in a SQL query?
  39. SQL to generate a list of numbers from 1 to 100
  40. How to catch a unique constraint error in a PL/SQL block?
  41. How to query a CLOB column in Oracle
  42. MODIFY COLUMN in oracle - How to check if a column is nullable before setting to nullable?
  43. Oracle “ORA-01008: not all variables bound” Error w/ Parameters
  44. How to execute an oracle stored procedure?
  45. Get a list of all functions and procedures in an Oracle database
  46. Convert comma separated string to array in PL/SQL
  47. Can you SELECT everything, but 1 or 2 fields, without writer's cramp?
  48. What does “%Type” mean in Oracle sql?
  49. SQL recursive query on self refrencing table (Oracle)
  50. How to check if a column exists before adding it to an existing table in PL/SQL?