• How to group by alias in Oracle

    How would I be able to "group by" a query using an alias. Something like this: select count(*), (select * from....) as alias_column from table group by alias_column The only thing is that I keep getting this 'alias_column' : INVALID_IDENTIFIER error message. What should I do here?

    ITKE1,072,585 pointsBadges:
  • What is the best method to automate password changes for service accounts, AD accounts, and Oracle Accounts?

    There is no simple way to automate SAP password changes. It is an unbearable amount of time to do. I need one simple solution like Powershell or Something else. Because their are multiple servers using the same service account, they get out of sink causing many problems all the time. The order of...

    czeusfyi5 pointsBadges:
  • What’s the better certification: Oracle or SAP?

    Currently, I'm doing a job in the telecom sector as a RF engineer. My career growth is zero. What's the better decision: SAP or Oracle certification?

    shah4455 pointsBadges:
  • Error(10601,4): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

    When I'm compiling a package, I'm getting below error. Error(10601,4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin end function pragma procedure. I'm using is Oracle 11g in SQL Developer.

    Vimalkv15 pointsBadges:
  • Passing Parameters in from Oracle Developer 10g Forms to Oracle Developer 10g Reports

    How can i pass a parameter from Oracle Developer Forms 10g forms to Oracle Reports Developer 10g report

    Mohi197410 pointsBadges:
  • Call parameter from Oracle Reports 10g web.show_doc

    Here's the code:DECLARE rep_url varchar2(2000); BEGIN rep_url:='/reports/rwservlet?' ||'&report=c:testrpt10g.rdf' ||'&desformat=htmlcss&destype=cache' ||'&userid=stlexport/stlexpst@as'; WEB.SHOW_DOCUMENT(rep_url,'_blank'); END; It's running well but now I want the report's parameter...

    Superad35 pointsBadges:
  • Cannot install Oracle 12c on Windows 10 PC

    I've been trying to install Oracle 12c on my Windows 10 PC but I keep getting this error message: Failed to add install user to %2% group Has anyone seen this before? If so, what's the fix?

    ITKE1,072,585 pointsBadges:
  • Free Database Hosting Services

    I'm looking to develop a few small web apps. I'm looking to have a few of my IT friends and family be my beta testers. What I need is a site where I can have a small hosted database that I can put in the app so they all can use it. Can anyone recommend a few alternatives? I use to have a site at...

    ToddN2000102,610 pointsBadges:
  • Does listener comes into play whenever client queries every single SQL statement?

    Does the listener comes into play whenever client queries every single SQL statement or it (listener) just connects one time only?

    praveenkns5 pointsBadges:
  • DBA user to have access only to specified schema not other schemas

    I want to give a DBA access to a user say "dbauser" but it should act as a DBA only for specified users say user1, user2, user3 not for other users in the DB. And there is other user named "otheruser1" the "dbauser" should not have a DBA access for "otheruser1" user.

    sudhamani5 pointsBadges:
  • How can I install Oracle 11g client?

    I've been trying to install Oracle 11g (client) but I keep getting this error: Environment variable: "PATH" - This test checks whether the length of the environment variable "PATH" does not exceed the recommended length. Expected Value: 1023 Actual Value : 1028 List of errors: - PRVF-3929 : Adding...

    ITKE1,072,585 pointsBadges:
  • Installing Oracle database on Windows 10 installed in Mac hardware using bootcamp

    I have some problem while I installing oracle database on windows 10 installed in mac hardware using bootcamp. How can I solve this problem? Below are my BuildPath, and errors. C:\oracle_ex>set ALLUSERSPROFILE=C:\ProgramData APPDATA=C:\Users\hyogeun\AppData\Roaming CLASSPATH=C:\Program...

    hallo885 pointsBadges:
  • Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE1,072,585 pointsBadges:
  • Export files from Oracle database by using LDT

    How can we export files from Oracle database by using LDT?

    Ijeckbabu15 pointsBadges:
  • How change work of Oracle database engine?

    When running a query, we have result of query one time. If it happens, the error while running query we will not have any result. I want to how change on database engine to have part of query if happen bug while running query. I want any search in subject. Thank you very much!

    zaheray15 pointsBadges:
  • Oracle script for total count of all personnel

    I need to spool out total count of all personnel registered by each company in a tabular format: employer..total count. How can I do that?

    monabusa5 pointsBadges:
  • How can we migrate Oracle database to Microsoft Access?

    How do I migrate an Oracle database to Microsoft Access?

    Vsrameshkumar025 pointsBadges:
  • What are dynamic and keyset-driven cursors in PL/SQL?

    What's the difference between dynamic and keyset-driven cursors in PL/SQL?

    yethis5 pointsBadges:
  • JTextArea: Limit number of characters

    For Java, would I be able to limit the amount of characters in a JTextArea row? Afterwards, I also need it to go into the second row too. Appreciate it.

    ITKE1,072,585 pointsBadges:
  • Query for Oracle Fusion HCM cloud release versions

    Hi experts, I need a query for Oracle Fusion HCM cloud with all the release versions and their differences. Can someone help?

    RajashekarB5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following