https://www.databasestar.com/oracle-ceil/
The Oracle FLOOR function will return the largest integer value less than the specified number. In other words, it rounds down to the nearest whole number.
It’s the opposite of the CEIL function, which rounds up.
The syntax of FLOOR is:
FLOOR(number)
The number parameter can be any numeric data type. The function will return a number in the same data type as the parameter.
So, you can use FLOOR with decimal numbers, which is actually where FLOOR works best. You can use it with whole numbers too. It won’t show an error, it just might display the same value as provided (e.g. FLOOR(5) would be 5).
You can also use functions inside FLOOR. For example, FLOOR(SUM(salary)) will SUM all of the salary values, and then round them down to the nearest whole number.
Just like with all functions, the Oracle FLOOR function can also use column aliases. So, instead of having your column labelled “FLOOR(8.12)” or “FLOOR(salary)”, you can label your column “salary_rounded” or something that makes more sense.
The FLOOR function is similar to the ROUND function. However, ROUND will round up or down, where FLOOR will always round down. The TRUNC function will also do some kind of rounding, but it removes decimals from a number which may cause it to “round” down.
For more information, including the code used in the examples, read the related article here:
https://www.databasestar.com/oracle-ceil/

Views: 454
Database Star

https://www.databasestar.com/oracle-ceil/
The Oracle CEIL function, short for “ceiling”, will return the smallest integer value greater than the specified number. In other words, it rounds up to the nearest whole number.
It’s the opposite of the FLOOR function, which rounds down.
The syntax of CEIL is:
CEIL(number)
The number parameter can be any numeric data type. The CEIL function will return a number in the same data type as the parameter.
So, you can use CEIL with decimal numbers, which is actually where CEIL works best. You can use it with whole numbers too. It won’t show an error, it just might display the same value as provided (e.g. CEIL(8) would be 8).
You can also use functions inside CEIL. For example, CEIL(SUM(salary)) will SUM all of the salary values, and then round them up to the nearest whole number.
Like with all functions, the Oracle CEIL function can also use column aliases. So, instead of having your column labelled “CEIL(8.12)” or “CEIL(salary)”, you can label your column “salary_rounded” or something that makes more sense.
The CEIL function is similar to the ROUND function. However, ROUND will round up or down, where CEIL will always round up. The TRUNC function will also do some kind of rounding, but it removes decimals from a number which may cause it to “round” down.
For more information, including the code used in the examples, read the related article here:
https://www.databasestar.com/oracle-ceil/

Views: 581
Database Star

in this video we will learn How to use Round, Rand, Floor and Ceiling Function in SQL Server.

Views: 1266
Vijay Mulsaniya

In this video I use the ROUND and FLOOR functions found in SQL. I use the ROUND function to round my figures to the nearest dollar and view the results to see how it rounds. I then round those same figures to the nearest tenth and hundredth. Using a negative number as my parameter will allow me to round to tens, hundreds, etc. The FLOOR function will just drop the decimal values without rounding.This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.

Views: 4201
Lecture Snippets

FLOOR function returns the lowest integer value that is equal to or less than a number or In other words, it rounds down to the nearest whole number or Numeric Functions - Ceil, Floor, Round, mod, replace or How to use floor function in SQL or what is the numeric function oracle SQL database
------------------------------------------------------------
Assignment link:
https://drive.google.com/open?id=1i-AUDu-UxuCQ18qdoNN9jgMLD9qaQJoM
---------------------------------------------------------------
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

Views: 28
EqualConnect Coach

The CEIL function returns the smallest integer value that is greater than or equal to a number. or Numeric Functions - Ceil, Floor, Round, mod, replace or How to use Ceil function in SQL or what are the numeric function oracle SQL database
Assignment link will be available soon:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

Views: 26
EqualConnect Coach

Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 4 - select, round, trunc, floor, ceil, oracle select statement, oracle select education, PL/SQL
Beğendiyseniz Beğen Butonuna basmayı ve Abone olarak destek olmayı unutmayın.

