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!

  • Congratulations strongm 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. BenjaminLim

    Please advice what went wrong with

    I am trying to exclude only those that has (lhldgr != 'GWMLDGR' and lhbook not in ('GWM1997','GWMBUD','GWMALOVHD','GWMAOHPROD')) but I would like lhldgr = 'GWMLDGR' and lhbook = 'GWMACT' to be included. Does it sound reasonable? Alternatively kindly suggest syntax where I can extract what I...
  2. BenjaminLim

    Please advice what went wrong with

    Please advice what went wrong with the following syntax. It could not extract data that is (lhldgr = 'GWMLDGR' and lhbook = 'GWMACT') though I did not exclude it in the syntax below. But when I tried to perform select query I was able to select records that has these criteria : i.e. lhyear =...
  3. BenjaminLim

    Convert data captured Excel into Oracle database via SQL

    THoey, As I am not a DBA expert, please advice what is the command to check permission of user account. And what will be the command to use to grant them access to update to MS Access database. With the in-house application, they have no difficulty performing all access priviledges. Kindly...
  4. BenjaminLim

    Convert data captured Excel into Oracle database via SQL

    THoey, Could you explain how both work. I am trying to determine is the easier way (quick & error free if possible) The constraint I am face, I need to get the work tested in a development database & has no access to production database. My users has access to production database however...
  5. BenjaminLim

    Convert data captured Excel into Oracle database via SQL

    tlbroadbent, I am using SQL in Oracle to do this. (SQLPlus 3.3)
  6. BenjaminLim

    Convert data captured Excel into Oracle database via SQL

    Have anyone tried the above. I need help to convert columns of data captured in Excel files into Oracle database via SQL synthax. Please advice. Thanks. Benjamin
  7. BenjaminLim

    Convert data captured Excel into Oracle database via SQL

    Have anyone tried the above. I need help to convert columns of data captured in Excel files into Oracle database via SQL synthax. Please advice. Thanks. Benjamin
  8. BenjaminLim

    Convert data captured Excel into Oracle database via SQL

    Have anyone tried the above. I need help to convert columns of data captured in Excel files into Oracle database via SQL synthax. Please advice. Thanks. Benjamin
  9. BenjaminLim

    Setup of web server

    Is there a site that has a pictorial view of the above. If yes please direct me to the websites. Thanks. Benjamin
  10. BenjaminLim

    Comparison of internet tools to used

    Hi, Could someone advice which website should I refer to for comparison between Javascript, VB script, ASP, IIS, Oracle, SQL server. Please advice. Thanks. Regards Benjamin
  11. BenjaminLim

    Grant access to run select views in SQLPlus

    Hi, I could not locate the USER_PRODUCT_PROFILE table -> could you advice what can be done next? I am not holding the DBA role. Benjamin
  12. BenjaminLim

    Grant access to run select views in SQLPlus

    How do I grant access to a group (say PRODREL) and within the group there are 2 different types of users -> 1 type is application and the other type is users. For the user type of application he is allowed to access SQLPlus to retrieve data from Oracle whereas the other group should not have...
  13. BenjaminLim

    Further info. My purpose is to p

    Further info. My purpose is to pass the parameterlist to the 'where' part of the query statement. And the query is part of a cursor. Meaning: CURSOR PP_SUMMARY IS SELECT COM.Company_Name, PAY.Bank_Code, ... from... where :RPTPARAM.C_Company_Retval and... And this is then used to create an...
  14. BenjaminLim

    How to pass a parameter list into the "where" cause of a select query

    Sem, Is it possible to provide email so that I could send the query and printscreen for further discussion. Thanks.
  15. BenjaminLim

    How to pass a parameter list into the "where" cause of a select query

    Sem Could you demonstrate with an example. Regards Benjamin
  16. BenjaminLim

    How to pass a parameter list into the "where" cause of a select query

    How to pass a parameter list into the "where" cause of a select query on Oracle Forms 4.5? The parameter list allows the user to tick off the company code that they need but it could be left blank to indicate the selection of all company codes. The parameter list will be invoked with...
  17. BenjaminLim

    Synthax error for query execution

    1. I have tried but it fails -> no such column name 2. How to use replace? Show example. Thanks,
  18. BenjaminLim

    Synthax error for query execution

    Encounter the following error when executing my query. ORA-00979: not a GROUP BY expression Following is the query. 2nd question : For returning of all numbers from a field that contains besides number other characters such as /()- example : 12-123131-(0) to be returned as 121231310 Pls...
  19. BenjaminLim

    How to test last row of cursor

    Thanks. I think but question was not very clear. Need to know the last row so that if last row then output certain values else output another set of value. Please advice.
  20. BenjaminLim

    How to test last row of cursor

    How do I know within a cursor the last record selected so that I can use to determine a cause of action. Please advice. Thanks.

Part and Inventory Search

Back
Top