• ASFU licensing

    When implementing PREMIA solution, is ASFU the best way to go as opposed to EE Perpetual licensing? This considering that QV is gonna be an integrated system, along side other application systems. Which one is more economical with enhanced functionality

    KIM20185 pointsBadges:
  • 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,101,740 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,101,740 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...

    ToddN2000115,410 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,101,740 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,101,740 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:

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