corpus.blog
41554 blogs · [ { "id": "01a0c564-1971-70b9-bad2-6739ac978c84", "title": "Change Date in Oracle using FIXED_DATE", "url": "https://databaserookies.wordpress.com/2016/12/12/change-date-in-oracle-using-fixed_date/", "published_at": "2016-12-12T07:49:17+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739acb635fb", "title": "Interesting Database SQL Concept Question, Give it a try??", "url": "https://databaserookies.wordpress.com/2016/12/09/interesting-database-sql-concept-question-give-it-a-try/", "published_at": "2016-12-09T12:37:36+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739ad925d34", "title": "Multiplication across rows and Analytical Functions.", "url": "https://databaserookies.wordpress.com/2016/12/06/multiplication-of-rows-data-and-analytical-functions/", "published_at": "2016-12-06T12:25:07+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739adcf2844", "title": "#SQLSERVERLearning : Identity Column Insight.", "url": "https://databaserookies.wordpress.com/2016/12/03/sqlserverlearning-identity-column-insight/", "published_at": "2016-12-03T14:53:42+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739ae2648d5", "title": "Oracle 12c : Default values on NULL.", "url": "https://databaserookies.wordpress.com/2016/12/03/oracle-12c-default-values-on-null/", "published_at": "2016-12-03T06:40:34+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739ae3d2646", "title": "Aggregate Function , Distinct and NULL Values in Oracle.", "url": "https://databaserookies.wordpress.com/2016/12/01/aggregate-function-distinct-and-null-values-in-oracle/", "published_at": "2016-12-01T09:15:00+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739aefba240", "title": "#SQLSERVERLearning : Exception on Invalid/Incorrect Hints?", "url": "https://databaserookies.wordpress.com/2016/11/25/sqlserverlearning-exception-on-invalidincorrect-hints/", "published_at": "2016-11-24T19:28:47+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739af101c51", "title": "#SQLSERVERLearning : Does Unique Index Stored NULL Values in Index?", "url": "https://databaserookies.wordpress.com/2016/11/21/sqlserverlearning-does-unique-index-stored-null-values-in-index/", "published_at": "2016-11-20T20:02:27+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739af18adb5", "title": "#SQLSERVERLearning : Only Execute Current Statement in SQL Server Mgmt Studio??", "url": "https://databaserookies.wordpress.com/2016/11/18/sqlserverlearning-only-execute-current-statement-in-sql-server-mgmt-studio/", "published_at": "2016-11-18T14:05:43+00:00" }, { "id": "01a0c564-1971-70b9-bad2-6739af320df4", "title": "SQL Developer : Add Custom SQL Query as Template.", "url": "https://databaserookies.wordpress.com/2016/11/17/sql-developer-add-custom-sql-query-as-template/", "published_at": "2016-11-17T12:02:14+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66ca760bd6a", "title": "#SQLSERVERLearning : Changing Short Cut in SQL Server for Query Execution.", "url": "https://databaserookies.wordpress.com/2016/11/17/sqlserverlearning-changing-short-cut-in-sql-server-for-query-execution/", "published_at": "2016-11-17T08:57:56+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66ca7fafe48", "title": "#SQLSERVERLearning : Alias are mandate for inline views", "url": "https://databaserookies.wordpress.com/2016/11/17/sqlserverlearning-alias-are-mandate-for-inline-views/", "published_at": "2016-11-17T08:10:25+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66ca880ff0d", "title": "Should we gather stats on Global Temporary Table within any Stats Job?", "url": "https://databaserookies.wordpress.com/2016/10/20/should-we-gather-stats-on-global-temporary-table-within-any-stats-job/", "published_at": "2016-10-20T09:45:47+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66ca8b201e4", "title": "Analytical Function at Rescue", "url": "https://databaserookies.wordpress.com/2016/08/18/analytical-function-at-rescue/", "published_at": "2016-08-18T12:16:18+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66ca9320ada", "title": "Gather Stats on Function based filter condition in oracle", "url": "https://databaserookies.wordpress.com/2016/06/29/gather-stats-on-function-based-filter-condition-in-oracle/", "published_at": "2016-06-29T06:30:06+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66ca94d7c47", "title": "Alias on Rownum might degrade performance in oracle.", "url": "https://databaserookies.wordpress.com/2016/06/26/alias-on-rownum-might-degrade-performance-in-oracle/", "published_at": "2016-06-26T14:03:44+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66ca98ce74a", "title": "Incorrect Refer to a column alias causing performance degradation", "url": "https://databaserookies.wordpress.com/2016/05/25/incorrect-refer-to-a-column-alias-causing-performance-degradation/", "published_at": "2016-05-24T19:59:37+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66caa417533", "title": "NVL Function Internal Behavior in Oracle for Scalar Calls.", "url": "https://databaserookies.wordpress.com/2016/02/26/nvl-function-internal-behaviour-in-oracle-for-scalar-calls/", "published_at": "2016-02-25T23:21:42+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66caae62e19", "title": "Histogram Statistics on Function based Index hidden column.", "url": "https://databaserookies.wordpress.com/2016/01/20/histogram-on-function-based-index-hidden-column/", "published_at": "2016-01-20T13:33:54+00:00" }, { "id": "01a0c56b-5e3c-729f-b2f6-a66caba5e052", "title": "Basic Understanding of Autonomous Transaction in Oracle", "url": "https://databaserookies.wordpress.com/2015/11/15/autonomous-transaction-in-oracle/", "published_at": "2015-11-14T18:32:24+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a1100013a", "title": "Outer Join tables with Filter predicates in Oracle.", "url": "https://databaserookies.wordpress.com/2015/11/08/outer-join-tables-with-filter-predicates-in-oracle/", "published_at": "2015-11-07T19:49:18+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a11168fda", "title": "Statistics history for Database objects in oracle.", "url": "https://databaserookies.wordpress.com/2015/11/05/statistics-history-for-database-objects-in-oracle/", "published_at": "2015-11-05T10:19:01+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a1191c420", "title": "SQL Developer Connection start up scripts !", "url": "https://databaserookies.wordpress.com/2015/09/22/sql-developer-connection-start-up-scripts/", "published_at": "2015-09-21T21:50:44+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a11d1b53c", "title": "Understand METHOD OPT Param for Stats in Oracle", "url": "https://databaserookies.wordpress.com/2015/04/12/understand-method-opt-param-for-stats-in-oracle/", "published_at": "2015-04-12T17:40:58+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a126b52fe", "title": "Sequence insight", "url": "https://databaserookies.wordpress.com/2015/01/06/sequence-insight/", "published_at": "2015-01-06T11:44:10+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a1326f4c0", "title": "Playing with ORDER BY clause in oracle.", "url": "https://databaserookies.wordpress.com/2015/01/01/playing-with-order-by-clause-in-oracle/", "published_at": "2015-01-01T13:22:27+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a13907faa", "title": "Analytical Function order of processing within SQL.", "url": "https://databaserookies.wordpress.com/2014/12/27/analytical-function-order-of-processing-within-sql/", "published_at": "2014-12-27T09:50:50+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a1443b948", "title": "Aggregate Function Nesting Consideration in Oracle.", "url": "https://databaserookies.wordpress.com/2014/12/17/aggregate-function-nesting-in-oracle/", "published_at": "2014-12-16T18:33:39+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a14db568d", "title": "Query Transformation playing with syntactically wrong SQL.", "url": "https://databaserookies.wordpress.com/2014/12/07/query-transformation-playing-with-syntactical-wrong-sql/", "published_at": "2014-12-06T20:29:29+00:00" }, { "id": "01a0c574-df52-72eb-a350-346a1526f2e4", "title": "Oracle 12c TOP N Pagination performance considerations.", "url": "https://databaserookies.wordpress.com/2014/12/05/oracle-12c-top-n-pagination-performance-considerations/", "published_at": "2014-12-04T20:56:39+00:00" }, { "id": "01a0c582-b2d6-7211-890d-68e9f18a6337", "title": "On Rac dbms_xplan.display_cursor will give plan if cursor is present on node connected.", "url": "https://databaserookies.wordpress.com/2014/12/04/on-rac-dbms_xplan-display_cursor-will-give-plan-if-cursor-is-present-on-node-connected/", "published_at": "2014-12-04T16:58:03+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab4cae96b", "title": "SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.", "url": "https://databaserookies.wordpress.com/2014/11/30/sql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade/", "published_at": "2014-11-30T01:33:20+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab5232841", "title": "How to replace multiple string with different multiple string in Oracle Database?", "url": "https://databaserookies.wordpress.com/2014/11/29/how-to-replace-replace/", "published_at": "2014-11-28T20:56:47+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab61b21a9", "title": "INDEX Access Path and NULL Data in Oracle.", "url": "https://databaserookies.wordpress.com/2014/11/27/index-access-path-and-null-data-in-oracle/", "published_at": "2014-11-27T18:16:44+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab649199f", "title": "NOT IN Condition and NULL Data", "url": "https://databaserookies.wordpress.com/2014/11/24/not-in-condition-and-null-data/", "published_at": "2014-11-23T21:58:33+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab6956531", "title": "Add Not NULL constraint on existing table column having null values", "url": "https://databaserookies.wordpress.com/2014/11/22/273/", "published_at": "2014-11-21T21:21:03+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab6a7c452", "title": "Rownum condition and Explain plan", "url": "https://databaserookies.wordpress.com/2014/11/18/rownum-condition-and-explain-plan/", "published_at": "2014-11-18T18:03:18+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab74792c1", "title": "Putting special character in middle of string.", "url": "https://databaserookies.wordpress.com/2014/11/18/putting-special-character-in-middle-of-string/", "published_at": "2014-11-18T16:58:34+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab78a9748", "title": "Get Difference between two date, as Year Month Day Correlated.", "url": "https://databaserookies.wordpress.com/2014/11/18/get-difference-between-two-dates-as-year-month-day-correlated/", "published_at": "2014-11-17T19:01:13+00:00" }, { "id": "01a0c582-b2d7-7045-b7ae-6fbab81a7b8a", "title": "Does Distinct operation in Oracle return sort data?", "url": "https://databaserookies.wordpress.com/2014/11/16/does-distinct-operation-in-oracle-really-return-sort-data/", "published_at": "2014-11-15T19:01:45+00:00" }, { "id": "01a0c590-b753-711f-a018-4671ecfcadf3", "title": "Explain plan Command : Why we should not rely for exact runtime plan.", "url": "https://databaserookies.wordpress.com/2014/11/11/explain-plan-command-why-we-should-not-rely-for-exact-plan/", "published_at": "2014-11-11T18:05:46+00:00" }, { "id": "01a0c590-b753-711f-a018-4671ed38117d", "title": "Dynamic Statistics in Oracle 12c", "url": "https://databaserookies.wordpress.com/2014/11/01/dynamic-statistics-in-oracle-12c/", "published_at": "2014-11-01T21:28:46+00:00" }, { "id": "01a0c590-b753-711f-a018-4671ed94dcf8", "title": "TOP N and Pagination in Oracle 12c", "url": "https://databaserookies.wordpress.com/2014/04/06/top-n-and-pagination-in-oracle-12c/", "published_at": "2014-04-06T16:14:28+00:00" }, { "id": "01a0c590-b753-711f-a018-4671ee8ce378", "title": "Online Statistics Gathering in Oracle 12c", "url": "https://databaserookies.wordpress.com/2014/04/04/online-statistics-gathering-in-oracle-12c/", "published_at": "2014-04-04T19:45:32+00:00" }, { "id": "01a0c590-b753-711f-a018-4671eef08d7d", "title": "Scalar Subquery Unnesting in Oracle 12c.", "url": "https://databaserookies.wordpress.com/2014/03/31/scalar-subquery-unnesting-in-oracle-12c/", "published_at": "2014-03-31T18:39:51+00:00" } ] posts Claim your blog
Back to databaserookies.wordpress.com
Blog · corpus.blog/blogs/databaserookies.wordpress.com/posts

