I remember hearing someone talking about this years ago and I never actually took the time to check it out. It looks like the real answer is “it depends”. For the basic loop processing and maths the JVM does look a little faster. It was just a curiosity thing, but I thought I might as [...]
wpg_docload is a pl/sql procedure to load attachments. Have you created the proxypass rules for DADs too ?…
Oracle Magazine Sep/Oct features articles on Oracle Exadata, Database Security, Oracle Enterprise Manager 11g, PL/Scope to analyze your PL/SQL, Using Oracle Essbase Release 11.1.2 Aggregate Storage Option Databases, Oracle Application Express 4.0 Websheets, Oracle Automatic Storage Management disk groups, Tom Kyte revisits a classic, recounts Cardinality Feedback, and remembers SQL*Plus and much more.
Dive into Edition-Based Redefinition at OpenWorld Has Oracle snapped in the last piece of the availability puzzle? With Edition-Based Redefinition (EBR), it appears that they have. EBR is a new feature in Oracle Database 11g Release 2 that enables customers to upgrade their database applications while the application is still online. Oracle Publishing’s senior editor, [...]
Dive into Edition-Based Redefinition at OpenWorld Has Oracle snapped in the last piece of the availability puzzle? With Edition-Based Redefinition (EBR), it appears that they have. EBR is a new feature in Oracle Database 11g Release 2 that enables customers to upgrade their database applications while the application is still online. Oracle Publishing’s senior editor, [...]
SQLPLUSには、11gの新機能として、エラー・ロギングの機能が追加されました。 SQL、PL/SQLおよびSQL*Plusのエラーと関連パラメータがエラー・ログ表に記録されます。 このログ表をSQLで問い合せすることで、発生したエラーを確認できます。 エラー・ロギングがONにすると、問合せが対話型であれスクリプト実行であれ、エラーが記録されます。 これは、長時間実行される問合せの際のエラーの取得に特に有効です。 SPOOLコマンドを使ってすべての出力の取得することなく、エラーのみを取得することができます。 この機能に関しては、一つポイントが有ります。 SQL*Plus 11gの新機能の新機能なので、Database Serverは11gでなくても利用可能なのです。 それでは、簡単に使ってみます。（例は、11gのSQLPLUSから、9i Databaseへの接続です） ———————————————————————————————— ■SQLPLUSを起動します。 $ sqlplus scott/tiger@9i SQL*Plus: Release 11.2.0.1.0 Production on 木 8月 19 11:51:42 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Oracle9i Enterprise Edition Release 9.2.0.8.0 – Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 – [...]
I’m running 10g XE on Windows Vista and I was just playing around looking at v$sysstat. The following pl/sql code works fine when run as system (not as sysdba)…
hi, Tom. I have a question regarding to_char function converting number to varchar. Somehow I got errors in PL/SQL statement saying "ORA-06502: PL/SQL: numeric or value error: character string buffer too small". Then I ended up with fi…
Hi Tom, In my pl/sql program I get date in format of string .. say like ’2010/06/30 00:00:00′ Now I need to convert this into a date and pass it as a parameter to another program.. what is the best way to that.. do i need to read nls_dat…
It would be better to search this forum before you ask any question. You can add your business logic in application modules. You can also use pl/sql packaged based web services, in that case put your logic in pl/sql.…