• how can i update ?

    when update in form (master_details) in details block i found error frm-40735 when button pressed trigger raised unhandled exception ora-00001

    Camba5 pointsBadges:
  • Commit during loader replace ?

    Hi. I would like to know if sql*loader commits after it deletes the rows when executing loader option replace. Is it possible to make it commit only after everything is done, so that there is no second when the table is empty. Thanks for your help.

    Cgfchat5 pointsBadges:
  • Duplicate Sql

    Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.

    Garimella5 pointsBadges:
  • Using the BLOB datatype

    IT HAS BEEN CLEARED THAT TO INSERT THE IMAGES INTO ORACLE DATABASE, A COLUMN WITH DATATYPE BLOB HAS TO BE CREATED IN THE TABLE, PLEASE TELL ME HOW TO INSERT AND RETRIEVE THE IMAGE INTO AND FROM THE DATABASE RESPECTIVELY. THANKS, SIMRAN.

    Rupchandani5 pointsBadges:
  • Oracle Lock Query

    Is it possible to determine who is locking (not blocking) a row in an Oracle database? This relates to a problem I have with a COBOL program that needs to determine who is locking a requested record. I can determine the rowid of the requested record (after Oracle has informed the program that the...

    RichardReynolds5 pointsBadges:
  • Join clause vs. nonequi join

    pls help, can using clause is simmilar to non equi join,if yes how is it

    Muktioracle50 pointsBadges:
  • Nonequi join and self join as inner join

    pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

    Muktioracle50 pointsBadges:
  • Syntex for storing combobox & redio button in oracle using VB.NET

    How can i save combo box value & redio button in database using VB.NET form. For example as text value we write TEXTBOX1.TEXT????

    Deep 06075 pointsBadges:
  • Oracle coding error ORA-06550

    Hi, I get the following error on compiling my code - *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return...

    ITKE346,285 pointsBadges:
  • How to create a trigger for updating a table for a quantity decrease?

    How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for each row that is...

    OracleATE190 pointsBadges:
  • Update deactiviting and throwing ora-600 error

    ORA-00600: internal error code, arguments: [25012], [5], [524], [], [], [], [], [] Current SQL statement for this session: UPDATE "JEST" SET "INACT" = :A0 , "CHGNR" = :A1 WHERE "MANDT" = :A2 AND "OBJNR" = :A3 AND "STAT" = :A4

    17383110 pointsBadges:
  • how to access fields of table along with their datatypes in oracle

    Dear Oracle gurus I am using oracle 9I. i want to access fields of table along with their datatypes at runtime.. to see structure of table 'desc' command i used.. but at runtime how i can know datatypes or fields of a table. Thanks in advance Shailesh

    Shaileshb10 pointsBadges:
  • 3 tier character report printing not possible in 10g

    i made a character report in 10g , if i run in report builder then its printing is fine. but when i print report using 3 tier (using pdf format) then all setting are disturbed.

    Yogender dba5 pointsBadges:
  • Nested SQL with multiple table join does not work with wildcard searches

    Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving nested...

    Masonyujr5 pointsBadges:
  • How to exclude certain hours and certain days in a date range in oracle sql

    hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT f.col2,...

    Nida dean5 pointsBadges:
  • building a tree

    how do you build a tree in oracle application express

    Rwy265 pointsBadges:
  • connecting to oracle database and push the data into the mail client Inbox

    we have java application,that inbox data will be stored in oracle database,i want get handle of oracle database and push the newly created document in to the mail client inbox of domino

    ITON10 pointsBadges:
  • Oracle 9i to 10g conversion

    have anybody done this type of conversion and what are the problem is can expect, we are using a lot of stored proc and triggers, is there any problem regarding the meta data?

    Sepere5 pointsBadges:
  • Pl/sql code for queries

    Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select...

    User714085 pointsBadges:
  • JDE World

    How to write a credit memo. Are they made up of line types and doc types?

    Tjm666610 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