Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?

by

No – you either get all fields (*) OR specify the fields you want.

More Related Contents:

  1. What is the replacement of cursor foreach in oracle pl/sql?
  2. Get counts of all tables in a schema
  3. PL/SQL, how to escape single quote in a string?
  4. PL/SQL – Use “List” Variable in Where In Clause
  5. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Get resultset from oracle stored procedure
  8. Oracle PL/SQL – How to create a simple array variable?
  9. ways to avoid global temp tables in oracle
  10. Split function in oracle to comma separated values with automatic sequence
  11. ORA-06508: PL/SQL: could not find program unit being called
  12. Number of rows affected by an UPDATE in PL/SQL
  13. PL/SQL print out ref cursor returned by a stored procedure
  14. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  15. Create Pivot view in SQL from a SQL table
  16. Why doesn’t PL/SQL respect privileges granted by Roles?
  17. Can We use threading in PL/SQL?
  18. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  19. Oracle: how to INSERT if a row doesn’t exist
  20. Functions vs procedures in Oracle
  21. What is the algorithm used by the ORA_HASH function?
  22. How to output result of SELECT statement which is executed using native dynamic SQL?
  23. passing in table name as plsql parameter
  24. Reading clob line by line with pl\sql
  25. Cursor For Loop with dynamic SQL-Statement
  26. How to use parameters in a ‘where value in…’ clause?
  27. Why cannot I create triggers on objects owned by SYS?
  28. No more data to read from socket
  29. automating rollback script oracle
  30. How do I get column datatype in Oracle with PL-SQL with low privileges?

Leave a Comment