Explore >> Select a destination
|
You are here 
|
dohdatabase.com | ||
| | | | |
connor-mcdonald.com
|
|
| | | | | When I'm troubleshooting, a common workflow for me isextract a problematic SQL statement from V$SQL or V$SQLSTATS or an AWR report.drop the SQL text into SQL Developer or VS Code so that I can format it into a more readable format.That was starting to frustrate me so I thought: "Why not have a SQL Formatter... | |
| | | | |
timurakhmadeev.wordpress.com
|
|
| | | | | If you were an Oracle developer and you were asked to implement a small part of the JDBC driver functionality - the getIndexInfo() method of the java.sql.DatabaseMetaData interface - how'd you do that? The API states following requirements: ResultSet getIndexInfo(Stringcatalog, Stringschema, Stringtable, booleanunique, booleanapproximate) throws SQLException Retrieves a description of the given table's indices and... | |
| | | | |
juliandontcheff.wordpress.com
|
|
| | | | | On October 18th 2022, Oracle announced the new long term release of 23c Beta. Here is a compiled list of the new features I am aware of: OLTP and Core DB: Accelerate SecureFiles LOB Write PerformanceAutomatic SecureFiles ShrinkAutomatic Transaction AbortEscrow Column Concurrency ControlFast Ingest (Memoptimize for Write) EnhancementsIncreased Column Limit to 4kManaging Flashback Database Logs... | |
| | | | |
iusoltsev.wordpress.com
|
|
| | | ??????? ?????? ?? ??????? ??????????? 465 ??????! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%????????%' OR A.LASTNAME LIKE '%????????%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ??? ???????, ????????? ???? ?? ??????? A.COMPANY_ID = 1 ???????? ??????? ???????????????? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT... | ||
