https://supermanhamuerto.com/ 2026-05-02T12:25:51+00:00 https://supermanhamuerto.com/ https://supermanhamuerto.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=oracle:dsnwithnopasswordasking&rev=1670014949&do=diff Configure an ODBC Data Source with no password request Intro When working with access, or whatever application, it's an annoying thing that everytime we open an Oracle linked table it request the password of the connection. Moreover, if you try to make any sort of application (macro, visual basic, etc.), because this password is requested interactively, stops the application of working until a correct password is provided by the user. text/html 2024-10-05T17:05:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=oracle:fixhtml&rev=1728147936&do=diff Fix or Sanitize HTML Yes: I've found the silver bullet for those of you who are seeking for a function that clean html code or sanitize it, specially if it comes from a cut and paste operation from word. To the point. This snippet: select dirty, strip_html(dirty) from dual; text/html 2024-10-05T17:04:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=oracle:index&rev=1728147896&do=diff Oracle Pues sí, inicio esta página dedicada a truquillos de oracle: poner el “nextval” en un número de secuencia. * Fix or sanitize HTML code from oracle * Configure an ODBC Data Source with no password request * How does full join work??? Poner el valor siguiente (nextval) en un número de secuencia Si sois lo suficientemente osados para consultar la text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=oracle:meaningoffulljoin&rev=1670014949&do=diff How does full join work??? Despite I am seasoned sql developer, sometimes I have doubts on how exactly full join work; so I decided to implement this simple test to see this working. Let's say we have two tables: create table test1 (field varchar2(100)); create table test2 (field varchar2(100)); -- unique values for table test1 insert into test1 values ('a'); insert into test1 values ('b'); insert into test1 values ('c'); -- unique values for table test2 insert into test2 values ('1'…