RE: String manipulation

2004-01-26 Thread SRIDHARAN, SAN (SBCSI)
Title: Message Substr(''mystr1~mystr2~mystr3', 1, 20) = 1 is the position and 20 the length (not the position). The "substring" functions return a portion of string, beginning at character position, substring_length characters long. SELECT

RE: alter table rename error

2004-01-15 Thread SRIDHARAN, SAN (SBCSI)
Title: Message Rewrite the query without specifying the owner name and it works. Alter table emp to employee; -Original Message-From: eric king [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: alter