Oracle Help
in [SQL]
|
bind parameter in existsnode function Got it... the two single quotes around the values in the @Value and @Name statements are escape characters too. This value //Key[@Value='True'] and //Key[@Name='Validation Status'] may be bound to a parameter just fine. ... 19 Jun 2008 01:14
REF CURSOR Hi, I may be answering my own question, but I want to make sure. Say I have a ref cursor that has a dynamic where clase, and in addition a bind variable that changes each time through the loop: OPEN cust_ref FOR 'SELECT customer_name, customer_address FROM customer WHERE customer_id = :v_customer... 19 Jun 2008 01:14
Los Angeles Locksmith Services, Lockout Rekey Install Locks and Keys Made Home Car Auto Los Angeles Locksmith Services, Lockout Rekey Install Locks and Keys Made Home Car Auto http://locksmithhome.com/default.aspx ... 19 Jun 2008 01:14
SUBSTR & INSTR Hi, I'm looking to parse an email. Say I have an email like this: johnjones(a)gmail.abc.def.ghi.com I basically want johnjones(a)gmail.abc.def.ghi in one variable and the .com in the other. If the email is this: jjones(a)amail.co The same, I basically want jjones(a)amail.co in one variable and the .com i... 19 Jun 2008 01:14
ORA-00911 error and COMMIT Hi, I'm been playing with using Filemaker Pro to generate and send sql to an Oracle 10g database. The following works fine: UPDATE BEVIS_DL_TEST_RESULTS_ENTRY SET BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_VALUE = 'A section of liver is examined microscopically. ' WHERE BEVIS_DL_TEST_RESULTS_ENTRY.RESULT_NAM... 19 Jun 2008 01:14
Java Oracle Database Development Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses w... 19 Jun 2008 01:14
ufsdump output from oracle Hello, Recently we installed Oracle Enterprise Manager. We keep the processes of this tool running (so we didn't stop them with emctl), but shutdown the databases because we wanted to know what kind of messages were generated and what the effect would be on ufsdump. Ufsdump didn't complain. During the last full... 19 Jun 2008 01:14
WORK PART TIME GET $100 A WEEK CLICK HERE WOW!! Get seen -- get paid! You can now get paid to drive your car, wear T-shirts, and more! Just join the EyeEarn Advertising Network and start earning money effortlessly while you go about your day! It's fun, easy, and no experience is necessary! http://www.eyeearn.com/10122618/signup ... 19 Jun 2008 01:14
Views Hi, We use TOAD as our GUI to see the database. I put in a query that selects from V$SQL, but I get a missing expression. The same query works from within SQLPLUS. Even it I change it to V_$SQL, no good. Is there something special with these dictionary tables??? Thanks! John ... 19 Jun 2008 01:14
Triggers Hi, We have an update trigger on a table for some auditing purposes. Is there a way to find the actual program that updated the underlying table? I hope it is not like 40 lines of code....... :) Thanks! John ... 19 Jun 2008 01:14 |