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: *

  • Users: gys67
  • Content: Threads
  • Order by date
  1. gys67

    Oracle procedure

    Hi, I have a function written in the Oracle database that I'm using in my MS access application. How can I make a call to this function using VBA? Thanks very much!!!
  2. gys67

    Update an unbound field

    Hi, I have a form where I'm trying to update a field (field2) using the data from another field (field1). Both the data fields have been created as unbound data fields in the form. What I would like to do is, use the 1st character from field1, which is a drop down box and update field2 with it...
  3. gys67

    How Do I Define Alias in MS ACCESS?

    Hi I am trying to convert a pl/sql query in MS ACCESS query. SELECT student_name FROm student s WHERE EXISTS (SELECT * FROM math_club m WHERE m.student_id = s.student_id) NOw How do I write this in MS Access? Please Help Thanks
  4. gys67

    I want help in runing Shell script

    Hi : I am a new unix user. I am using ftp to connect to unix server. Now I need to run a shell scrip How do i do that? Please help. Thanks
  5. gys67

    Hi : I am trying to write a quer

    Hi : I am trying to write a query in MS Access. I need to concatenate 3 to 4 fields. How do I do that? Please help Thanks
  6. gys67

    Performence Issue for MS Access Query

    I have following query (Table and Column names are changed) . It takes hours to run. Please help to Improve performence. SELECT [k].[ID], [k].[PROGRAM], [k].[STATE], [k].[QUARTER], [k].[NDC], [k].[NDC_DC]...
  7. gys67

    Performance Issue for a query

    Hi : I have an issue of performence in one my oracle pl/sql procedure. This procedure gets data from oracle view and compares it with existing table. Depapnding on the comparision , it writes results to an un indexed table. The volume of data is very high and procedure takes hours to run In...
  8. gys67

    How Do I install & Configure Oracle 9i ON PC with XP

    I am having trouble in installing oracle 9i on XP op. sys. It is getting installed but I do not know , what are the steps to configure the server. Please help. Thanks GYS
  9. gys67

    HOW DO I OPTIMIZE MULTIPLE IFS?

    Begin IF nvl(mv_xyz_id,'A') = 'A' then if (nvl(mv_rec.sec_b_id,'B') <> 'B') and (mv_rec.sec_b_id_type = 'XYZ') then m_b_end_date_2 := to_char(sysdate-1,'YYYYMMDD'); end if...

Part and Inventory Search

Back
Top