A little background on the application that I am gonna talk about in the next few lines开发者_开发百科:
i am uploading keywords into the DB. but i am getting the error java.sql.SQLException: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file \'(unknown)\'.It is alread
I have an Oracle DB package that is routinely causing what I believe is an ITL (Interested Transaction List) deadlock.The relevant portion of a trace file is below.
I am currently adding Oracle 10.2.0. as a viable database to a product. The product originally allows 开发者_开发知识库connection to SQL Server and I have found some extended stored procedures.
I don\'t know the real name of that application but what i want to do is so simple, i have an oracle database with more than 50 tables. I want to get their names also their field names, so i thought t
I\'m trying to create a function in package that returns a table.I hope to call the function once in the package, but be able to re-use its data mulitple times.While I know I create temp tables in Ora
I am trying to write a simple Oracle Stored Procedure: CREATE OR REPLACE PROCEDURE act.skeleton IS DECLARE
I am using Spring\'s NamedParameterJdbcTemplate to perform an insert into a table.The table uses a NEXTVAL on a sequence to obtain the primary key.I then want this generated ID to be passed back to me
i have a java program executing 3 separate sqls with a same inline view - it takes about 20 minutes each time to build the inline view when the sqls are executed - is there a way to cache or reuse it
I\'m writing a simple diagnostic query then attempting to execute it in the Oracle 10g SQL Scratchpad. EDIT: It will not be used in code. I\'m nesting a simple \"Select *\" and it\'s giving me errors.
加载中,请稍侯......