• RAID DP vs. RAID 4

    What is RAID DP? What are the differences between RAID 4 and RAID DP? Which of them is the best for Oracle?

    Bosun5 pointsBadges:
  • Notes.notessession custom sender

    Hi, I'm using Oracle 9i, Developer 6i and Lotus Notes to send an email. I need to change the sender for another and I don't know how to do it. Please, help me.

    Nyta15 pointsBadges:
  • Connect to Oracle 10g with VB6 using ADO

    I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!

    Gasper5 pointsBadges:
  • How to connect Visual Basic 6 to Oracle 11g

    What are the steps to connect VB 6.0 to Oracle11g? Thanks!

    Rupeshit5 pointsBadges:
  • Lotus notes application / Oracle ADF

    I want to know what are the challenges in converting Lotus Notes workflow application into Oracle ADF. What are the limitation in Oracle ADF which can't be done comparing to Lotus Notes? Also, I want to know what are the benefits of Oracle ADF.

    shivasanjay2,425 pointsBadges:
  • Adding a star to a required field in Oracle Application Express

    I have a page...in that page there is a required field I just want to add a star which highlights the field as a required. How can this be done? I am a newbie to Oracle Application Express. Please help

    shivendraverma85 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • BULK COLLECT and FORALL in PL/SQL

    How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.

    RangjungDorje20 pointsBadges:
  • Can a Pivot table be created in Oracle 10g?

    I am running a stored procedure on ORACLE 10g that truncates and repopulates a table (tbl_A) that contains 2 columns; a list of unique codes and monetary amounts. The number of codes may vary weekly. I would like to create a second table(tbl_B) that contains a column for each of the names being...

    CAJ5 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 pointsBadges:
  • Loading CSV files into Oracle tables

    I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use...

    Gaugelc0 pointsBadges:
  • How to run Oracle 10g forms on browser

    Hello everyone, When I run form browser, it shows only Oracle forms. Please help me solve my problem.

    Scarletsys5 pointsBadges:
  • How to recover from ORA 01033 Oracle installation or shutdown in progress error

    After UPS failure my database failed and given ORA-01033 error. I stopped all Oracle services and copied ORA data file to another server, having same database name and SID. The old Oracle was in C Drive and new is in E Drive. I am getting the same error. Can I recover my data anyway. Please help....

    Gianmoor10 pointsBadges:
  • JDE world data archive at decommision

    Hi, Has anybody had to perform this task and got any tips? Especially in the UK to comply with HMRC and other retention requirements.

    SMOtty5 pointsBadges:
  • How do you get around an ORA-06550 error?

    I am making a program that will ask the user to enter a customer number. All of the customer numbers are numbers only. If the user enters in a customer number with a letter in it by mistake they will receive an ora-06550 error on that line number. How can I create an exception that will allow me to...

    Jonsorr20 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 pointsBadges:
  • Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:
  • Formatting PL/SQL code in SQL Developer

    Hi experts, I would like to know some keyboard shortcuts and clever formatting on PL/SQL codes in SQL Developer. Please help me out with some hints for this. Thanks in advance.

    Inprise610 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