Views: 99
Taner TOPCU

https://www.databasestar.com/oracle-remainder-mod/
The Oracle MOD function performs a “modulo division” on the numbers you specify. A modulo division is where a division is performed using two numbers, and the remainder is returned by the function.
For example, the division of 8/5 is 1.6. Using modulo division, 8/5 will work out there is one 5 contained in the 8, with 3 left over. The MOD function would return 3 in this example.
The syntax of the MOD function is:
MOD(numerator, denominator)
The numerator is the number mentioned first in the division, or the one that is on top of the division sign. In a division such as 15/4, this would be the 15.
The denominator is the number mentioned second in the devision, or hte one that is on the bottom of the division sign. In a division such as 15/4, this would be the 4.
The parameters can be any numeric data type, and the return type depends on these parameters. This means MOD can return a whole number or a decimal number.
The calculation for the Oracle MOD function is: numerator - denominator * FLOOR(numerator / denominator).
If the denominator is 0, the function returns the value of the numerator. This is done to prevent “divide by 0” errors.
For more information about the MOD function, including how to return every second row, how it’s different to REMAINDER, and to see the SQL code used in these examples, read the related article here:
https://www.databasestar.com/oracle-remainder-mod/

Views: 912
Database Star

Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 3 - select decode case, PL/SQL
Select, decode, casei oracle select statement, oracle select education, PL/SQL
Beğendiyseniz Beğen Butonuna basmayı ve Abone olarak destek olmayı unutmayın.

Views: 138
Taner TOPCU

executed in oracle database 11g version 2

Views: 138
Education 4u

https://www.databasestar.com/oracle-lpad/
The Oracle RPAD function is used to add extra characters to the right of a text value. This is called “padding”, and the function is called RPAD because the R stands for “right” and it “right pads” a text value.
It’s the opposite of LPAD, which pads characters to the left of the value.
The RPAD function can be useful for ensuring all values are the same length, or if there is another requirement you have for adding characters to the end.
The syntax is:
RPAD(expr, length [,pad_expression])
The expr parameter is the text value you want to pad or add characters to.
The length is the total length the expression or value will be after the padding has been done. It’s not the number of characters to add.
The pad_expression is an optional field and is the character or characters to add to the right end of the string. The default value is a space.
If the length specified in the function is shorter than the length of the string, then the string is truncated to meet the length.
For more information about the Oracle RPAD (and LPAD) function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-lpad/

Views: 182
Database Star

