• How to install Oracle Developer forms 11g R2 and connect the forms and reports to Oracle 9i

    I want to install Oracle Developer forms 11g Release 2 and connect the forms and reports to Oracle 9i Enterprise Edition Release 9.0.1.1.1 – Production. Can you give me the step-by-step to make installation and the connection to my local server in the local network? Best Regards, Jamil...

    MAY0565929271495 pointsBadges:
  • How to select Oracle TOP 10 records

    We have a huge problem with our SQL statement in Oracle. We're trying to select the TOP 10 records that are ordered by STORAGE_DB (which aren't in a list from another SELECT statement). This code works fine for all records: SELECT DISTINCT APP_ID, NAME, STORAGE_GB, HISTORY_CREATED,...

    ITKE352,580 pointsBadges:
  • Find out if a transaction is pending in Oracle

    I've been trying to find out if there are uncommitted INSERT, UPDATE or DELETE statements in my current session. I know one way would be is to check the v$lock with the current SID but that means I need read access to v$lock. That's a problem since my DBA doesn't want to grant me that. Is there...

    ITKE352,580 pointsBadges:
  • Oracle TNS Listener Remote Poisoning

    What is the fix on Oracle TNS Listener Remote Poisoning?

    subahshd5 pointsBadges:
  • How to store only time in Oracle

    In one of my fields, I don't need to store a datetime pair (basically not the standard Oracle date). Just like this: 01/10/2009 22:10:39 I only need the time specifically. 22:10:39 Since I have two million records, I think this will help provide faster processing. Thanks!

    ITKE352,580 pointsBadges:
  • The difference between YYYY and RRRR in Oracle SQL

    My partner and I have two different queries in Oracle SQL. Here they are: select trunc(to_date('27-Jul-1987'),'YYYY') FROM dual; And select trunc(to_date('27-Jul-1987'),'RRRR') FROM dual; But both queries are giving us the same result. What's the difference between YYYY and RRRR? We appreciate any...

    ITKE352,580 pointsBadges:
  • Delphi and Oracle stored procedures

    I'm converting an application from Delphi3 to Delphi5. I have some doubts about Stored procedures. Delphi calling stored procedures in oracle.some parameters value are set as input and passed to oracle. stored procedure in oracle returns some value. in my delphicode when the application reaches the...

    VPL100 pointsBadges:
  • Conversion of Oracle trigger to MS SQL

    How can I convert an Oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • Get all the numbers between two numbers in Oracle SQL

    Does anyone know of a way to select the numbers (or integers) that are included between two numbers with SQL in Oracle? I can't create a PL/SQL procedure for this. Here's an example: I need to get the numbers that are between 3 and 10. Obviously, the results would be 3,4,5,6,7,8,9,10. How can I do...

    ITKE352,580 pointsBadges:
  • How to calculate the difference between two dates in Oracle SQL

    I have the following table in Oracle SQL: Filename - varchar Creation Date - Date format dd/mm/yyyy hh24:mi:ss Oldest cdr date - Date format dd/mm/yyyy hh24:mi:ss So I need to calculate the difference in hours, dates and also minutes between two dates. How can I do that? Thanks.

    ITKE352,580 pointsBadges:
  • Getting ORA-00905 error message: Missing keyword

    I've been trying to do a SELECT INTO using Oracle. Here's my query: SELECT * INTO new_table FROM old_table; But I keep getting this error: SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword" Has anyone seen this before? If so, what should I do? Thank you very much.

    ITKE352,580 pointsBadges:
  • Oracle: Escape a reversed word

    Would there be a way to escape a reversed word in Oracle? I think I can use something like this to select the column named table. elect [table] from tablename But how can I do that for reversed words in Oracle? I've tried square braces and double quotes but neither worked. Thank you very much.

    ITKE352,580 pointsBadges:
  • Getting a textual representation from an Oracle BLOB

    I've been trying to see, from inside my SQL console, what's inside an Oracle BLOB. I already know that it contains a large body of text and I need to see it. But my query only shows that there's a BLOB in the field. Here's the query: select BLOB_FIELD from TABLE_WITH_BLOB where ID = ''; And this is...

    ITKE352,580 pointsBadges:
  • Good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utility commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • Return multiple rows from a stored procedure in Oracle

    I'm looking to create a stored procedure, with one argument, which will return different sets of records (that all depends on the argument). What would be the best way to do this? Would it be possible to call it from a plain SQL?

    ITKE352,580 pointsBadges:
  • Does Oracle have a function to split a string?

    I have to write a procedure that normalizes a record that has multiple tokens concentrated by one character. The only way I can obtain these tokens is by actually splitting the string and then inserting each one as a new record into a table. Does anyone know if Oracle has something like a "split"...

    ITKE352,580 pointsBadges:
  • Calling an Oracle function from hibernate with a return parameter

    We have a function which currently does some modifications internally and returns a value. This was our original idea: protected Integer checkXXX(Long id, Long transId) throws Exception { final String sql = "SELECT MYSCHEMA.MYFUNC(" + id + ", " + transId + ") FROM DUAL"; final BigDecimal nr =...

    ITKE352,580 pointsBadges:
  • Which Oracle certification should I choose?

    I have completed my BE CSE. I need to do an Oracle certification. I don't knno which is best one. Please guide me.

    karthik84185 pointsBadges:
  • How can I retrieve the highest five values of a column in Oracle

    How would I be able to write a query where only a select number of rows are returned with either the highest or lowest column value. I appreciate any help. Thanks.

    ITKE352,580 pointsBadges:
  • A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)

    Whenever I'm trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:--- A program is trying to automatically send email on your behalf Do you want to allow this? If this is unexpected it may be virus and you should choose no I don't want to show...

    44063860 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