databaserookies.wordpress.com

databaserookies.wordpress.com

2016

Change Date in Oracle using FIXED_DATEoriginal ↗
12 Dec 2016
Interesting Database SQL Concept Question, Give it a try??original ↗
9 Dec 2016
Multiplication across rows and Analytical Functions.original ↗
6 Dec 2016
#SQLSERVERLearning : Identity Column Insight.original ↗
3 Dec 2016
Oracle 12c : Default values on NULL.original ↗
3 Dec 2016
Aggregate Function , Distinct and NULL Values in Oracle.original ↗
1 Dec 2016
#SQLSERVERLearning : Exception on Invalid/Incorrect Hints?original ↗
24 Nov 2016
#SQLSERVERLearning : Does Unique Index Stored NULL Values in Index?original ↗
20 Nov 2016
#SQLSERVERLearning : Only Execute Current Statement in SQL Server Mgmt Studio??original ↗
18 Nov 2016
SQL Developer : Add Custom SQL Query as Template.original ↗
17 Nov 2016
#SQLSERVERLearning : Changing Short Cut in SQL Server for Query Execution.original ↗
17 Nov 2016
#SQLSERVERLearning : Alias are mandate for inline viewsoriginal ↗
17 Nov 2016
Should we gather stats on Global Temporary Table within any Stats Job?original ↗
20 Oct 2016
Analytical Function at Rescueoriginal ↗
18 Aug 2016
Gather Stats on Function based filter condition in oracleoriginal ↗
29 Jun 2016
Alias on Rownum might degrade performance in oracle.original ↗
26 Jun 2016
Incorrect Refer to a column alias causing performance degradationoriginal ↗
24 May 2016
NVL Function Internal Behavior in Oracle for Scalar Calls.original ↗
25 Feb 2016
Histogram Statistics on Function based Index hidden column.original ↗
20 Jan 2016