Rounds a number a to the nearest b
Truncates a number to n decimal places
Takes the ceiling [x] or floor ]x[ of a number

Views: 232
MathCelebritydotcom

SQL CEILING function returns the smallest integer value that is greater than or equal to a number.
visit Dose for excel Add-In website:
http://www.zbrainsoft.com/
Visit our channel:
https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw

Views: 413
Super Collection Studio

https://www.databasestar.com/oracle-lpad/
The Oracle LPAD function is used to add extra characters to the left of a text value. This is called “padding”, and the function is called LPAD because the L stands for “left” and it “left pads” a text value.
It’s the opposite of RPAD, which pads characters to the right of the value.
The LPAD function can be useful for ensuring all values are the same length, or if there is another requirement you have for adding characters to the end.
The syntax is:
LPAD(expr, length [,pad_expression])
The expr parameter is the text value you want to pad or add characters to.
The length is the total length the expression or value will be after the padding has been done. It’s not the number of characters to add.
The pad_expression is an optional field and is the character or characters to add to the left end of the string. The default value is a space.
If the length specified in the function is shorter than the length of the string, then the string is truncated to meet the length.
For more information about the Oracle LPAD (and LPAD) function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-lpad/

Views: 624
Database Star

SQL 12c Tutorial 11 : SQL Numeric Functions ROUND TRUNC MOD
SQL Tutorial for beginners
Oracle SQL 12c Tutorial for beginners
ROUND
TRUNC
MOD

Views: 645
TechLake

Views: 155
Gidi Aviezer

ROUND function returns a number rounded to a certain number of decimal places or Numeric Functions - Ceil, Floor, Round, mod, replace, power or How to use Power function in SQL or what is the numeric function oracle SQL database
Assignment link will be available soon:
In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

Views: 31
EqualConnect Coach

https://www.databasestar.com/oracle-replace/
The Oracle REPLACE function is a string manipulation function that allows you to replace one text string with another. It can be a whole word or sentence, or even a single value.
The syntax of the REPLACE function is:
REPLACE ( whole_string, string_to_replace, [replacement_string])
To use this function, the parameters are:
- whole_string (mandatory): This is the string that will be checked for the characters to be replaced.
- string_to_replace (mandatory): This is the string that will be searched for within whole_string.
- replacement_string (optional): This is the string that will be used to replace occurrences of string_to_replace.
Because the last parameter is optional, if it is not specified, then the Oracle REPLACE function removes all occurrences of string_to_replace.
You can replace carriage returns with REPLACE, but you’ll need to use the CHR function.
You can replace NULL values in Oracle, but this is best done with another function such as NVL, rather than REPLACE.
If you want to replace multiple characters, you can do this using nested REPLACE functions or a REGEXP_REPLACE function.
For more information about the Oracle REPLACE function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-replace/

Views: 1073
Database Star

Oracle SQL PLSQL and Unix Shell Scripting

Views: 2626
Sridhar Raghavan

In this C programming language video tutorial / lecture for beginners video series, you will learn how to use the ceil(), floor() and round() functions in detail with example.
The ceil function is used to get the smallest integer not less than the number passed as a argument to this function, floor function is used to get the largest integer not greater than the number passed as the argument and also it is used to get the nearest integer to a number passes to it as the argument along with their syntax.
Visit http://www.LearningLad.com for more free computer programming video tutorials.
Learn Programming in HINDI at our youtube channel
http://www.youtube.com/user/LearningLadHindi
Catch us on Social Media
http://www.facebook.com/LearningLad
http://www.google.com/+LearningLad
http://www.twitter.com/LearningLadEdu

Views: 20856
LearningLad

Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle
A função FLOOR retornar o menor valor inteiro do parâmetro do tipo NUMBER que é passado.
Abaixo exemplos da utilização da Função ORACLE FLOOR
SELECT FLOOR(TO_NUMBER('10.2')) AS FLOOR
FROM DUAL;
SELECT FLOOR(-4.7) AS FLOOR
FROM DUAL;
SELECT FLOOR(TO_NUMBER('7.3')) AS FLOOR
FROM DUAL;
SELECT FLOOR(TO_NUMBER('7.9')) AS FLOOR
FROM DUAL;
https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p

Views: 834
Aprenda PL/SQL

Explaining how to get mod of column/number in oracle database
MOD function returns the remainder of m divided by n or Numeric Functions - Ceil, Floor, Round, mod, replace, power or How to use modulus function in SQL or what is the numeric function oracle SQL database
-----------------------------------------------------------------------------------------------
Assignment link:
https://drive.google.com/open?id=1UWnmiSVUOaW7PV-QdF0MmY8o5sfSE9_g
------------------------------------------------------------------------------------------------------
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

Views: 33
EqualConnect Coach

In this video, overview of Oracle predefined Number functions is given.
SQL Used in the video given below.
ABS - Absolute function returns absolute value. i.e it returns positive value.
select abs(-18.9), abs(8.9), abs(0) from dual;
FLOOR and CEIL
For 10.2, floor returns value 10, ceil returns value 11
select floor(10.8), ceil(10.2) from dual;
ROUND
select round(10.8), round(10.49) from dual;
SELECT round(10.483,1) from dual;
select round(3548,-1),round(3548,-2),round(3548,-3) from dual;
select round(3568,-1),round(3568,-2),round(3268,-3) from dual;
MOD - returns me the remainder..
let's say 11 divided by 3, here the remainder is 2
select mod(12,3) from dual;
select sign (-10), sign (0), sign(10) from dual;
select power (6,2), sqrt(3) from dual;

Views: 9
Ganesh Anbarasu

23 SQL with Oracle 10g XE Using the ROUND and FLOOR Functions

Views: 55
Cambo Movies

Oracle TRUNC: Number function
https://www.youtube.com/watch?time_continue=3&v=4lchx4sseEM
Oracle MOD: Number function
https://www.youtube.com/watch?v=eMGgo_1y6b4&feature=youtu.be
The usage of SELECT Playlist:
https://www.youtube.com/watch?v=ZwgiIiD1dWE&list=PLjBraywgeSpEW2f7AK4Ddt6BRxW0HWN74

Views: 53
PL Programming Languages

The SQL Server FLOOR function returns the largest integer value that is equal to or less than a number.
visit Dose for excel Add-In website:
http://www.zbrainsoft.com/
Visit our channel:
https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw

Views: 457
Super Collection Studio

MathsResource.com | Introduction to Calculus | Special Functions

Views: 664
Maths Resource

Oracle Tutorials: Add Comment on a Table and Column | Remove Comment from a Table and Column

Views: 88
Tech Acad

The Oracle SQL POWER function returns m raised to the nth power or Numeric Functions - Ceil, Floor, Round, mod, replace, power or How to use Power function in SQL or what is the numeric function oracle SQL database
------------------------------------------------------------------------
Assignment link:
https://drive.google.com/open?id=1b50AeTyzAhHchqH1IGrgiu1ybAsMtIDX
-------------------------------------------------------------------------------
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
Hi viewer, you might be thinking of the following question so landed at the right place you might get the answer to the following question
how to learn sql
some good sql tutorial
how to find sql basics course, SQL training, SQL practice material, SQL practice online
how to master oracle SQL
best way to learn/practice oracle SQL
best sql tutorial videos
good video tutorial on SQL
What are the query optimization techniques in Oracle/SQL
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

Views: 33
EqualConnect Coach

Learn how to round numbers with
Ceil, Floor, Round

Views: 4908
Elzero Web School

Exercise file - https://drive.google.com/open?id=1YepwmG6lPZlVSu8-bWzUp1kV6EhuLppC
CEILING FUNCTION
The Excel CEILING function returns a given number rounded up to a specified multiple.
Syntax
=CEILING (number, multiple)
CEILING.MATH
The Excel CEILING.MATH function rounds a number up to a specified multiple. Unlike the CEILING function, CEILING.MATH defaults to a multiple of 1, and provides explicit control over rounding direction for negative numbers.
=CEILING.MATH (number, [significance], [mode])
FLOOR
The Excel FLOOR function rounds a given number down to the nearest specified multiple.
=FLOOR (number, multiple)
FLOOR.MATH
The Excel FLOOR.MATH function rounds a number down to a specified multiple. Unlike the FLOOR function, FLOOR.MATH defaults to a multiple of 1, and provides explicit support for rounding negative numbers.
=FLOOR.MATH (number, [significance], [mode])
School of Skill
skills beyond dimension
we are trying our best to provide tutorials of different software such as excel, PowerPoint, word, minitab that can help students to develop their Hard skill. Tutorial of C programming, how to properly use gmail and google drive, tips and tricks of google and more will be provided in this channel. So stay with us.
Subscribe Our channel School of Skill -
https://www.youtube.com/channel/UCFzdJMMClkydLTZvWnmuhww/featured?view_as=subscriber
Facebook page: https://www.facebook.com/schoolofskill.bd/
Follow us on Instagram: https://www.instagram.com/schoolofskill/

Views: 31
School of Skill

BASE DE DADOS (Download):
https://www.sys4soft.com/web/assets/downloads/db_socios.rar
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
1. 00:00 - ABS
2. 01:28 - CEIL,CEILING
3. 02:33 - FLOOR
4. 03:11 - ROUND
5. 05:04 - SELECT TRUNCATE
6. 06:50 - DIV
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
Playlists do canal: https://www.youtube.com/user/JLDRPT/playlists
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
Contacto geral: [email protected]

Views: 134
João Ribeiro

Outer join, substr, floor, ceil, round, dual

Views: 1042
Free OpenMentor

Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1PzGVjjsR2lSlr5EXFzmbIpVN4RMGBkjwU_De6FQyxVI/edit?usp=sharing (презентация может быть с анимацией)
Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1x7-BCc_2Z83vSGjcFZiWGGdtVoRm1AJLRnxp-lXtchU/edit?usp=sharing
1. Таблица DUAL
2. Конструкция WITH. Рекурсивные запросы с конструкцией WITH
3. Иерархические запросы (self joins): START WITH, CONNECT BY, PRIOR, NOCYCLE, ORDER SIBLINGS BY, LEVEL, CONNECT_BY_ISCYCLE, CONNECT_BY_ISLEAF, SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT
4. Псевдостолбцы (pseudocomlumns).
4.1 ORA_ROWSCN (SCN_TO_TIMESTAMP, TIMESTAMP_TO_SCN)
4.2 ROWID (DBMS_ROWID)
4.3 ROWNUM
5. Конструкция SAMPLE
6. Конструкция PIVOT
7. Конструкция UNPIVOT
8. Оператор INSERT INTO SINGLE TABLE
9. Оператор INSERT INTO MULTITABLE: INSERT ALL, INSERT FIRST
10. Оператор UPDATE
11. Оператор DELETE
12. Оператор MERGE
13. Обновляемая VIEW (KEY-PRESERVED TABLE)
14. SQL FUNCTIONS: SYSDATE, EXTRACT, ADD_MONTH, MONTH_BETWEEN, UPPER/LOWER, LENGTH, SUBSTR, INSTR, REPLACE, LTRIM/RTRIM/TRIM, LPAD/RPAD, TO_CHAR, TO_NUMBER, TO_DATE, POWER, ABS, ROUND, CEIL/FLOOR, USER, TRUNC, GREATEST/LEAST
Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle

Views: 5040
Moscow Development Team

This video will provide you the details of each Mathematical Function in SQL Server 2014.
***********************************************************************
ABS (Transact-SQL)
A mathematical function that returns the absolute (positive) value of the specified numeric expression.
Syntax
ABS ( numeric_expression )
Arguments
numeric_expression
Is an expression of the exact numeric or approximate numeric data type category.
Return Types
Returns the same type as numeric_expression.
Examples
The following example shows the results of using the ABS function on three different numbers.
SELECT ABS(-1.0), ABS(0.0), ABS(1.0);
Here is the result set.
---- ---- ----
1.0 .0 1.0
The ABS function can produce an overflow error when the absolute value of a number is greater than the largest number that can be represented by the specified data type. For example, the int data type can hold only values that range from -2,147,483,648 to 2,147,483,647. Computing the absolute value for the signed integer -2,147,483,648 causes an overflow error because its absolute value is greater than the positive range for the int data type.
DECLARE @i int;
SET @i = -2147483648;
SELECT ABS(@i);
***********************************************************************
CEILING (Transact-SQL)
Returns the smallest integer greater than, or equal to, the specified numeric expression.
Syntax
CEILING ( numeric_expression )
Arguments
numeric_expression
Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.
Return Types
Returns the same type as numeric_expression.
Examples
The following example shows positive numeric, negative, and zero values with the CEILING function.
SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0);
GO
***********************************************************************
FLOOR (Transact-SQL)
Returns the largest integer less than or equal to the specified numeric expression.
Syntax
FLOOR ( numeric_expression )
Arguments
numeric_expression
Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.
Return Types
Returns the same type as numeric_expression.
Examples
The following example shows positive numeric, negative numeric, and currency values with the FLOOR function.
SELECT FLOOR(123.45), FLOOR(-123.45), FLOOR($123.45);
***********************************************************************
POWER (Transact-SQL)
Returns the value of the specified expression to the specified power.
Syntax
POWER ( float_expression , y )
Arguments
float_expression
Is an expression of type float or of a type that can be implicitly converted to float.
y
Is the power to which to raise float_expression. y can be an expression of the exact numeric or approximate numeric data type category, except for thebit data type.
Return Types
Returns the same type as submitted in float_expression. For example, if a decimal(2,0) is submitted as float_expression, the result returned isdecimal(2,0).
Examples
A. Using POWER to return the cube of a number
The following example demonstrates raising a number to the power of 3 (the cube of the number).
DECLARE @input1 float;
DECLARE @input2 float;
SET @input1= 2;
SET @input2 = 2.5;
SELECT POWER(@input1, 3) AS Result1, POWER(@input2, 3) AS Result2;

