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 bkrike 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

    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 =...
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. BenjaminLim

    How to display counter on runtime?

    Hi, I need help to 1. Put a counter(need synthax for this) in the loop (witin a Procedure), I am using cursor to extract records. 2. Display the final counter value upon completion of extraction. 3. As I am generating an ASCII file and the program somehow just generate the ASCII file half...
  13. BenjaminLim

    How to view the access priviledge granted to all users (include admin)

    Hi, Please advice how can I view the access priviledge to tables, views, etc granted to all users (including administrators) Please advice. Thanks. Regards Benjamin
  14. BenjaminLim

    Encrypt Password & stored it encrypted

    Hi, Please advice what are the synthax to encrypt password using VBA & store them in the Oracle database still encrpyted. Please advice. Thanks. Regards Benjamin
  15. BenjaminLim

    Encryption of password & stored as encrypted

    Hi, Please advice what are the synthax to encrypt password using VBA & store them in the Oracle database still encrpyted. Please advice. Thanks. Regards Benjamin
  16. BenjaminLim

    Encryption of password & stored as encrypted

    Hi, Please advice what are the synthax to encrypt password using VBA & store them in the Oracle database still encrpyted. Please advice. Thanks. Regards Benjamin
  17. BenjaminLim

    Encryption of password

    Hi, Please advice what are the synthax to encrypt password using VBA & store them in the Oracle database still encrpyted. Please advice. Thanks. Regards Benjamin
  18. BenjaminLim

    Encryption of password

    Hi, Please advice what are the synthax to encrypt password & store them in the Oracle database still encrpyted. Please advice. Thanks. Regards Benjamin
  19. BenjaminLim

    Comparison tool for comparing differences in program versions

    Hi, Please advice what are the tools available to compare the version of a Oracle form v4.5 or Oracle report v2.5 programs. Rationale behind is to prevent unauthorised changes to programs however by going through the screens or the designer it is rather tedious. That is I need to ensure that...
  20. BenjaminLim

    Call MS Outlook from Oracle Form v4.5

    Hi, I will like to call MS Outlook from Oracle Form v4.5 & pass some parameters from Form to Outlook. That is : 1. Open Oracle Form v4.5 and by activating certain trigger open MS Outlook application. 2. Pass the relevant parameters to the MS Outlook e.g. sender's name to default to logon...

Part and Inventory Search

Back
Top