We recorded all of the great stuff from Office Hours. https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90368704298645821440975243645173822405

Just answered-materialized view with union all not refreshed https://asktom.oracle.com/pls/asktom/asktom.search?tag=materialized-view-with-union-all-not-refreshed

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 26 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90890959998043569541277638077157363663

Missed it live? Watch it now. Here's the latest session. https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90890959998459440023225070513256288207

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 26 February at 6:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=99826341500817209161744185202875983200

Next session tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 20 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90473156051371649065411842397811928591

Just answered-Unique and primary key https://asktom.oracle.com/pls/asktom/asktom.search?tag=oracle-plsql-202602

Hope to see you there! Oracle AskTOM Office Hours. Next session starts 20 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90473156051371649065411842397811928591

Just answered-log syncs caused by user$ updates https://asktom.oracle.com/pls/asktom/asktom.search?tag=log-syncs-caused-by-user-updates

Just answered-Running a procedure in parallel mode https://asktom.oracle.com/pls/asktom/asktom.search?tag=running-a-procedure-in-parallel-mode

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 25 February at 18:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527573992625300952035908746109008

Join us and learn! Next session for Oracle AskTOM Office Hours. Starts on 19 February at 13:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90368704298645821440975243645173822405

Next session tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 18 February at 4:30 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=91690711583143692472344226637462245312

Next session tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 17 February at 14:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90890959998459440023225070513256288207

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 24 February at 15:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90890959998043569541277638077157363663

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 19 February at 13:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90368704298645821440975243645173822405

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 18 February at 4:30 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=91690711583143692472344226637462245312

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 17 February at 14:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90890959998459440023225070513256288207

Hope to see you there! Oracle AskTOM Office Hours. Next session starts 11 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527572382336109225349848037482576

Coming up tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 11 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527570410578097433889664091709520

Join us and learn! Next session for Oracle AskTOM Office Hours. Starts on 10 February at 19:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527574361347675934497807031492688

Just answered-Ternary Operator in SQL - PL/SQL https://asktom.oracle.com/pls/asktom/asktom.search?tag=ternary-operator-in-sql-plsql

The recording for the Office Hours session is available. https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90995411256821491626758996946598901452

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 11 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527570410578097433889664091709520

Every session is recorded for you! This session is now viewable. https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=92518502383636683825556425881017817891

Catch up on what you missed - recording for Office Hours. https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=95961238031215884651936022781839978231

Just answered-Bug using SQL_MACRO (TABLE) with table parameter https://asktom.oracle.com/pls/asktom/asktom.search?tag=bug-using-sql-macro-table-with-table-parameter

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 11 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527572382336109225349848037482576

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 11 February at 16:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527570410578097433889664091709520

Just answered-DBMS_OUTPUT_LINE https://asktom.oracle.com/pls/asktom/asktom.search?tag=dbms-output-line

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 10 February at 19:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355527574361347675934497807031492688

Just answered-Architectural Advice: Reporting via Pipelined Functions vs. Views in a 4-Schema SmartDB https://asktom.oracle.com/pls/asktom/asktom.search?tag=architectural-advice-reporting-via-pipelined-functions-vs-views-in-a-4-schema-smartdb

Catch up on what you missed - recording for Office Hours. https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=87966328578612474417047684910607369312

Just answered-Massive Space Discrepancy (13GB Allocated vs 23MB Data) in List-Hash Partitioned Table https://asktom.oracle.com/pls/asktom/asktom.search?tag=massive-space-discrepancy-13gb-allocated-vs-23mb-data-in-list-hash-partitioned-table

Just answered-Numeric sorting inside strings https://asktom.oracle.com/pls/asktom/asktom.search?tag=numeric-sorting-inside-strings

We recorded all of the great stuff from Office Hours. https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90355395935614471665429047065161941165

Next session tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 29 January at 6:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=95411105409748650575056204244565276065

Just answered-Top-N Stopkey: ROWNUM vs ROW_NUMBER() vs FETCH FIRST in correlated subqueries https://asktom.oracle.com/pls/asktom/asktom.search?tag=top-n-stopkey-rownum-vs-row-number-vs-fetch-first-in-correlated-subqueries

Next session tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 28 January at 18:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90995411256821491626758996946598901452

Next session tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 27 January at 15:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=95961238031215884651936022781839978231

Next session tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 27 January at 14:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=87966328578612474417047684910607369312

Just answered-WITH Clause Doesn't Work in MOUNTED Database https://asktom.oracle.com/pls/asktom/asktom.search?tag=with-clause-doesnt-work-in-mounted-database

Just answered-About LiveSQL and FreeSQL https://asktom.oracle.com/pls/asktom/asktom.search?tag=about-livesql-and-freesql

Just answered-CREATE DATABASE LINK using the CONNECT WITH clause fails with ORA-00946: missing TO keyword https://asktom.oracle.com/pls/asktom/asktom.search?tag=create-database-link-using-the-connect-with-clause-fails-with-ora-00946-missing-to-keyword

Just answered-String to rows using connect by https://asktom.oracle.com/pls/asktom/asktom.search?tag=string-to-rows-using-connect-by

Just answered-Set DBMS_STATS estimate_percent to 100 https://asktom.oracle.com/pls/asktom/asktom.search?tag=set-dbms-stats-estimate-percent-to-100

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 29 January at 6:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=95411105409748650575056204244565276065

Coming up tomorrow. Oracle experts will be online for AskTOM Office Hours. Next session starts 23 January at 4:30 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=91690711583109842549395017020570472384

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 28 January at 18:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=90995411256821491626758996946598901452

Next week. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 27 January at 15:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=95961238031215884651936022781839978231