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
View Answer
| Jul 1 2008 8:52 AM GMT
| asked by
173831
ORA-00600, Oracle error messages, Oracle SQL
sql quries
i m a beginer in computer science.so how can i make grip on oracle sql plusis there any website or any electronic book that contains preset quries on sql which can help me in working in sqli want a guide book which has quries to start and work in sql plus and developer.
View Answer
| Jun 26 2008 1:21 AM GMT
| asked by
Yasir oracle
Oracle SQL, SQLPlus, Oracle
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. Ihavea number of jsps or Web pages which take various input parameters in theformat of#xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. Inmysqlmap, there is a complex join involving nested...
Answer Question
| Jun 18 2008 12:46 AM GMT
| asked by
Masonyujr
Oracle development, Wildcards, Oracle SQL
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, ...
View Answer
| Jun 12 2008 4:41 AM GMT
| asked by
Nida dean
Oracle SQL, 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_paidfrom tablenamewhere year_mnth in ('200603','200602','200601') note:it is in...
View Answer
| May 12 2008 6:59 AM GMT
| asked by
Maha
Oracle, Oracle SQL, SQL
