Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?
Answer Question | July 21, 2004 3:01 AM
Architecture/Design, Development, Installation/Upgrade, Oracle, Oracle 8i, Oracle 9i, SQL
Hi, Is it possible to execute Excel Macros from PL/SQL procedure ?
Answer Question | July 16, 2004 3:05 AM
Can you order by a column number, if so, what’s the syntax?
Answer Question | August 8, 2010 6:13 PM
In your opinion, what’s the best PL/SQL development tool on the market, and why?
Answer Question | June 6, 2004 10:36 AM
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
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
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
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
ORA-00600 INTERNAL ERROR when inserting Hi, Database Version is 126.96.36.199, Forms Version is 188.8.131.52.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],,,,,,,. 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
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
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
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
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
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
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