Go up

Next thread:	sql loader failing with date field
Prev thread:	ORA-12547: TNS:lost contact

Message	Score	Author	Date
Hi masters, i have one table which is containin......		javed akhtar	Jun 03, 2021, 15:19
select substr( columnname , 1 ......		David Johnson	Jun 03, 2021, 16:03
thanks for quick help...		javed akhtar	Jun 04, 2021, 05:09

Follow up by mail

Click here

---

Subject:	extract result using substr function
Author:	javed akhtar, India
Date:	Jun 03, 2021, 15:19, 730 days ago
Os info:	linix
Oracle info:	12c
Message:	Hi masters, i have one table which is containing the server name like, PRODAIXDL1.ABC.COM TSTAIXDL1.ABC.COM DEVAIXKC2.ABC.COM QAAIXKC3.ABC.COM i want to fetch the values without domain name like PRODAIXDL1 TSTAIXDL1 DEVAIXKC2 QAAIXKC3 thanks in advance.
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: extract result using substr function
Author:	David Johnson, United States
Date:	Jun 03, 2021, 16:03, 730 days ago
Score:
Message:	select substr( columnname , 1 , instr( columnname || '.' , '.' ) - 1 ) from table_name ;
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: extract result using substr function
Author:	javed akhtar, India
Date:	Jun 04, 2021, 05:09, 729 days ago
Message:	thanks for quick help
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here