Dear Steve, Thanks very much for taking the time to help me on this one. The table was created as follows: CREATE SEQUENCE POR_SEQ INCREMENT BY 1 START WITH...
I think the problem is your date. It should be in quotes insert into purchase_order (POR_ID, POR_DATE, SUP_ID, VALID_UNTIL_DATE, CONFIRMED_YN) values (1,...
Hi all I send My First Message at you Group Subject <Please Help me > But still Now One Whant to help Me Please I need Test King For Exams <1z0-023> &...
Thanks very much for your help. It now works perfectly. ... to_date ... never rely ... at the ... 2003', 'N') ... work, but ... differences between ... yur...
Sorry, that was meant to be a thank you to both Steven and Michael. I very much appreciate both of you taking the time to help. I'm new to this Oracle stuff....
Hoped not to bother you with any more qq on this task! Oracle tells me that I have a missing comma in the 'values' part. I've looked for ages but I just can't...
Thanks for your speedy reply. In fact the date was only wrapped in the message I posted (although I had put the first part on one line and then from...
Oh! You are missing the closing ")" at the end of the ...values (1, 1, 1, 20, 15, 15, 15, 5.80, to_date('15-JUN-2003','DD-MON-YYYY'); should be ...values (1,...
Hi Matthous You are not missing comma you are missing bracket at end of values clause, the bracket you have given is for to_date clause and not for vlaues...
Hi All, The member teasingyou34c8 has been removed from the OraTechSupportGroup for sending the unreleated message to this group. The purpose of this group...
It might be that it is in line mode, but I am not sure. ... From: "joshisantosh04" <joshisantosh04@...> Reply-To: OraTechSupportGroup@yahoogroups.com To:...
Rajesh Arora
arora_rajesh@...
Jun 9, 2003 4:16 pm
369
the 'l' does signify line mode. Thanks, Randy Scott ADC Shared Services (512)434-8158 - Office (512)434-1861 - Fax ... From: Rajesh Arora...
Hi Experts, Is there any data type in Oracle by which we can hide a column. Thanks __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only...
I don't think so. But you can encrypt it.... ... Experts, ... http://mobile.yahoo.com.au - Yahoo! Mobile - Check & compose your email via SMS on your Telstra...
Varughese M
varughesem@...
Jun 25, 2003 7:44 pm
373
Hi John, The concept of views include the hiding the column. Thanks, Ramesh ... __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only...
Hi, I installed Oracle 9i on windows which is 32bit envirnment. I have another site in which Oracle 9i 64-bit version is installed on Sun solaries. I can...
When you connect from sqlplus to another server, after making a connection, it will tell you information about the connected server. The information includes ...
Sameer Wadhwa
swadhwa@...
Jul 11, 2003 2:55 pm
377
Hi Kots, execute the command "file oracle" at the dollar prompt in the $ORACLE_HOME/bin directory. If there is a 64 diplayed in the output, it is a 64 bit...
We would like to introduce ourselves as Skots Consultants, a professionally managed company specializes in Executive Search and Selection. We have a team of...
Hi Ramesh Shenoy, Thanx for sending inforamtion. regards, kots ... __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per...
Hi Folks ! When you take backup using RMAN with Catalog ( Recovery Manager ) where is the information stored in Controlfile ? Regards, S.PACKIARAJAN...
Hi ORACLE9i S G, I have installed ORACLE9i and I have software "Checkfree i-series" which is used as bill presentment and pamymet " this soft ware priovided...
Hi Kots, I had a similar experience. I was successful after reinstalling the correct version of JDK. Ramesh ... __________________________________ Do you...
Hi Friends, here I m getting and error when exporting data using export command. the error is as followes : EXP-00008: ORACLE error 12602 encountered. ...