text:
Chelsea boss takes a swipe at former managers' Champions League triumphs
Jose Mourinho says Roberto Di Matteo and Rafael Benitez won trophy in 'the worst season'
Dan Levene
Making a point: Jose Mourinho (Image: Action Images)
Jose Mourinho has sent a barbed message to two former Chelsea bosses, saying that Roberto Di Matteo and Rafael Benitez won the Champions League in 'the worst season'.
Mourinho comes head to head with Di Matteo on Tuesday night, as his Chelsea side face the Italian's new club Schalke in Gelsenkirchen, in a crucial Champions League qualifier.
Di Matteo is still lauded by fans at Stamford Bridge, for the fairytale way he won the competition as caretaker boss.
Chelsea train ahead of Schalke showdown
But Mourinho says, like Benitez when he was at Liverpool in 2005, winning the competition while sacrificing a decent league place devalues the achievement.
"You can win the CL in the worst season," said Mourinho.
"You can finish fifth and win the CL. Right. Liverpool did and Chelsea too [Chelsea actually finished sixth].
"So (with) the Champions League, you can not say this is the direction I want to go because I have won that competition.
Champions: Chelsea's players celebrate winning the trophy in 2012
"A knockout competition is something that always has a big percentage of unpredictability.
"I can do nothing to win it. I can only work to improve my team all the time, make a very good team like we are doing.
"Me working on the pitch, the club board working at other levels to make a great team like we did in 2004, 2005, 2006.
"And end with that Champions League. But there is nothing we can do."
Chelsea have a week of intense travel, with their trip to Germany to be followed by an evening kick off in Sunderland on Saturday.
Keep up to date with all the build-up, matchday and post-game reaction to Schalke v Chelsea right here on GetWestLondon

redpajama_set_name: RedPajamaCommonCrawl


text:
Q: Copy values to another column - ORA-01481: invalid number format model I want to copy values of col1 NUMBER(13,4) column to another newly added col1_temp VARCHAR2(50). To perform this action I build the following update query:
update table1 set col1_temp = to_char(col1, '99.99%');

Here is the current view of both columns:
 col1  |  col1_temp
-------------------
 13.9  |  null
 65.7  |  null
 21.63 |  null
 50.5  |  null
 10.8  |  null
 30.1  |  null

But running of the query gives me back always this error:
SQL Error: ORA-01481: invalid number format model

What I'm doing wrong?

A: % is not a valid format specifier for numbers.
See the documentation below:
Number Format Models

A: Do it with:
update table1 set col1_temp = to_char(col1, '99.99')||'%';

Also be careful. Your col1 can hold bigger values than 99.99. These values will give ###### as a result and also the value will be rounded on 2 decimals by the to_char command.

redpajama_set_name: RedPajamaStackExchange


Photo of e-Golf's electric motor courtesy of VW.
Volkswagen's 2015 e-Golf battery-electric compact car now rates at the most fuel efficient compact EV after the Environmental Protection Agency released fuel economy data for the automaker's for U.S. EV.
The e-Golf is expected to deliver miles per gallon of gasoline equivalent (MPGe) of 126 in the city, 105 on the highway, and 116 combined, according to FuelEconomy.gov. The vehicle has a range of up to 83 miles. The e-Golf will arrive with an electric motor that produces 115 hp and 199 lb.-ft. of torque paired with a one-speed transmission. The motor is powered by a 24.2-killowatt lithium-ion battery.
The e-Golf, which will arrive at dealers in November, will retail for $36,265.


Fifty years ago, millions of Red Guards—a ruthless cadre of radicalized students—waged war against tradition and religion, the twin threats to Maoism. This was modern China's darkest decade: the Great Proletarian Cultural Revolution (1966–1976).
Remarkably, the half-million Christians in China during the Communist ascension have multiplied into 67 million, according to the Pew Research Center's 2010 "Report on Global Christianity." Fenggang Yang, professor of sociology at Purdue University, projects that by 2030 China will surpass the United States as home to the world's largest Christian population.
Amid ongoing hostility from the government, Christianity in China faces other big challenges, including a continual shortage of pastors. One Christian scholar is hoping to reverse that trend.
Xue grew up in a rural village in Fujian Province near the southeastern coast of China. Missionaries had settled there in the early 1850s, leaving a legacy of a sizeable Christian population. Xue credits Christian schoolteachers and spiritual mentors with guiding her to faith from a young age.
She sought counsel from her English teacher, who was a Christian. "She graduated from university, so she was more open-minded to guide me through this," Xue recalls. Other spiritual mentors provided invaluable support during her high school years.
In 2005, Xue moved over 1,000 miles to Hong Kong to pursue seminary training at China Graduate School of Theology. ScholarLeaders International, a nonprofit that supports theological education for the global church, helped cover her tuition. As she pursued her childhood calling, Xue realized God had bigger plans.
Xue now teaches courses in New Testament and Koine Greek. She trains pastors from all parts of China, including remote and under-resourced regions. She also serves as a volunteer pastor and Sunday School teacher at Taipo Baptist Church.
With her rich educational background and scholarly sensibilities, Xue hopes to dispel the prevailing stereotypes against Christianity as a ruse for the superstitious or as an invasive Western ideology. "In most universities in China, we have religious studies departments with Christianity studies, but these are not led by Christians. My doctoral training has equipped me to communicate God's word, particularly to nonbelievers who are educated," she says.
It is not always easy for Xue to minister where God has called her. She is a mainlander teaching in Hong Kong, where tensions between progressive younger generations and the Chinese government are brewing.
Bonnie Lin works for ScholarLeaders International, a nonprofit ministry that encourages and enables Christian theological leaders from the majority world for the global church. She is a PhD student at Princeton Theological Seminary.


Panel Trees are perfect for getting a large Christmas tree that's easy to install and maintain. Panel trees feature a steel frame that come in 4 foot sections and have garland covered panels that mount to the frame. Commercial panel trees are perfect for large trees with ornaments or other large decorations because decorations can be permanently secured to the panel with ease. Most of these trees are lit with C7 or C9 bulbs and can be priced for incandescent or LED styles. Pretty much any color is available so you can design your tree to fit the needs of your city, business or ever your home! Our panel Christmas trees come with a tree topper but we can price your tree with any of our toppers or without a topper, just email us and let us know!