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.
Answer Question
| Aug 29 2008 9:50 AM GMT
| asked by
Cgfchat
SQL*Loader, Oracle development
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.
Answer Question
| Aug 25 2008 3:40 AM GMT
| asked by
Garimella
Oracle PL/SQL, SQL, Oracle development
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.
View Answer
| Aug 22 2008 5:01 AM GMT
| asked by
Rupchandani
BLOB, Oracle development
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 thefollowing: begin case declare end exit for goto if loop mod null pragma raise return...
View Answer
| Jul 18 2008 2:59 PM GMT
| asked by
ITKE
Oracle development, Oracle error messages, ORA-06550
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????
View Answer
| Jul 18 2008 11:52 AM GMT
| asked by
Deep 0607
ComboBox, Oracle database design, VB.NET
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...
View Answer
| Jul 16 2008 3:48 PM GMT
| asked by
OracleATE
Oracle development, Triggers
how to access fields of table along with their datatypes in oracle
Dear Oracle gurusI 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 advanceShailesh
View Answer
| Jul 1 2008 10:09 AM GMT
| asked by
Shaileshb
Oracle Developer 2000, Oracle 9i, Oracle development
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
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
building a tree
how do you build a tree in oracle application express
Answer Question
| Jun 16 2008 8:13 PM GMT
| asked by
Rwy
Oracle Application Express, Oracle, Oracle Apex
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
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
| Jun 5 2008 11:12 AM GMT
| asked by
ITON
Oracle, Java, 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
JDE World
How to write a credit memo. Are they made up of line types and doc types?
Answer Question
| Apr 17 2008 3:01 PM GMT
| asked by
Tjm6666
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 a portable...
Answer Question
| Mar 25 2008 9:47 AM GMT
| asked by
Girishdadlani
Oracle development, Database, Oracle 9i
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
View Answer
| Mar 12 2008 1:00 AM GMT
| asked by
Lock
SQL, Oracle development
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 will...
Answer Question
| Mar 5 2008 6:44 AM GMT
| asked by
Kutub
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 the usage...
View Answer
| Feb 27 2008 9:51 PM GMT
| asked by
OracleATE
Oracle, Oracle development, JOIN
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?
View Answer
| Feb 27 2008 9:48 PM GMT
| asked by
OracleATE
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
| Jan 8 2008 11:19 AM GMT
| asked by
A1
Oracle developers, Oracle development, Oracle 10g
