No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. PĂ©ran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
Go up

extract result using substr function
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 ...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts 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, 543 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, 543 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
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, 542 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