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

Answer Question   |  July 2, 2008  8:52 AM
ORA-00600, Oracle development, Oracle error messages, Oracle SQL

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 SELECT statements. The nesting [...]

Answer Question   |  June 18, 2008  12:46 PM
iBATIS, Object Relational Mapping, Oracle 10g, Oracle development, Oracle SQL, ORM, Wildcards

building a tree
how do you build a tree in oracle application express

Answer Question   |  June 17, 2008  8:13 PM
Oracle, Oracle Apex, Oracle Application Express, Oracle development

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, TRUNC(f.START_TIME,’DD’), FROM test f WHERE [...]

Answer Question   |  June 17, 2008  4:41 AM
Oracle development, Oracle SQL

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

Answer Question   |  June 5, 2008  11:12 AM
Java, Oracle, Oracle development

date functions using Oracle
Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in ‘yyyymm’ format. ex, select year_mnth,benefits_paid from tablename where year_mnth in (’200603′,’200602′,’200601′) note:it is in ‘yyyymm’ format group by year_mnth the benefits paid must [...]

Answer Question   |  September 22, 2008  6:59 AM
Oracle, Oracle development, Oracle SQL, SQL

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

Answer Question   |  April 17, 2008  3:01 PM
JD Edwards (JDE), Oracle development

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 [...]

Answer Question   |  March 25, 2008  9:47 AM
Database, Oracle 9i, Oracle development

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

Answer Question   |  March 12, 2008  1:00 AM
Oracle development, SQL

automatic go next field without enter keyboard key oracle form 6i
hi , i facing problem with oracle 6i form ,what is the code for automatic go next field without enter keyboard key (not build in like go_item(xxx) or next_item) my code is working only when ENTER key pressed but i don’t want press key, i using form for get external data from other database it [...]

Answer Question   |  April 20, 2009  6:44 AM
Oracle 6i, Oracle development

LEFT JOIN vs. LEFT OUTER JOIN
I’ve been googling for 2 hours trying to find if there is a difference between LEFT JOIN and LEFT OUTER JOIN, and of course I didn’t find anything. Is there a difference? Is the word ‘outer’ optional, since a LEFT JOIN is an OUTER JOIN by default? If this is the case, I don’t understand [...]

Answer Question   |  September 13, 2012  9:51 PM
JOIN statement, Oracle, Oracle development

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?

Answer Question   |  February 28, 2008  9:48 PM
Oracle, Oracle development, SELECT statement

install oracle developer suite 10g in windows
without oracle database can i install oracle developer suite 10g in windows

Answer Question   |  December 16, 2010  11:19 AM
Oracle 10g, Oracle developers, Oracle development

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 [...]

Answer Question   |  December 14, 2007  7:46 PM
Oracle, Oracle development

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 [...]

Answer Question   |  April 10, 2007  5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML

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 Dollars 104 Sarah 010C [...]

Answer Question   |  April 19, 2013  8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows

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 been applied so [...]

Answer Question   |  October 30, 2007  9:27 AM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

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 actual XML data, not the formatted [...]

Answer Question   |  December 4, 2006  3:09 PM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

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 if INSERT or various othe statements are [...]

Answer Question   |  November 16, 2006  9:57 AM
Oracle, Oracle 9i, Oracle development, SQL, Windows

Table not using index
Good day, I have a table containing 4 billion records and adding 7 million records per day, working with a date and timestamp. Currently the table is created with a date (charging_date) and a timestamp (named timestamp but with format varchar2(6) – i.e. ’065000′ for 06H50 AM). I created a new column DATE_TIME where I [...]

Answer Question   |  November 13, 2006  4:29 AM
Oracle, Oracle development