SQL Loader

We have a requirement to insert records starting with 06,08 and 15.In other words, records starting with 09,10 and 11 should not be inserted into target table.

ORACLEPLSQLDEVELOPER10 pointsBadges:

biometric data migration

I want to migrate from one biometric database to another from a different provider. Do I have to pay some IP rights to the one who build the original data base? What are the requirements for doing so ?

mwrp5 pointsBadges:

Best Technology for learn

i m the computer graduate doing job in technical support & wants to learn new technology can u suggest any new technology

santosh1234567891030 pointsBadges:

oracle 11g oam console login on Win 2008

Has anyone been able to install OAM 11.1.1.5 on Win 2008 R2 and able to log in to the oamconsole?

Sparky850045 pointsBadges:

need help with measuring dates

I am trying to select records from a table where the CREATEDT field is between SYSDATE and 20 days prior. select distinct(createdt) from U_table where to_char(createdt, 'dd/mm/yyyy') between to_char(sysdate, 'dd/mm/yyyy') and to_char(sysdate - 20, 'dd/mm/yyyy') There are records in that table that...

jkeri360 pointsBadges:

unable to find oracleservice xe in my pc??

hi, i'm unable to find oracleservice xe in my pc..i entered in to cmd in that ....services directory... i'm able to see only oracleMTSRecoveryService nd oraclexEclrAgent.. now how can i able to see that oracleservicexe file.. i want to startup dis service ...

oracleservicexe10 pointsBadges:

Oracle database error

Create a new data from Dot net application, it\'s display a \"Oracle Error 0\" why it\'s display

ISIT15 pointsBadges:

I want to upload my web project on internet. How to do it?

HI i have made a web project using jsp/servlet and oracle database in Eclipse IDE. I have many jsp pages and servlets in that project. Now i want to upload my project on Internet. How to do it? I dont know anything about uploading websites to internet.

hussain22juzer530 pointsBadges:

Is PL/SQL a right choice form performing operations on a databse and display the final result.?

I am developing a stock maintainence software using java language (Front end) and using oracle database as backend . i am storing data entered into some sort of gui builded forms into database. Now i want to perform some operations on that data and then display the final result. Is PL/SQL a right...

hussain22juzer530 pointsBadges:

Table naming issues while migrating I-series v5r4 to Oracle

hi sir, will a migration possible between iseries v5r4 to oracle ?? if it is possible then will there be any issues regarding  table naming i,e tables having names more than 10 charecters will get migrated ?? here  in our scenario our source db has tables with names more than 10 charecters...

Praneeth145 pointsBadges:

New member contest: ASK, Answer and Win a $50 Amazon gift card

As 2008 winds to a close, IT Knowledge Exchange has one more fun contest to end the year. From today until December 23rd, you can enter to win one of ten $50 (US) Amazon.com gift cards. There are two things, however, that you must do in order to enter: 1. Ask 2 questions 2. Answer 2 questions...

ITKE1,067,645 pointsBadges:

can i install oracle 9i on windows7 operating system?

can i install oracle 9i on windows7 operating system?

Or20 pointsBadges:

Soon you can redeem knowledge points for Amazon.com gift cards

Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering to beef up...

ITKE1,067,645 pointsBadges:

Some Oracle forms Developer 6i problems

Hello Knowledge exchanger I have some problems which need to be fixed as soon as possible, I really need your help, the problems are listed below: 1) when creating a form with buttons one for enter query and another for execute query, an error raised at the run time which is "the function cannot...

PalestinianGirl895 pointsBadges:

Email Validation Software

We do a lot of bulk email blasts to our Students, in which we get a high percentage of bounced emails. We are looking into purchasing an Email Validation package and was wondering if anyone can recommend a decent package that would either run on the i5 (AS/400) or that can interface (via ODBC,...

I5NEPA0 pointsBadges:

Oracle Forms 6i when-validate-item trigger not firing

when-validate-item trigger not forong as soon as the item is changed. I have set validate-from-list property of item to be yes buit still when I press any other buttonm on the form this trigger is raised. Please help me out in this regard.

Sarah1234520 pointsBadges:

Oracle 10g in Windows 7 Ultimate

i have to do some programs using jdbc connections n simple networking programs... ll oracle10g work on windows7 for database connectivity.... i run d programs on cmd prompt

Nkp5 pointsBadges:

How to send email from Oracle Report 10g

Configure SMTP server and set system parameters in report, still unable to send mail. Getting following error msg rep-0069: internal error rep-57054: in-process job terminated. Executed successfully but there were some errors when distribute the output. REP-50159: Executed successfully but there...

Parapr5 pointsBadges:

Oracle:Concat multiple rows using XML

Hi There I am using the following to concatenate multiple rows in an Oracle 9 table: SELECT column1 , RTRIM ( xmlagg (xmlelement (column2 || ' ') order by column1, column3).extract ('//text()') , ' ' ) AS concatenated FROM mytable where (column4 = 'XXXXXXX') and (column5 = 'XXXXXXX') and (column6 =...

Csshahie5 pointsBadges:

Oracle Database XE

i could not start up the project ...could you please help me out from this thanks.. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Pro SQL> alter system reset sessions scope=spfile sid='*'; System altered. SQL> alter system set processes=300 scope=spfile; System...

Nandu225 pointsBadges: