Single row functions
Tool used in this tutorial is command prompt.
This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training.
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
Thanks for linking, commenting, sharing and watching more of our videos
This is Manish from The Code makers
in this oracle database tutorial we will see what are SQL FUNCTIONS.
SQL functions are divided into two categories
1st is Single Row Functions
And another one is
Multiple row function which is also known as aggregate functions.
But in today's SQL tutorial we will concentrate on Single Row Functions.
Single-row functions operate on one row at a time and return one row of output for each input row.
Single row functions are capable of manipulating data items and modifying the data types.
Single row functions return one result per row and act on each row that is returned.
Single row functions can accept one or more arguments and return one value.
These arguments can be a column or an expression.
With oracle we have 5 types of Single Row Functions
1. Character Functions
2. Number Functions
3. General Functions
4. Conversion Functions and
5. Date Functions.
Character Functions are further divided into two categories.
1st is Case- manipulation functions
2nd is Character Manipulation functions.
We have 3 case manipulation functions Lower, upper and initcap
and 7 character manipulation functions Sql functions concat, substr, length, instr, lpad, rpad, trim and replace.
In our future video we will see what these functions are and what they do along with other SQL function.
That's it for today's sql tutorial. Hope you enjoyed watching.
Please don't forget to subscribe and like.
Have a good day.
This is Manish.
For towns, each building is described, along with what and who can you can talk to, who to buy skills from, and what quests are available. For the outlying areas, the dungeons are listed.
Dungeon maps are not given -- they would be too extensive to fit easily into a web page and the automapping in the game is excellent. Also, every dungeon should be explored completely to get all of the loot, but only puzzles and hidden locations are described. I also skip most of the fighting because it isnt something that you can easily describe, nor does it matter in most places, except that you have to survive it. I do list the creatures that you will encounter in a dungeon or grid location to give you an idea of how difficult the location is.
Stores are listed with a "buy" and "sell". The "buy" value is multiplied by the items value to determine the price you have to pay for it. The "sell" value is divided by the items value to determine the price you can sell it to the store for. Higher is always worse, and a "buy" or "sell" of 1 means that you are buying/selling an item at cost.
Every location has a "reset" timer. This starts when you first enter the area, and after it "goes off", the entire grid square resets: monsters reappear and random treasure is replaced. Nonrandom treasure (including most stat-gaining liquids) is not replaced. All dungeons have a reset of 2 years (24 months), unless otherwise noted. Overland areas have reset times listed with their descriptions.
Artifacts are unique items that can be found. They come in two flavors: Minor artifacts are always benificial and have a value of 20000gp. Major artifacts always have a drawback, but their benificial powers are much stronger. They have a value of 30000gp. There are 15 minor and 15 major artifacts -- some of these artifacts are placed at specific locations; others are randomly generated.
Table of Contents.