Views: 123
Softtech forum

https://www.databasestar.com/oracle-mathematical-functions/
The Oracle EXP function returns the mathematical value of e raised to the nth power. EXP is short for “exponential”.
The value of “e” is a mathematical constant, and it’s roughly equal to 2.71.
The syntax of the EXP function is:
EXP( number )
We don't need to specify the value of e, because it's a standard value (kind of like pi).
The parameter for EXP is a number which represents the power to raise e to. For example, if the number is 2, then the function calculates e to the power of 2 and returns that number.
For more information about the Oracle EXP function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-mathematical-functions/

Views: 126
Database Star

REPLACE function replaces a sequence of characters in a string with another set of characters or Numeric Functions - Ceil, Floor, Round, mod, replace, power or How to use REPLACE function in SQL or what are the numeric function oracle SQL database
Assignment link will be available soon:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

Views: 31
EqualConnect Coach

Check out my Blog:
http://exceltraining101.blogspot.com
How to use the FLOOR and CEILING rounding functions. A real world example using the phase out of the Canadian penny is shown.
Feel free to provide a comment or share it with a friend! #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel

Views: 7075
Doug H

SQL Tutorial : Difference Between Translate & Replace in SQL Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial

Views: 650
TechLake

This video contains how the Round () and Truncate( ) works.
Both are the functions . Both has some similarity and some dissimilarity.Both works same if we use negative number after the comma where as both works differently if we use positive number after the comma.
Sometimes its really difficult to understand the concept of round and truncate.
In this video both are explained with the help of diagram.
This video will help to understand how both of them works exactly.
Please leave your comments

