• Need help on Oracle SQL formulation

    I have a requirement where data is as below: ID            Date                 Comments 101         23/Jun/2018      RR: Insufficient resource 101         23/Jun/2018      Next week apply for leave 102         22/Jun/2018      NULL 103       ...

    shr12345 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:
  • How to find host name?

    How can I find my host name?

    Rcongo10 pointsBadges:
  • How do I insert, update and delete works (internally) in Oracle database?

    Can you explain the states of DB buffer cache, redo log buffer, undo table space etc, when DML statements are executing?

    Pulak555 pointsBadges:
  • I forgotten my user name and password of Oracle 10g express edition.

    I'm using oracle 10g express edition, I forgotten my username and password so please suggest me any idea to recover the username and password or tell me any other possibilities to reset the username and password.

    Sreekannan5 pointsBadges:
  • 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,153,200 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:
  • 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,153,200 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...

    ToddN2000135,525 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,153,200 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:
  • 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:

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