• Use of multiple SET/WHERE clauses in the MERGE of 2 Oracle tables

    Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in an...

    Ejpeth15 pointsBadges:
  • Oracle Forms 6i

    Hi... I am trying to connect to Oracle database using Forms6i.... But it is asking database name.. I am giving Global database name.. and LOGIN is not accepted... How can I solve this Problem....... Please give necessary suggestions to LOGIN and how can i find Database names in Oracle.....?

    34395 pointsBadges:
  • SAP ECC and DB Oracle version compatibility

    Is SAP ECC 6 compatible with SGDB Oracle 9?

    LucianoBrazil5 pointsBadges:
  • number to text

    Hi. There is a problem. As in Calculation Script the data stored in Oracle Essbase (Planning) as number (property data type = currency or nonCurrency or unspecified) to transfer to an element at which property data type = "text".

    Zhivchik10 pointsBadges:
  • Analyze Statistics on Oracle 10g

    How do i run analyse statistics on oracle 10g and schedule it for sunday at 04:00 am

    Bem405 pointsBadges:
  • PL/SQL: How to check that parameter is case-sensitive?

    Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and...

    Inprise610 pointsBadges:
  • How to implement Sleep logic not using sleep() need customized

    Hi Experts, I need to implement a sleep logic in a loop i need to check for SELECT/INSERT stm if it s locked by other user i will go to sleep mode then back to earlier savepoint position eg savepoint x; INSERT/SELECT i need to check for 10 times each time sleep is for 1 sec i applied counter i...

    Inprise610 pointsBadges:
  • How do I connect Developer 2000 on one computer to Oracle 9i personal addition on another XP machine

    how to connect d2k with 9i from other machine

    D2kconnect5 pointsBadges:
  • ALTER INDEX statement

    'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i...

    Shaksing5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Search for a keyword in all columns of all database tables

    Dear Team, i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text. example : table 1: columns data empname sam empid 01 table 2 columns data deptname sam departmentid 10 table 3 columns data...

    Abdulgani5 pointsBadges:
  • How to make or check the attribute (location) in PL/SQL block?

    Hi Experts, How to make check the attribute (location) not taking the value same as city(attribute) or country(attribute) in Pl/SQL block Thanks for the help

    Inprise610 pointsBadges:
  • PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:

    how can i resolve that error? when i compile the store proc....it compiled without any errors....but in a package its throwing error

    Roopak055 pointsBadges:
  • System tables in SQL Server 2005

    What is the role of system tables in SQL Server 2005 and how do you update them?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Actuate e.reports vs Hyperion SQR

    Hello, in our organization we are evaluating for the best reporting solution tools from Actuate e.reports and Hyperion SQR, So can anybody help me to know the Pros and cons of the tools. In all aspects formatting ability, load, performance [server, client], report bursting, Software complexity and...

    Cool1235 pointsBadges:
  • oraoledb non working WHERE clause character comparison

    Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

    Jsl255 pointsBadges:
  • I need to permanently delete a re-generating job, but I can’t find its source

    I have used dbms_job.remove to remove all jobs from dba_jobs, but something is re-submitting a series of jobs every few minutes. I have disabled all triggers and all external cron jobs have been stopped... but more jobs keep getting submitted. I have a single transaction record in v$transaction...

    Jcmdba555 pointsBadges:
  • VB6 Oracle 10 Stored procedures with parameters

    I have a vb6 - RDO code that works ok with Oracle8, recently there was an upgrade to Oracle 10g enterprise. Now I get the error 40041 -> Object Collection: Couldn't find item indicated by text. 1110 lstrSQL = "{call Pyramid.Load_Tables(?, ?, 0)}" 1120 Set lrdoQ =...

    Hermes6835 pointsBadges:
  • How to run a query in PS Query using Microsoft Excel macro

    Hi, I am working on a macro in Excel that can automate the running of a query in people soft PS Query application.Result should also be save in Excel format at given path. Here is what i exactly want to do 1. Put all query name under column A.(not entire query only its name) 2. Run macro 3. query...

    Sh3210 pointsBadges:
  • Oracle SQL*Loader (sqlldr) performance tuning

    Good day, I try to optimize sqlldr, but don't know how to set the parameters. I am trying to load 21,000,000 records per day, but currently don't manage to load all data in time. The loading is always 1 day behind. I am using conventional loading (I cannot disable indexes before and after loading,...

    Ws8oBPSQ15 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following