Views: 3295
GABS CLASSES

ITS ALL ABOUT ROUND FUNCTION IN SQL,HOW TO USE ROUND FUNCTION IN SQL

Views: 262
Technical Aashique

https://www.databasestar.com/oracle-concat/
The Oracle CONCAT function allows you to concatenate, or combine, string values together into a single string value.
It’s a standard string manipulation technique in many languages, and SQL is no different.
The syntax of this function is:
CONCAT( string1, string2 )
The function returns both string values joined together, without a space or any other characters in between.
The return value is the same as the first string parameter, which can be any of the string data types.
One of the main drawbacks of this function is that it only allows for two strings to be combined, unlike other CONCAT functions in other languages. If you want to combine more than two strings together, you’ll need to have nested CONCAT functions, or use the double pipe character || which also concatenates strings.
However, the advantage of CONCAT is that it allows for concatenation when using different character sets that don’t support the double pipe method.
CONCAT and the double pipe method have similar performance, so that’s not an issue.
For more information about the Oracle CONCAT function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-concat/

Views: 709
Database Star

executed in oracle database 11g version 2

Views: 144
Education 4u

Explains the Numeric Scalar Function CEILING or CEIL to round a value upward to the next whole integer. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.

Views: 394
cbtinc

In this tutorial we'll check out the ABS() function that returns the absolute value of a number.

Views: 27884
The Bad Tutorials

Showing how to use the Round and Floor Functions to modify data in your SQL query.

Views: 26
Alberto Rangel