• Upgrading Forms30 on Oracle 7.0

    I am upgrading Forms30 on Oracle 7.0 to Oracle 10g First, I am upgrading to Oracle forms 6i using Forms compiler and facing these problems I. converting language on display item. (it doesn't show the right language on display item and headers) 2. key mapping function. 3. I need script so I can...

    Oikhleif30 pointsBadges:
  • Looping Queries in Oracle using data from SQL Server

    I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this? or...

    Sreedhar775 pointsBadges:
  • Slowdown in SQL Restore on SQL Server 2000

    We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting "Restore Database", Enterprise Manager runs remarkably slow. I'm sure we could run the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Oracle Form Use As Web Page

    I am a Oracle Form Developer 6i . I want to Apply My Oracle Form As Web Page. smply I want open my form through internet (as web-page)

    Amjadbinali35 pointsBadges:
  • ProC under Oracle 10g

    Hi! I have a piece of code in Pro-C that's been running under Oracle 9i for several years. I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty...

    Ilank10 pointsBadges:
  • Hyperion Workspace usage 9.3.1

    Hi, How and where to get the detail with repect to user id, date, time of login and logout from workspace and /or planning?

    Rajeshmehta5 pointsBadges:
  • Find out what is in dbms_sql cursor

    I am trying to put in a 5500 character query into dynamic sql, and then use the Oracle dbms_sql function to execute the sql. However, there is an error in the sql statement that is being generated, but the error message doesn't help me identify where the error is, as it pertains to the dynamic sql...

    Darryn765 pointsBadges:
  • Oracle v$ view that dynamically has the names of procedures

    Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?

    Skabanga5 pointsBadges:
  • Will SAP CRM add to Oracle CRM functional profile

    I was working as Oracle CRM consultant a month back with 2.5 years CRM experience. I have very good knowlwdge & experience of Oracle CRM service modules like Contracts, Field Service, TeleService, Install Base etc. This economic downturn has pushed me out of job. My question is will it be helpful...

    SAPOracleCRM5 pointsBadges:
  • Free Oracle Assessment Exams

    Can someone tell me where I can find free Oracle Assessment exams in preparation for Oracle certifications?

    Stewary5 pointsBadges:
  • Finding the number of rows of all tables of a user/schema in Oracle

    how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ......

    Chrishram15 pointsBadges:
  • SQL query and Oracle database design help needed

    Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the...

    Rohit331225 pointsBadges:
  • PL/SQL

    Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it...

    Inprise610 pointsBadges:
  • PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take NULL but...

    Inprise610 pointsBadges:
  • Searching using Oracle Forms

    Hi to all.I am tauqeer.I am using oracle 10g forms developer I want to search some data in the tabular form style in the form based on a query on a text item.I want when i press enter button which is under that text item the data will be displayed in the tabular saction.the text item and enter...

    Raza15 pointsBadges:
  • What are the advantages of Hyperion Planning?

    what is the purpose of this planning, What are the main advantages in this, why customers are looking in to it?

    99898964305 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • Where are Oracle Anonymous Blocks stored?

    Where the anonymous blocks are stored?

    Ramesh5530 pointsBadges:
  • Oracle Data Dictionary

    I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this...

    OracleATE190 pointsBadges:
  • concatenating rows of a column in oracle 9i sql

    how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

    Chrishram15 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