• pl/sql procedure ,urgent!!!

    How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE...

    Ecsbc35 pointsBadges:
  • How to configure the database instance to respond slowly for any request?

    With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can...

    Saimadhu455 pointsBadges:
  • ORACLE REAL APPLICATION CLUSTER

    Hi to all In Oracle RAC what is menat by split brain syndrome ? What happens when it happens? I mean to say RAC database hangs or crashes ? thanks in advance

    SAPORACLE10 pointsBadges:
  • VC++: int keyword gives different results in Oracle 9i and 10g

    In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, any...

    SANS35 pointsBadges:
  • 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:
  • Oracle licensing: I need the documents related with the file F0092

    Needs to identify named users in JDE World and One World to ensure compliance with Oracle Licenses. A user may have multiple profiles in multiple environments which in Oracle's eyes would be counted as one named user We are looking at using the following fields to capture a unique identifier that...

    Bhuvanendar5 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