Tweetovi
- Tweetovi, trenutna stranica.
- Tweetovi i odgovori
- Medijski sadržaj
Blokirali ste korisnika/cu @sqldaily
Jeste li sigurni da želite vidjeti te tweetove? Time nećete deblokirati korisnika/cu @sqldaily
-
Prikvačeni tweet
#SQL is the most in-demand US tech skill (according to Indeed) And has been for years! Learn this valuable language in the FREE online course, Databases for Developers: https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html … https://www.hiringlab.org/2019/11/19/today's-top-tech-skills/ …pic.twitter.com/yrEt9Na1HW
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
If a
#SQL query switches from a fast plan to a slow one, get the fast plan back with SPM * Capture the 'problem' SQL statement plan in a SQL plan baseline * Run the SPM evolve task for this SQL plan baseline * Accept the recommended plan@vldbb explainshttps://blogs.oracle.com/optimizer/repairing-sql-performance-regression-with-sql-plan-management …Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Want to find all the rows in one table with (at least) one matching row in another? Use EXISTS select * from t1 where exists ( select * from t2 where t1.col = t2.col ) Or use NOT EXISTS to find the unmatched values
@vlad_mihalcea discusses https://vladmihalcea.com/sql-exists/#SQLpic.twitter.com/VFSt6VkqOf
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Want to extract data to CSV format to read in
#Excel? Run the following@oraclesqlcl or@OracleSQLDev SET sqlformat csv SET feedback off SET echo off spool results.csv SELECT * FROM ... / SELECT * FROM ... / spool off@thatjeffsmith explains https://www.thatjeffsmith.com/archive/2019/06/quick-tip-spooling-to-excel/ …#SQLpic.twitter.com/6cr5ALW84F
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
“If you write
#SQL that is technically incorrect it’s not Oracle’s fault if sometimes the SQL completes without an error" -@JLOracle He shows how queries with "obviously wrong" to_number ( 'X' ) can still return no rows instead of an exceptionhttps://jonathanlewis.wordpress.com/2020/01/22/philosophy-23/ …Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
In
#JSON attributes order is "unimportant" So this { "this": "v1", "that": "v2" } equals this { "that": "v2", "this": "v1" } So how do you check this in#SQL?! With JSON_equal! select * from dual where JSON_equal ( j1, j2 )@alexnuijten demos https://nuijten.blogspot.com/2018/10/odc-appreciation-day-comparing-json.html …Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Why is my
#database SLOOOOOOOOOOW?!!@thatjeffsmith shows you how to use the Instance Viewer in@OracleSQLDev A handy performance dashboard showing what's going on in See the tour at https://www.youtube.com/watch?v=VH96VIQawKA …pic.twitter.com/xsg2hJDoix
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Automatic Indexing in Oracle's Autonomous Database analyzes your application's
#SQL Then creates indexes needed to make it faster All by itself But how does it work?@richardfoote has been digging into the details Find out athttps://richardfoote.wordpress.com/category/automatic-indexing/ …Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
BETWEEN is inclusive at the start and end, so: c1 BETWEEN v1 AND v2 Is the same as c1 >= v1 AND c1 <= v2 This can lead to double-counting the end value It's better to use: c1 >= v1 AND c1 < v2 + 1 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2858890655722 …
#SQLHvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
The key to fast
#SQL is * acquire the data we need as efficiently as possible * post-process the data ... as efficiently as possible With careful index engineering you can meet these goals In this case study,@JLOracle shows you how to do thishttps://jonathanlewis.wordpress.com/2020/01/20/index-engineering/ …Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Want to access tables in another schema without having to type the schema name? You can create a synonym: create synonym your_usr.tab for other_usr.tab Or in
@OracleDatabase run: alter session set current_schema = other_usr https://asktom.oracle.com/pls/apex/asktom.search?tag=alter-session-set-current-schema …#SQLHvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Databases store DATE/TIMESTAMP values in an internal format If you want to show these value in a given format, e.g.: DD MON YYYY or YYYY MM DD HH24:MI you need to set the format when querying the values https://stackoverflow.com/questions/1837974/oracles-default-date-format-is-yyyy-mm-dd-why/1838369#1838369 …
#SQLHvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
GROUP BY <> ORDER BY ! Grouping data *might* return the values in the "correct" order But this is NOT guaranteed If you need ordered results, sort the groups: GROUP BY c1, c2, ... ORDER BY c1, c2, ... https://blogs.oracle.com/oraclemagazine/having-sums-averages-and-other-grouped-data …
#SQLHvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Want to split a C,S,V to rows? Join to a table with NUM VALUEs rows Substring the values out select regexp_substr(col, '[^,]+', 1, r.l) from tab, lateral ( select level l from dual connect by level <= length ( regexp_replace (col, '[^,]+') ) + 1 ) rhttps://stackoverflow.com/questions/14328621/splitting-string-into-multiple-rows-in-oracle …
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Tables are the foundation of your
#database There are many types, including - Heap organized - Index-organized - External - Temporary - Partitioned - Clustered Each has its pros and cons So it's worth thinking about which type to use Learn more athttps://www.youtube.com/watch?v=x2NNIo6riUI …Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
To tune
#SQL statements, you need to see what the database did You can view this in the execution plan@SQLMaria shows you how to do this using DBMS_XPLAN.DISPLAY_CURSOR https://sqlmaria.com/2017/08/08/using-dbms_xplan-display_cursor-to-examine-execution-plans/#comment-3594 …pic.twitter.com/RSQCHO7J4a
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Using Liquibase to automate your database deployments? You can now use
@oraclesqlcl to generate and apply database changelogs@oraclebase shows you how https://oracle-base.com/articles/misc/sqlcl-automating-your-database-deployments-using-sqlcl-and-liquibase …pic.twitter.com/Iuw3HQcchb
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
A NATURAL JOIN infers the join criteria from the column names So if T1 & T2 have ID & INS_DATE, then t1 NATURAL JOIN t2 => t1 JOIN t2 ON http://t1.id = http://t2.id AND t1.ins_date = t2.ins_date
@RebellionRider explains https://www.youtube.com/watch?v=2uc3UcOBp5A …#SQLHvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
The physical design of your database tables - how the data are stored - makes a huge difference to the performance of your
#SQL@connor_mc_d discusses 3 common mistakes, - NOT setting PCTFREE - NOT using compression - NOT using index-organized tables https://www.youtube.com/watch?v=jOe-TDvmJdg …pic.twitter.com/q4zEe9iK0d
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
DDL in Oracle Database commits... ...unless you're creating a PRIVATE TEMPORARY TABLE Which means you can create one part-way through a transaction And still rollback work before it https://blogs.oracle.com/sql/how-to-rollback-after-create-table-commits-in-oracle-database …pic.twitter.com/uurxEIyram
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi -
Want an auto-incrementing numeric column? Use an IDENTITY! <col> int generated [ always | by default [ on null ] ] as identity
@oraclebase discusses https://oracle-base.com/articles/12c/identity-columns-in-oracle-12cr1 …#SQLHvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi
Čini se da učitavanje traje već neko vrijeme.
Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.