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...
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 =...
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...
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...
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
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
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
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
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...
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...
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.