archives

Cursor_sharing=similar and Stored outlines or SQL Profiles

I am using Oracle 10.2.0.3 on Windows 2003. My project Currently uses cursor_sharing=force which nesures after syntheitised bind variables are creasted, if two sql statements are identical they will use same sstore doutline or Sql profile becuas ethese are based on sql sataements. What happens when cursor_sharing=similar which looks at literal values

Cursor_sharing=similar and Stored outlines or SQL Profiles

I am using Oracle 10.2.0.3 on Windows 2003. My project Currently uses cursor_sharing=force which nesures after syntheitised bind variables are creasted, if two sql statements are identical they will use same sstore doutline or Sql profile becuas ethese are based on sql sataements. What happens when cursor_sharing=similar which looks at literal values

Do I UPDATE or INSERT? UPDATE or INSERT?... Why not MERGE?

You're writing a DB2 application program and the program needs to handle a piece of data without knowing if a record exist in the table for this piece of data. Enter into the picture DB2 9 for z/OS and the introduction of the SQL MERGE statement. The major database players all have some form of the MERGE statement.

FAQ 7.16 How do I create a static variable?

This is an excerpt from the latest version perlfaq7.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

FAQ 7.16 How do I create a static variable?

This is an excerpt from the latest version perlfaq7.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

FAQ 7.22 What's the difference between calling a function as &foo and foo()?

This is an excerpt from the latest version perlfaq7.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

XML::Simple how to force hash generation for keys

Hi, I use XML::Simple to parse the following small XML file: <test> <firstElem> <anything id="1" value1="v11" value2="v12"/> </firstElem> <secondElem> <anything id="2" value1="v21" value2="v22"/> <anything id="3" value1="v31" value2="v32"/> </secondElem> </test> Perl-Scipt:

How to join two tables while one is using Date and another is using Timestamp?

How to join two tables while one is using Date and another is using Timestamp on Oracle, for example, select * from Orders o, AuditLog a where o.TradeDate = a.EventTs Orders ======= TradeDate (Date) e.g. 14-JUN-08 AuditLog ========= EventTs (Timestamp) e.g. 12-JUN-08 10.28.53.083000000 AM Thanks! Regards

How to join two tables while one is using Date and another is using Timestamp?

How to join two tables while one is using Date and another is using Timestamp on Oracle, for example, select * from Orders o, AuditLog a where o.TradeDate = a.EventTs Orders ======= TradeDate (Date) e.g. 14-JUN-08 AuditLog ========= EventTs (Timestamp) e.g. 12-JUN-08 10.28.53.083000000 AM Thanks! Regards

artful dodger lascoste t-shirts wholesale

[link] – crown dsquared jacket prices, reviews, and ratings in Clothing and Accessories . Compare products and find the lowest prices on crown dsquared jacket china supplier at [link]

artful dodger lascoste t-shirts wholesale

[link] – crown dsquared jacket prices, reviews, and ratings in Clothing and Accessories . Compare products and find the lowest prices on crown dsquared jacket china supplier at [link]

FAQ 7.12 How can I tell if a variable is tainted?

This is an excerpt from the latest version perlfaq7.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Create view from DBA_ROLES for non-privileged users?

Is it possible to create a view based off DBA_ROLES so that a non-DBA user can keep track of which users belong to roles associated with his department? In this case, all roles associated with the specific department are named with a common prefix, e.g. ABC_<rest of role name>. I'm thinking of something like the following:

EPIC and "my" variables

I am running eclipse 3.3.2 on MS Vista with cygwin. I have installed padWalker but still can't see the "my" variables when I debug. Any ideas?

What's with a warning for a long running read only program?

DB2 has three safeguards in the form of DSNZPARM keywords. These safeguards monitor DB2 for "misbehaving" transactions - those that span a high number of log records, run for a long time without commits, or involve long-running reads.

Learning Perl

Here is a set of flashcards our developers have been using to learn Perl with very good results: [link] Add the subject to your study materials, click on try a learning drill. This is an example of one person's study materials, but you can make your own as well. We are adding features to the site to allow users to