Convertire una stringa (sequenza di caratteri) in un dato di tipo data o timestamp in SQL standard è abbastanza semplice tramite il comando ‘cast‘ . Semplicemente scrivento : cast(‘2010-3-31’ as datetime) oppure cast(‘2010-3-31’ as timestamp) otteniamo la conversione, ma come sempre nel caso delle date non esiste la parola semplice, i formati con cui si…
Leggi tutto
From Embarcadero there is a new roadmap update at http://edn.embarcadero.com/article/39934 that speak about RAD Studio Solution to build native x86 applications. In particular is focused on future of Delphi / C++ Builder on cross platform and Native 64bit. regards ivan
After installing Oracle 10g on an Ubuntu 9.04 system, i found that the Apex application was enabled only for the localhost. Some time is necessary open or close the access of apex from remote. To do this is only need to access to your oracle system by a dba user and run this sql command:…
Leggi tutto
Sometimes happen that you need to extend the swap space on your system, so it happens to me when i tried to install Oracle10ex on my ubuntu system. So i found the solution on this ubuntu forum : http://ubuntuforums.org/showthread.php?t=89782 To extend the swap file to 1gb : First, create a large empty file: Code:
|
1 |
sudo dd if=/dev/zero of=/swap_file bs=1M count=1000 |
directly from Embarcadero a Steve Jobs comment about Delphi for iPhone at this link : http://blogs.embarcadero.com/pawelglowacki/2010/04/01/39048/ stay tuned ivan
Using JDBC with Oracle 10g i found this error : “ora 12519 tnsno appropriate service handler found”, today i found an article on Internet about. I only execute on apex query :
|
1 |
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE; |
after that i restarted my Oracle10gXe server on my server, and all works well !!! incredible
