![]() Meaningful like you can show username and SID and date in the prompt by You can change the default SQL> prompt in SQL Plus to something more SQL> alter session set nls_date_format='dd-Mon-yyyy hh:mi:sspm' Want by setting the session variable NLS_DATE_FORMATįor example if you set it to the following Similarly you can also format date values in whatever date format you evenĮmpno, deptno etc will be shown in the format, which you don't want in Remember the above command will format all numeric values i.e. ![]() Similarly you can also format all numeric values by giving the following Values with commas, you can format it like this for exampleĪnd now you will get the output like this In the above output the salary column is shown without any formatting You can also set Number format so see the numeric values with commas forįor example if you select the rows from scott emp table you will see the You can easily structured the output by adjusting the line size andįormatting the column by typing the following commandsĪnd then again give the same query, you will see the output in well ![]() Have many times seen unstructured output for SQL queries. While using Oracle SQL*Plus for interacting with the database you must Simple and useful hints for formatting output in SQL*Plus Integrity Constraints (PRIMARY KEY, NOT NULL.) DEFAULT Values Dropping Constraints Disabling and Enabling Differing Constraints Check View Info about Constraints Working with Dates Oracle Views Oracle Sequences Oracle Synonyms Indexes and Clusters Table Partitioning Altering Partition Tables Dropping Partitions Merging Partitions Splitting Partitions Coalescing Partitions Oracle Objects and Object Types ![]() Oracle TO_TIMESTAMP Number Functions (Math Functions) Character Functions Miscellaneous Functions Aggregate Functions Date and Time Functions Oracle Join Queries GROUP BY Queries, SUB Queries CUBE, ROLLUP Functions Oracle DML (INSERT, UPDATE, DELETE.) Oracle DDL (CREATE, ALTER, DROP.) COMMIT, ROLLBACK,SAVEPOINT Data Control Language (GRANT, REVOKE) Oracle SQL Tutorial Contents Introduction to Databases CODD'S Rules Datatypes and Create Table Oracle SELECT Statement Formatting in SQL*Plus UNION, INTERSECT, MINUS Operators and Sorting Query Result 60 Technical Questions 42 Backup & Recovery Questions Unix For Oracle DBA 20 Questions Oracle DBA Interview Questions Most asked Oracle DBA Interview Questions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |