Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smbpalepilsen

    Check to see if field has a number

    do it in for loop
  2. smbpalepilsen

    updating multiple rows using cursor

    in the update statement inside the for loop can't find the table b (alias) the update statement should read like this UPDATE en.agt_name a SET a.emp_num = i.emp_num where a.userid = i.retention_id; Ensure retention_id column is exist on the table, as per your DESC result retention_id is does...
  3. smbpalepilsen

    Spliting a Name up into 3 columns

    SELECT SUBSTR(name, 1,INSTR(name,',') -1) last_name, SUBSTR(name, INSTR(name,',') + 2, LENGTH(TRIM(name)) - (INSTR(name,',') + 3)) first_name, SUBSTR(name,-1) mid_init from table_name
  4. smbpalepilsen

    The Microsoft Jet database engine stopped

    You might want to check this out. http://www.prd-software.com.au/prd/support/kb/kbarticle.asp?id=55 OG
  5. smbpalepilsen

    Simple query problem

    zumie, UPDATE [NAMES] SET email = 0, datemodified = #01/20/2006# WHERE email IN (SELECT [Found Address] FROM [MBounce2006-01-24] WHERE [email] = value_here) value_here = value to filter the record in your subquery. I'm assuming you are updating 2 columns...
  6. smbpalepilsen

    1Z0-141 Reviewer

    Gurus, I'm planing to take an exam for 1Z0-141 Oracle9i Forms Developer; Build Internet Application. Any reccommended sites where I can buy the practice test. Thank you very much Best Regards, OG
  7. smbpalepilsen

    How do I load numeric into char using SQL Loader

    Use SUBSTR I tried this and it works. Text File: (File Name LOAD_DATA.TXT) 1,99999999.99 2,99999999.99 3,99999999.99 4,99999999 5,99999999 6,99999999 7,99999999 8,99999999 9,99999999 10,99999999 CTL File: LOAD DATA INFILE 'LOAD_DATA.TXT' INTO TABLE tbl_name FIELDS TERMINATED BY ','...
  8. smbpalepilsen

    Simple PL/SQL question

    Mufasa, I cut and paste the example I have posted into the sql prompt and here is the result. FYI, DECODE command can be use also and will produce thesame reult. Hope this will help. Regards, OG SQL> SELECT last_name, job_id, salary, 2 CASE job_id WHEN 'IT_PROG' THEN 1.10*salary...
  9. smbpalepilsen

    Simple PL/SQL question

    I have seen your syntax, the CASE immidiately followed by WHEN. Try this Syntax: CASE expr WHEN comparison_expr1 THEN return_expr1 WHEN comparison_expr2 THEN return_expr2 ELSE else_expr END Ex: SELECT last_name, job_id, salary, CASE job_id WHEN 'IT_PROG' THEN...
  10. smbpalepilsen

    Certification Practice Test Exam

    Thank you very much sir. I really appreciate it
  11. smbpalepilsen

    Certification Practice Test Exam

    Gurus, Any suggestion which is best site to buy the 9i PL/SQL Certification Practice Test Exam. Thank you very much. OG
  12. smbpalepilsen

    Certification Practice Test

    Gurus, I'm planning the take an exam for the 9i PL/SQL this month. Any suggestion which site is the best to buy this Certification Test. Thank you very much. Best Regards, OG

Part and Inventory Search

Back
Top