How to display table data more clearly in oracle sqlplus

by

I usually start with something like:

set lines 256
set trimout on
set tab off

Have a look at help set if you have the help information installed. And then select name,address rather than select * if you really only want those two columns.

More Related Contents:

  1. Can we update primary key values of a table?
  2. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  3. Liquibase lock – reasons?
  4. How SID is different from Service name in Oracle tnsnames.ora
  5. Are foreign keys really necessary in a database design?
  6. Is it possible to generate django models from the database?
  7. What is a View in Oracle?
  8. What is the difference between Non-Repeatable Read and Phantom Read?
  9. Business Logic: Database or Application Layer
  10. Convert String ISO-8601 date to oracle’s timestamp datatype
  11. What is the default Precision and Scale for a Number in Oracle?
  12. Oracle: How do I convert hex to decimal in Oracle SQL?
  13. Display dynamic image from database or remote source with p:graphicImage and StreamedContent
  14. Primary keys with Apache Spark
  15. Partial Dependency (Databases)
  16. When or Why to use a “SET DEFINE OFF” in Oracle Database
  17. Techniques for database inheritance?
  18. Fabric.js – how to save canvas on server with custom attributes
  19. How to disable Django query cache?
  20. Django’s ManyToMany Relationship with Additional Fields
  21. Does mysql have the equivalent of Oracle’s “analytic functions”?
  22. Is there a standard for storing normalized phone numbers in a database?
  23. How should international geographical addresses be stored in a relational database?
  24. how to use Blob datatype in Postgres
  25. Is there any option for local database like Sqlite for j2me – CLDC devices?
  26. Are database triggers necessary? [closed]
  27. Which is a good design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  28. What can cause an Oracle ROWID to change?
  29. I need a client side browser database. What are my options [closed]
  30. “Cannot drop database because it is currently in use”. How to fix?

Leave a Comment