equal
deleted
inserted
replaced
588 |
588 |
589 spool /home/user/insert.sql; |
589 spool /home/user/insert.sql; |
590 select * from tbl where ...; |
590 select * from tbl where ...; |
591 spool off; |
591 spool off; |
592 |
592 |
|
593 Another ``sqlformat``:: |
|
594 |
|
595 set sqlformat default; |
|
596 set sqlformat csv; |
|
597 set sqlformat html; |
|
598 set sqlformat xml; |
|
599 set sqlformat json; |
|
600 |
593 https://dba.stackexchange.com/questions/173540/generate-insert-statements-for-each-entry-in-a-table |
601 https://dba.stackexchange.com/questions/173540/generate-insert-statements-for-each-entry-in-a-table |
594 Generate ``insert`` statements for each entry in a table. |
602 Generate ``insert`` statements for each entry in a table. |
|
603 https://oracle-base.com/articles/misc/sqlcl-format-query-results-with-the-set-sqlformat-command |
|
604 SQLcl : Format Query Results with the SET SQLFORMAT Command. |
595 |
605 |
596 Unlock expired password |
606 Unlock expired password |
597 ======================= |
607 ======================= |
598 |
608 |
599 Connect as sysdba to the database and reset password and unlock user:: |
609 Connect as sysdba to the database and reset password and unlock user:: |