• 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.

    Paulina0 pointsBadges:
  • 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...

    Mysterky0 pointsBadges:
  • Best PL/SQL Tool?

    In your opinion, what's the best PL/SQL development tool on the market, and why?

    Nmarco0 pointsBadges:
  • Database groups in Ireland

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

    Pegasusdba0 pointsBadges:
  • 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...

    NOCOPY0 pointsBadges:
  • 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 1 ===================== Operation...

    Vijaysai0 pointsBadges:
  • 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...

    NOCOPY0 pointsBadges:
  • 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.

    Shandy0 pointsBadges:
  • ORA-00600 INTERNAL ERROR when inserting

    ORA-00600 INTERNAL ERROR when inserting Hi, Database Version is, Forms Version is When the user click a button that inserts into a table, they used to get the following message: ORA-00600 INTERNAL ERROR...

    OnlyOracle0 pointsBadges:
  • 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.

    Paulina0 pointsBadges:
  • 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...

    Holtmeyer0 pointsBadges:
  • 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?

    Punitnb0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.