Blog: Laurent Schneider

210 blogs updated: 22 min. ago
How to get dbms_output to print line before the end of the procedure?
begin dbms_output.put_line('K ilroy1'); dbms_lock.sleep(1); dbms_output.put_line('K ilroy2'); dbms_lock.sleep(1); dbms_output.put_line('K il...
08-03-2018 18:34:21 Laurent Schneider Oracle
Dynamic number of columns revisited
Itching to start playing with 18c? Now you can on @oraclelivesql ! Here's a script to get you started: a dynamic CSV-to-columns converter us...
17-02-2018 19:17:24 Laurent Schneider Oracle
better than CTAS
SQL> create table t1(x number primary key); Table created. SQL> desc t1 Name N ull? Type ----------------------- -------- ---------------- X...
11-01-2018 14:26:21 Laurent Schneider Oracle
FBI = function based index
Let me today tell you, I now hate FBI for real. Let's start with an easy working example SQL> CREATE TABLE t(x NUMBER PRIMARY KEY) Table cre...
21-11-2017 14:00:34 Laurent Schneider Oracle
Administrative privileges like SYSDBA
The most well-known administrative privilege is sysdba. Back in Oracle 7.2, oracle recommended to no longer use the INTERNAL but to connect ...
16-11-2017 15:34:19 Laurent Schneider Oracle
check invalid directories
To get the status of a directory, I wrote my own function, which uses DBMS_LOB.FILEEXISTS. CREATE FUNCTION status (DIRECTORY_NAME VARCHAR2) ...
27-09-2017 18:23:36 Laurent Schneider Oracle
check invalid database link for the DBA
followup of check invalid database link If you need to check db link in another schema, you need to create code that run with that schema. b...
27-09-2017 11:49:10 Laurent Schneider Oracle
check invalid database link
If one database link is invalid, you cannot select through it SQL> select * from dual@z; select * from dual@z * ERROR at line 1: ORA-02019: ...
26-09-2017 10:40:19 Laurent Schneider Oracle
list targets
$p=new XML::Parser;$p->setHandle rs(Start=>&b);$p->parsefi le("-");sub b{($i,$e,%a)=@_;if($e eq"Target"){print$a{"NAME "}.":".$a{"TYPE"}}} l...
21-09-2017 18:35:19 Laurent Schneider Oracle
sid and pluggable
I wrote about SID there. (CONNECT_DATA=(SID=DB01)) is undocumented since Oracle 11gR1 and breaks things with multi-tenant / single-tenant. Y...
08-09-2017 11:26:27 Laurent Schneider Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.