2015

Basic Understanding of Autonomous Transaction in Oracleoriginal ↗
14 Nov 2015
Outer Join tables with Filter predicates in Oracle.original ↗
7 Nov 2015
Statistics history for Database objects in oracle.original ↗
5 Nov 2015
SQL Developer Connection start up scripts !original ↗
21 Sept 2015
Understand METHOD OPT Param for Stats in Oracleoriginal ↗
12 Apr 2015
Sequence insightoriginal ↗
6 Jan 2015
Playing with ORDER BY clause in oracle.original ↗
1 Jan 2015

2014

Analytical Function order of processing within SQL.original ↗
27 Dec 2014
Aggregate Function Nesting Consideration in Oracle.original ↗
16 Dec 2014
Query Transformation playing with syntactically wrong SQL.original ↗
6 Dec 2014
Oracle 12c TOP N Pagination performance considerations.original ↗
4 Dec 2014
On Rac dbms_xplan.display_cursor will give plan if cursor is present on node connected.original ↗
4 Dec 2014
SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.original ↗
30 Nov 2014
How to replace multiple string with different multiple string in Oracle Database?original ↗
28 Nov 2014
INDEX Access Path and NULL Data in Oracle.original ↗
27 Nov 2014
NOT IN Condition and NULL Dataoriginal ↗
23 Nov 2014
Add Not NULL constraint on existing table column having null valuesoriginal ↗
21 Nov 2014
Rownum condition and Explain planoriginal ↗
18 Nov 2014
Putting special character in middle of string.original ↗
18 Nov 2014
Get Difference between two date, as Year Month Day Correlated.original ↗
17 Nov 2014
Does Distinct operation in Oracle return sort data?original ↗
15 Nov 2014
Explain plan Command : Why we should not rely for exact runtime plan.original ↗
11 Nov 2014
Dynamic Statistics in Oracle 12coriginal ↗
1 Nov 2014
TOP N and Pagination in Oracle 12coriginal ↗
6 Apr 2014
Online Statistics Gathering in Oracle 12coriginal ↗
4 Apr 2014
Scalar Subquery Unnesting in Oracle 12c.original ↗
31 Mar 2014
Previous