• 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:
  • 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...

    ITKE342,450 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:
  • 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:
  • JDE World

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

    Tjm666610 pointsBadges:
  • Oracle Installation on Portable Media

    Hello Friends, I am working on Oracle 9i (Rel - 2). I am thinking of developing an application in which I can install Oracle on a portable media (Eg. Portable Hard Disk) and create a databse on the same. First of all, I want to know whether it is possible to install the Oracle on a portable media....

    Girishdadlani5 pointsBadges:
  • SQL (Oracle) Date Constraints

    Can someone tell me how to create a constraint to prevent entering a date prior to 1 Jan 2007? I am tryin g to do it in a create script. Thanks Lock

    Lock10 pointsBadges:
  • Using SELECT statements

    Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

    OracleATE190 pointsBadges:
  • Subtracting two Julian Dates

    I am very new to this position with limited knowledge. I would like to know how we can subtract two JULIAN dates in ORACLE. I have "ADMIT_DDT" and "DISCHARGE_DDT". Each of these dates consist of 10 digit number. I know first 5 numbers represent DATE and last five TIME. I would like to know to how...

    Tahirotahir5 pointsBadges:
  • XML Publisher with Shipping Docs

    We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has not...

    Dmcdconsult40 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • XML Publisher Issue

    We can't output a concurrent request via XML Publisher... We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the...

    Dmcdconsult40 pointsBadges:
  • Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 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