OracleにLEFT, RIGHT関数が無い・・・

SUBSTRを使ってLEFT, RIGHT関数のような動きをさせる

文字列の1文字目から右に5文字切り抜く

実例

SUBSTR('abcd1234', 1, 5)

abcd1

◆RIGHT代替案

SUBSTR(文字列, -5)

文字列の末尾(右)から5文字目を切り抜く

実例

SUBSTR('abcd1234', -5)

d1234

SUBSTRBの場合は全角2バイトでややこしいので説明は割愛

公式Mini DAYZ ブログを和訳 - 施設・秘密の場所解説

Mini DAYZ ガイド：ロケーション - Mini DAYZ guide: Locations

This guide describes all the game locations you will be surviving in.

Currently there are three islands in the game (the fourth one will be added in 1.2.0),
each island contains locations you can see as tiles on the minimap.
In case you are wondering, the chosen game difficulty does not affect basic aspects of the game described in text below in any way.

島 - Island

To travel between the islands, you need to find a boat on the right side of the map.
It spawns randomly each time there.
To travel from the first island to the second island, you need wood piles for repairs,
and to move from the second island to the third island you need to find a duct tape for the necessary repairs.
In the update 1.2.0, to move from the third island to the fourth island you will need gasoline to fuel the boat.
On every new island, the overall world temperature goes down.

・The first island: 20 villages, 3 cities, fire station and a hospital.
・The second island: 15 villages, 5 cities, 2 fire stations, 2 hospitals and 3 military bases.
・The third island: 6 villages, 10 cities, 3 fire stations, 3 hospitals and 6 military bases

一般的な場所 - General locations

・Forests – They are very common on each island,
you can find berry bushes, deer stands,
old bunkers and secret locations (more info about this is below).

・Lakes – Sometimes lakes spawn instead of forests.
Here you can usually find cloudberries.

・Villages – The most common game location.
Their layout may differ, they may also contain different buildings,
like a church, warehouses, school, etc.
Sometimes you can find a water pump in villages.

・Fire stations – For sure, you will find a water pump here,
and there is a good chance to find an axe or other useful gear.

・Hospitals – Obviously you can find medicine and some gear there.

・Cities – City buildings contain more high-level gear than villages.
Cities never have water pumps.

・Military bases – The best place to find top loot and firearms in the game.
Be prepared for infected soldiers who are sure to lurk here!

・Checkpoints – They usually spawn on crossroads,
they are not highlighted on the minimap and look like a regular crossroad.
Here you will always meet infected soldiers.

・Forests – They are very common on each island, 
you can find berry bushes, deer stands, 
old bunkers and secret locations (more info about this is below). 

・Lakes – Sometimes lakes spawn instead of forests. 
Here you can usually find cloudberries. 

・Villages – The most common game location. 
Their layout may differ, they may also contain different buildings, 
like a church, warehouses, school, etc. 
Sometimes you can find a water pump in villages.

・Fire stations – For sure, you will find a water pump here, 
and there is a good chance to find an axe or other useful gear. 

秘密の場所 - Secret locations

Secret locations vary.
You have already seen a lot of them on screenshots (radio tower or KV2 tank for example).
On each island, one random secret location spawns in the forest (about 10 cases).
It has a small icon as the forest on the minimap.
To find a secret location, you need to know it never borders with any location, road or edge of the map.
It is always surrounded by lakes or forest tiles.

軍用機破壊現場 - Military crash sites

Broken military vehicles are located on random places on the map such as Hummers and helicopters.
Hummers always spawn on roads and some other locations.
Helicopters, on the other hand, can always be encountered in forests.
There is only one Hummer on the first island.
On the second island, you can find two helicopters and three Hummers.
On the third island, you should look for three helicopters and five Hummers.
If you find a radio, you can scan nearby locations (tiles 10x10) for these military vehicles.

感染者タイプ 防護服バイオハザード-オレンジ Ver1.2.0追加

公式Mini DAYZ ブログを和訳 - 感染者のタイプ別解説

Mini DAYZ guide: The infected

The infected are former Chernarus citizens who have not been able to beat the infection.
They are the most common enemies in the game, and various kinds of them will make it difficult for you to survive:

• Regular – a most common type which can be encountered everywhere.
Their running speed is about the same as player’s but they can be easily lost by breaking the line of sight.
When they die, there is a chance they drop some regular loot or ammo for civilian guns.
During the late stages of the game they can appear in hordes which are stalking the player.

• Military – this type lingers only near military locations such as military bases and block posts on crossroads.
It deals more damage than a regular infected and has more health.
Some of them have pistols or rifles on them.

• Crawlers – the fastest enemies in the game.
They are very similar to the regular infected, but they run much faster.
This type usually appears on the same place as the regular infected.

• Sleepers – they usually lie down in cities and near roads.
When a survivor gets close or something noisy disturbs them, they rise.
Experienced players can spot sleepers from afar.

• Biohazards – these infected appear near the same locations as the regular infected.
When they die, they leave an acid puddle that deals damage and has a high chance of infecting the survivor.
These puddles disappear after 10 seconds.

• Screamers – they cannot harm survivors directly, but when they spot one, they start screaming and hoarding all the other infected from the nearest locations.
They meet regular survivors rarely.
They can also wake up sleepers.

Please note: killing the infected gives you additional XP.

食料・水

医療品

クラフト・その他

武器のカスタマイズ機能 Ver1.2.0追加

Gun attachments system added

PSO-1 scope

PU scope

Bandolier - リロードのスピードが30%上昇

Ver1.2.0で気付いた隠れ変更点?

生存者・トレーダーのアイコン  ← 既存機能

◆生存者(敵)

◆トレーダー

Ad動画で復活できるように

ゾンビが部屋の中で沸くように ← 元から沸くようです

建物の中に入っても表示が変わらない

ヘッドランプで無限バッテリー(バグ)

ボス?生存者(敵) ← ただの敵のアイコンでしたm(__)m

復活 (動画広告再生)

You are about to die.
Your only chance to continue playing is using this adrenaline injection after watching the video ad.