Excel function to convert date "2011-11-04-23.22.10.446908" to "2011-11-04"

=MID(A2,SEARCH("2011",A2,1),10)

Excel Function to change date in "2011-02-10 19:18:11" format to "10/02/2011 19:18:11" format

=CONCATENATE(MID(N2,SEARCH("-",N2)+4,2),"/",MID(N2,SEARCH("-",N2)+1,2),"/",MID(N2,SEARCH("-",N2)-4,4)," ",MID(N2,SEARCH(":",N2)-2,2),":",MID(N2,SEARCH(":",N2)+1,2),":",
,MID(N2,SEARCH(":",N2)+4,2))

Meaning of name LLoyd

Lloyd \ll(o)-yd\ as a boy's name is pronounced loyd. It is of Welsh origin, and the meaning of Lloyd is "gray-haired; sacred". From Llwyd. The name may originally allude to experience and wisdom, and probably denoted a person entitled to respect. Actor Lloyd Bridges; Senator Lloyd Bentsen.

Lloyd has 2 variant forms: Floyd and Loyd.

Baby names that sound like Lloyd are Ladd, Lad, Laud and Lot.

View a list of the 6 names that reference Lloyd.
Popularity of Lloyd

Lloyd is a very popular first name for men (#160 out of 1220) and also a very popular surname or last name for all people (#470 out of 88799). (1990 U.S. Census)
Displayed below is the baby names popularity of the name Lloyd for boys. (2010 statistics) Compare Lloyd with its variant forms and related boy baby names.

Source Courtesy : http://www.thinkbabynames.com/meaning/1/Lloyd

It is a very good website for baby name meanings

How to Kill an Oracle SQL query if SQL text and Oracle User are known

select
b.sid,b.SERIAL#,b.username,a.sql_text
from
v$sqltext a,
v$session b,
v$process c
where
b.username='ORACLEUSER'
and
c.addr = b.paddr
and
b.sql_address = a.address and b.status='ACTIVE'
order by b.sid

alter system kill session '45,20' immediate

Excel function for advanced Date manipulation

Excel Function to change date in "2011-02-10 19:18:11" format to "10/02/2011 19:18:11" format


=CONCATENATE(MID(N2,SEARCH("-",N2)+4,2),"/",MID(N2,SEARCH("-",N2)+1,2),"/",MID(N2,SEARCH("-",N2)-4,4)," ",MID(N2,SEARCH(":",N2)-2,2),":",MID(N2,SEARCH(":",N2)+1,2),":",
,MID(N2,SEARCH(":",N2)+4,2))

TM forum Programs

Advanced Service Development and Delivery
e.g. Activities relating to developing and delivering services in the complex value chain.
TM Forum Programs:
Enabling New Services Initiative, B2B Interfaces,
Product Lifecycle Management, Service Level Agreement Management,
App Stores, Service Delivery Framework, IPsphere,
Frameworx, Benchmarking

BSS/Revenue Management
e.g. Activities relating to managing the revenue stream in a service provider business.
TM Forum Programs: Revenue Assurance, Billing/Charging, Data Analytics, Fraud Management, Benchmarking

Business Transformation
e.g. Activities relating to optimizing business performance through processes and systems.
TM Forum Programs: Benchmarking, Frameworx, Information Framework (SID),
Application Framework (TAM), Business Process Framework (eTOM),
Integration Framework, Conformance Certification Assessment

Cable
e.g. Activities that enable MSOs and vendors to work together to provide guidance and best practices and standards based solutions for
operational needs for the cable market.
TM Forum Programs: Cable Interest Group, IPDR, Business Process Framework (eTOM), Business Intelligence/Data Analytics

Cloud
e.g. Activities relating to managing cloud services and removing the barriers to their widespread deployment.
TM Forum Programs: Cloud Initiative, Enterprise Cloud Leadership Council

Customer Experience
e.g. Activities relating to providing the optimal customer experience, including through efficient processes and data analytics.
TM Forum Programs: Managing Customer Experience, Benchmarking

Developing Service-Oriented Architecture Solutions
e.g. Activities relating to software development and integration of communications management systems
using service-oriented techniques and open, interoperable software solutions.
TM Forum Programs: TM Forum Developer Network, Frameworx, Business Process Framework (eTOM),
Information Framework (SID), Application Framework (TAM), Integration Framework,
TM Forum Interfaces, Conformance Certification Assessment

Government/Defense
e.g. Activities relating to collaboration on key industry issues relevant to defense organizations (including “military unique features”)
and the identification and development of supporting standards.
TM Forum Programs: Security Management, Federated Service Level Agreements

Management of Converged Networks
e.g. Activities relating to standardized network management of 4G, other broadband access networks, and the all-IP core.
TM Forum Programs: Managing Wireless/Wireline Networks, Managing All-IP Networks

Process Management
e.g. Activities relating to analyzing, defining, and deploying business processes across the communications service provider’s enterprise.
TM Forum Programs: Business Process Framework (eTOM), Benchmarking, Conformance Certification Assessment

Security
e.g. Activities relating to Cyber Security.
TM Forum Programs: Network Defense, Identity Management, Single Sign On

Service Quality
e.g. SLA Management

Learn Italian - One to Hundred

0 zero
1 uno
2 due
3 tre
4 quattro
5 cinque
6 sei
7 sette
8 otto
9 nove
10 dieci
11 undici
12 dodici
13 tredici
14 quattordici
15 quindici
16 sedici
17 diciassette
18 diciotto
19 diciannove
20 venti
21 ventuno
22 ventidue
23 ventitre
24 ventiquattro
25 venticinque
26 ventisei
27 ventisette
28 ventotto
29 ventinove
30 trenta
31 trentuno
32 trentadue
33 trentatre
34 trentaquattro
35 trentacinque
36 trentasei
37 trentasette
38 trentotto
39 trentanovve
40 quaranta
41 quarantuno
42 quarantadue
43 quarantatre
44 quarantaquattro
45 quarantacinque
46 quarantasei
47 quarantasetto
48 quarantotto
49 quarantonove
50 cinquanta
51 cinquantuno
52 cinquantadue
53 cinquantatre
54 cinquentaquattro
55 cinquentacinque
56 cinquentasei
57 cinquentasetto
58 cinquentotto
59 cinquentanove
60 sessanta
61 sessantuno
62 sessantadue
63 sessantatre
64 sessantaquattro
65 sessantacinque
66 sessantasei
67 sessantasetto
68 sessantotto
69 sessantanove
70 settanta
71 settantauno
72 settantadue
73 settantatre
74 settantaquattro
75 settantacinque
76 settantasei
77 settantasetto
78 settantaotto
79 settantanove
80 ottanta
81 ottantuno
82 ottantadue
83 ottantatre
84 ottantaquattro
85 ottantacinque
86 ottantasei
87 ottantasetto
88 ottantotto
89 ottantanove
90 novanta
91 novantuno
92 novantadue
93 novantatre
94 novantaquattro
95 novantacinque
96 novantasei
97 novantasetto
98 novantotto
99 novantanove
100 cento

Parli Italiano?

Do you speak Italian?
======================

Mi Scusino!

Excuse Me !

Remove Table Level Lock in Oracle

select * from dba_objects where object_name='PROVISIONING';
/* 180693 */

select * from v$locked_object where object_id=180693

select * from v$access where owner='PROD' and object='PROVISIONING';

select sid, serial#, command, taddr from v$session where sid=88

alter system kill session '88,57147';

commit

DOS command for lookup server name

C:\Documents and Settings\shijudaniel>nslookup

awk to copy ttfile to a specific folder

ll | awk ' $6=="Jan" && $7=="15" {print "cp " $9 " ../CUGDATA"}' >cugdata.sh

SQL Format Output

increasing column size for displaying the billcyclefullcode fully
------------------------------------------------------------------


SQL> column BILL_CYCL_FULL_CODE_N format 999999999999999999999999999

SQL> select BILL_CYCL_FULL_CODE_N from TABLENAME where trunc(cycle_start_date_d) = '01-NOV-2008' and rownum <10;

awk for compressing files in archive

ll | awk ' $6=="Nov" && $7=="26" {print "gzip " $9}' >26nov.sh

Touch Shell File

$ more touch.sh
for i in `ls data`
do
touch success/`basename $i success`
done