Long running Delete Jobs
We have delete jobs which delete a lot of records belonging to one Version of data that runs for sometimes 2 days. The relation to this Dataversion is done by one Column in each Table whith the same value called Versionnumber. Lots of the tables are conected with cascaded deletes. How can I determine which [...]

Answer Question   |  June 7, 2004  8:40 AM
SQL

execute immediate
Can anyone remind me what EXECUTE IMMEDIATE does, and what are the pros and cons of using it versus regular dynamic SQL refcursor fetch. Thanks.

Answer Question   |  June 22, 2004  12:59 PM
Architecture/Design, SQL

SQL string limitation
Oracle8i SQL I wrote a query below that pulls in the procedure code from application specific metadata. I wrote it to search up to 4 levels deep of the 2000 character string object_text column. When object_seq greater than 1 exist it will concatenate the code. The SQL bums if it finds more than 2 rows [...]

Answer Question   |  May 24, 2004  12:27 PM
Architecture/Design, SQL

Powered By SQL Server
I am currently developing an ASP.NET web site using SQL Server as the backend database. Has anyone come across a ‘Powered By SQL Server’ icon that I can freely use on my web site? Or failing that just a good SQL Server graphic around 80-130 x 30-40 pixels in size.

Answer Question   |  May 20, 2004  9:50 PM
SQL

ORA-00600 INTERNAL ERROR when inserting
ORA-00600 INTERNAL ERROR when inserting Hi, Database Version is 8.1.7.2, Forms Version is 6.0.8.17.1 When the user click a button that inserts into a table, they used to get the following message: ORA-00600 INTERNAL ERROR CODE,arguments:[qersoGBnosortRowP],[1],[],[],[],[],[],[]. The insert statement was of the form: insert into target_table(index,program,fiscal_year) select distinct index,program,fiscal_year from temporary_table group by index,program,fiscal_year,object,object_detail. The [...]

Answer Question   |  May 20, 2004  1:40 PM
SQL

Default values in Oracle packaged procedures
What is the best way to conceal default packaged procedure parameter values? I thought of this way: Make default values NULL in the specification Make default values whatever you want them to be in the package body. Wrap (encrypt hex) package body. I need this in order to obfuscate the use of this package to [...]

Answer Question   |  May 22, 2004  12:33 PM
Oracle, SQL

DISTINCT or work-around
Greetings from Vijay, Consider table B as below with columns b1 and b2. Table B B1 B2 ========== 1 abc 2 xyx 3 abc 4 efg 1 xyx 3 abc 4 car 5 edf Query 1 ========= select distinct b2 from B Output : ====== B2 ============ abc car edf efg xyx Explain Plan: Query [...]

Answer Question   |  May 22, 2004  12:04 PM
Oracle, Performance/Load, SQL, Tech support

Reading Long Column
How do I perform string functions on the datatype LONG? Ex. All_triggers table have column Trigger_body with datatype long. How can I get the contents of the column?

Answer Question   |  May 13, 2004  11:29 PM
SQL

Database groups in Ireland
Do you know of any associations in Ireland that specialize in Database work, such as an Oracle Users Group?

Answer Question   |  June 3, 2004  4:24 PM
Oracle, SQL

Oracle Reports development & Oracle Conurrent Manager
In developing using Oracle Reports, the report runs fine on the workstation through the developer tool, however when we port the .rfd to Unix and run through the Oracle Apps concurrent manager there are errors in formatting. The error messages generated are not always sufficient to determine which frame or field the error is from. [...]

Answer Question   |  May 14, 2004  1:58 PM
AIX, Oracle, Oracle Application Server, SQL

pros and cons of using synonyms for packages’ deployment
Are there disadvantages to using synonyms for plsql packages from performance or maintenance point of view? Paulina.

Answer Question   |  May 14, 2004  11:05 AM
Architecture/Design, SQL