<code>Hi Tom,
I can successfully do bulk insert when use a SQL type that's table of NUBMER as follows on 8.1.7.4:
create or replace type aTabType as table of number;
/
declare
c number;
i number;
aArray aTabType;
begin
aArray :...
Hi Tom,
1)How to enable auditing for DROP , CREATE and ALTER commands in 9i for all users except SYS AND SYSTEM. Objects can be table view procedure or any object
Is there a simple way ?
2) May be I can filter sys and system from au...
A long time ago, I blogged about Spring not eating its own dogfood, using Drupal for their website instead of a Java product, much less a Spring component somewhere in the mix. They're not the only high-profile Java site using non-Java and it's telling that people didn't care.
Sun officials confirmed that new online backup features will be offered to paying MySQL Enterprise users only — a plan that sparked criticism from open-source advocates.
For three years, anyone with a basic knowledge of SQL could submit their own SQL query to pull the data of their choice from the underlying database of an Oklahoma Department of Corrections Web site.
Hi Tom,
We are facing some issues while creating text indexes.
CREATE TABLE USER1.APP_COMMENTS
(
SEQ_ID VARCHAR2(16 BYTE) NOT NULL,
COMMENTS VARCHAR2(4000 BYTE)
)
CREATE INDEX USER1.COMMENTS_IDX ON ...
I need to create an application to offer a main menu, accept an option from the keyboard, and then offer submenus as needed until I can perform dml on any of 5 tables. The available tools are sql*plus and pl/sql. I know how to use accept/prompt in ...
Hello Tom,
I am looking into using Oracle Resource Manager to limit resources by AppDev folks on the production database so as allow them access yet not hurt production performance.
1) Is Resource Manager a good tool to help achieve my goal, ab...
Jerome Dochez has written "Glassfish V3 runs on OSGi," which says that since last week they are able to run Glassfish V3 on Apache Felix and Knopflerfish... and that Glassfish is going to switch to OSGi as their underlying module subsystem.
HtmlUnit 2.1 has been released. HtmlUnit allows high-level manipulation of web pages, such as filling forms, clicking links, accessing attributes and values of specific elements within the pages; you do not have to create lower-level requests of TCP/IP or HTTP, but just getPage(url), find a hyperlink, click() and you have all the HTML, JavaScript, and AJAX are automatically processed.