Home
Search results “Oracle ceil floor round”
Oracle CEIL Function
 
01:56
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: 504 Database Star
Oracle FLOOR Function
 
01:49
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: 379 Database Star
OracleSQL#47 Ceil function| Round up the nearest whole number|number function in Oracle SQL database
 
05:19
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
OracleSQL#46 Floor function | rounds down to the nearest whole number
 
03:39
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: 13 EqualConnect Coach
Lesson 28 Round Rand Floor and Ceiling Function in SQL in Hindi
 
15:47
in this video we will learn How to use Round, Rand, Floor and Ceiling Function in SQL Server.
Views: 970 Vijay Mulsaniya
OracleSQL#49 How to use  ROUND Function in Oracle SQL Database|Number Function in Oracle Database
 
03:20
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: 19 EqualConnect Coach
SQL 12c Tutorial 11 : SQL  Numeric Functions ROUND TRUNC MOD
 
04:23
SQL 12c Tutorial 11 : SQL Numeric Functions ROUND TRUNC MOD SQL Tutorial for beginners Oracle SQL 12c Tutorial for beginners ROUND TRUNC MOD
Views: 342 TechLake
Learn MySQL In Arabic #30 - Numeric Functions - Ceil, Floor, Round
 
11:40
Learn how to round numbers with Ceil, Floor, Round
Views: 4429 Elzero Web School
Oracle ROUND: Number function
 
03:48
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
Floor and Ceiling Functions (Special Functions)
 
06:09
MathsResource.com | Introduction to Calculus | Special Functions
Views: 629 Maths Resource
ceil, round, floor Math Functions in C Programming Language Video Tutorial
 
06:19
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: 19578 LearningLad
Ceil, Floor, Greatest, Least, Mod, Pow and Sqrt  commands @omur61
 
09:22
Create an application using with Ceil, Floor, Greatest, Least, Mod, Pow and Sqrt commands on the Postgresql database @omur61
Views: 22 ömür aydoğdu
SQL FLOOR function - how to use SQL FLOOR function
 
00:57
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
SQL CEILING Function - how to use CEILING Function
 
01:08
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
Oracle SQL Number Functions
 
11:09
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: 4 Ganesh Anbarasu
OracleSQL#48 How to use Power function in Oracle SQL Database| Number function in Oracle SQL
 
03:37
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: 16 EqualConnect Coach
SQL 075 Numeric Scalar, CEILING, CEIL or How can I round values upward?
 
01:06
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
Oracle Part 12 Outer Join and Dual
 
23:34
Outer join, substr, floor, ceil, round, dual
Views: 1035 Free OpenMentor
36. Number Functions in Oracle
 
06:55
In this video you will learn about Number Functions in Oracle. Unlike other programming language Oracle also uses functions to perform common operations. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 15565 ITORIAN
Use the FLOOR and CEILING Function
 
06:13
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: 6615 Doug H
OracleSQL#29 Types of SQL Functions in Oracle Database| Oracle SQL Function Classification
 
03:21
Explaining the brief introduction about the Types of Functions in Oracle SQL Or Different Types of SQL Functions or number functions or date functions or character function or aggregate function or conversion function or analytical functions or generals functions SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX SQL Number Functions- round,truncate,ceil,floor,absolute,sign,modulus,power SQL Character Functions lower,upper,inticap,concat,substring,lpad,rpad,trim,ltrim,rtrim,ascii SQL Date Functions-months_between,next_day,Last_day SQL Conversion Functions- to_char,to_date,to_number 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: 51 EqualConnect Coach
OracleSQL#50 How to replace String/Column Value  using Replace Function in Oracle SQL Database
 
05:47
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: 13 EqualConnect Coach
SQL 076 Numeric Scalar, CHAR_LENGTH or How many string characters?
 
01:15
Explains the Numeric Scalar Function CHARACTER_LENGTH and CHAR_LENGTH for finding the number of characters in the strings or expressions. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 231 cbtinc
Oracle MOD Function
 
03:17
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: 764 Database Star
Função Oracle FLOOR
 
03:59
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: 782 Aprenda PL/SQL
OracleSQL#51 How to use  modulus function in Oracle SQL Database| MOD Function in SQL
 
03:34
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
SQL 083 Numeric Scalar, POSITION or What is the starting position of a sub-string?
 
01:11
Explains the Numeric Scalar Function POSITION or return the position of a sub-string. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 214 cbtinc
Oracle Core,  Лекция 3-2
 
01:34:13
Ссылка на файл с презентацией: 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
CEILING SQL
 
01:20
פונקצייה CEILING
Views: 129 Gidi Aviezer
SQL 079 Numeric Scalar, FLOOR or How can I round values downward?
 
01:02
Explains the Numeric Scalar Function FLOOR to round a value downward 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: 169 cbtinc
FLOOR SQL
 
01:17
Views: 143 Gidi Aviezer
ORACLE  SQL Coding Lesson 3 in Jinghpaw Language - More Character and Numeric Functions
 
44:14
SQL Coding Lesson 3 in Jinghpaw Language - Lessons Continued. Please watch in HD mode for better video quality. --numeric functions SELECT ABS(12) FROM DUAL; SELECT ABS(-12.65) FROM DUAL; SELECT CEIL(48.99) FROM DUAL; SELECT CEIL(48.11) FROM DUAL; SELECT FLOOR(49.99) FROM DUAL; SELECT FLOOR(49.11) FROM DUAL; SELECT ROUND(49.11321,2) FROM DUAL; SELECT ROUND(49.11321,3) FROM DUAL; SELECT POWER(4,2) FROM DUAL; SELECT POWER(3,4) FROM DUAL; SELECT MOD(4,2) FROM DUAL; SELECT MOD(5051,100) FROM DUAL; select greatest(34,567,290,86) from dual; select least(34,567,290,86) from dual; select INSTR('Tech on the net', 'e') from dual; select INSTR('Tech on the net', 'e', 1, 1) from dual; select TRIM(' tech ') from dual; select TRIM(' ' FROM ' tech ') from dual; select TRIM(LEADING '0' FROM '000123') from dual; select TRIM(BOTH '1' FROM '123Tech111') from dual; select GREATEST(2, 5, 12, 3) from dual; select GREATEST('2', '5', '12', '3') from dual; select GREATEST('apples', 'oranges', 'bananas') from dual; select LEAST('2', '5', '12', '3') from dual; --null select (9000*null) from dual; select (null/9000) from dual; select (9000-null) from dual; select (9000+null) from dual; select distinct department_id from employees where commission_pct is not null; select last_name,job_id,coalesce(department_id,0) as dept,salary,commission_pct,coalesce(commission_pct,0) as comm_not_null, salary*commission_pct as multiplied_by_null, salary*coalesce(commission_pct,0) as commission_amt, salary+ (salary*coalesce(commission_pct,0)) as salary_plus_comm from employees where commission_pct is not null or department_id=20 order by dept; desc locations; select coalesce(postal_code,city,STATE_PROVINCE,COUNTRY_ID) as new_address,postal_code,city,STATE_PROVINCE,COUNTRY_ID from locations where COUNTRY_ID in ('JP','IT','UK'); --add more departments SELECT first_name ||'.'||last_name as "Employee Name",department_id, CASE when department_id in (10) THEN 'Accounting' WHEN department_id in (20) THEN 'Research' -- WHEN commission_pct is not null THEN 'Sales' WHEN department_id in (30) THEN 'Operations' ELSE 'Unknown' END department FROM employees ORDER BY first_name ||'.'||last_name ; SELECT last_name, department_id, DECODE( department_id ,10 ,'Accounting' ,20 ,'Research' ,30 ,'Sales' ,40 ,'Operations' ,'Unknown') department FROM employees ORDER BY last_name; select country_id,decode(country_id,'BR','Southern Hemisphere', 'AU','Southern Hemisphere', 'Northen Hemisphere') hemisphere from locations order by hemisphere; --set define on; select 'Coke & Popcorn' from dual; --upper,lower,coalesce and null select upper('sql') from dual; select lower('SQL') from dual; select initcap('sql') from dual; Select * from employees where email like '%SON'; Select * from employees where lower(email) like '%son'; Select * from employees where upper(last_name) like '%SON'; Select * from employees where lower(job_id) ='pu_clerk'; Select * from employees where initcap(email) ='Sbaida'; select * from employees where substr(phone_number,1,3) eq '515'; select * from employees where substr(phone_number,1,3) ne '515'; select * from employees where last_name gt 'King'; select * from employees where hire_date lt '01-JAN-1992'; --special character select * from jobs where job_id like 'SA\_%' escape '\'; select * from jobs where job_id like 'SA$_%' escape '$'; --translate, replace --( string1, string_to_replace, replacement_string ) select TRANSLATE('1tech23', '123', '456') from dual; select phone_number,translate(phone_number,'.','-') as modified_phnum from employees where rownum le 10; select job_id,translate(job_id,'_','&') as modified_phnum from employees where rownum le 10; select phone_number,translate(phone_number,'515','415') as modified_phnum from employees where rownum le 5; select phone_number,REPLACE(phone_number,'515','415') as modified_phnum from employees where rownum le 5; select REPLACE('123123tech', '123') from dual; select REPLACE('123tech123', '123') from dual; select REPLACE('222tech', '2', '3') from dual;
Views: 41 Hkau Doi
Função Oracle ROUND
 
08:34
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função ROUND faz o arredondamento dos valores e ela pode receber como parâmetro principal de entrada tanto um campo do tipo NUMBER como um DATE! SELECT first_name, salary / 2.7, round(salary / 2.7) AS ROUND, FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, salary / 2.7, round(salary / 2.7, 2) AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'MONTH') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'DAY') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; SELECT first_name, hire_date, round(hire_date, 'YYYY') AS ROUND FROM hr.employees WHERE job_id ='IT_PROG'; Veja os outros vídeos da nossa Playlist https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 558 Aprenda PL/SQL
SQL LEN() | LENGTH() Function
 
01:50
The SQL LEN() function returns the length of the value of a given input string or in a table field.
Views: 344 suresh babu
in-build numeric functions
 
17:25
This video will explain numeric functions like-mod,power,ceil,floor,round,trunc,sqrt,sign,abs.
Views: 651 kwl zerotwonine
11-Oracle Database  CONCAT,SUBSTR, LENGTH, INSTR, LPAD,RPAD, TRIM, Round,Trunc,Mod.avi
 
33:16
11-Oracle Database - Intro to Types of Single Row Functions - CONCAT,SUBSTR, LENGTH, INSTR, LPAD,RPAD, TRIM, Round,Trunc,Mod.avi
Views: 4433 Adel Sabour
aula 2398 Funções Numéricas abs ceil floor mod sqrt power
 
08:30
Aqui mais de 2.700 vídeo aulas no site www.informaticon.com.br.Desenvolvido pelo professor Neri Aldoir Neitzke, pós-graduado em Desenvolvimento para Web, professor e coordenador do curso de Sistemas de Informação da Universidade Ulbra e proprietário da Informaticon, email [email protected] 0xx543329-5400 Carazinho-RS Brasil Obs.: No youtube.com, as video aulas não estão nítidas e apenas a metade das vídeo aulas estão aqui. Caso queira, posso enviar um dvd com centenas de vídeo aulas originais com alta qualidade, e você ainda vai receber todo o código fonte.
Views: 880 Neri Neitzke
Round and Floor Functions
 
04:41
Showing how to use the Round and Floor Functions to modify data in your SQL query.
Views: 25 Alberto Rangel
83. SQRT Function in SQL (Hindi)
 
01:21
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 4629 Geeky Shows
Mysql  Math  Functions
 
04:39
Example of CEIL(),FLOOR(),ABS(),MOD(),SQRT(),ROUND(),SIGN(),GREATEST(),POWER() function.
Views: 32 LearningPoint92
Difference Between UNION and UNION ALL in oracle
 
07:29
Difference Between UNION and UNION ALL in 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: 112 TechLake
3.5.3 Numeric Function-FLOOR
 
01:32
Numeric Function-FLOOR
Views: 41 educaterz
Função Oracle MOD
 
05:40
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função MOD traz o valor restante da operação de divisão. No seu funcionamento ela recebe duas variáveis que vamos chamar de x e y e o resto da divisão de x por y é o resultado desta função. O seu calculo é feito da seguinte forma (x - (y * FLOOR(x/y))). Se quiser saber mais sobre a função FLOOR acesse este vídeo. https://youtu.be/O_7pW3WzBdU Códigos utilizados na aula: SELECT last_name, salary, MOD(salary, 5000) FROM hr.employees WHERE employee_id IN (150, 174, 176, 178); SELECT MOD(10,2) FROM dual; SELECT MOD(14,3) FROM dual; SELECT FLOOR (14/3) FROM dual; SELECT (14 - (3 * FLOOR(14/3))) FROM dual; Acesse a playlist com várias funções Oracle SQL https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 670 Aprenda PL/SQL
USING OF SIGN() Function  in SQL WITH EXAMPLE
 
05:23
Its all about"SIGN() Function" in SQL ,it helps to you that how can i used "SIGN() Function in SQL with example in details.....
Views: 88 Technical Aashique
Lesson 59  SQL Round Function   Part3   MySql Basic to Advance Toturails   Sahalsoftware
 
05:12
www.sahalsoftware.com Booqo markasta waxaad ka heleysaa casharo cusub oo aad kuu anfacaya, sidoo kale Share la wadaag asxaabtaada adiguna hoos noogu soo qor comments ah ee aad noo haysid.
Part 12 Maths Function in sql
 
04:27
ABS(x) returns the absolute value of x SIGN(x) returns the sign of input x as -1, 0, or 1 (negative, zero, or positive respectively) MOD(x,y) modulo - returns the integer remainder of x divided by y (same as x%y) FLOOR(x) returns the largest integer value that is less than or equal to x CEILING(x) or CEIL(x) returns the smallest integer value that is greater than or equal to x POWER(x,y) returns the value of x raised to the power of y ROUND(x) returns the value of x rounded to the nearest whole integer ROUND(x,d) returns the value of x rounded to the number of decimal places specified by the value d SQRT(x) returns the square-root value of x
Views: 245 Learn Everything
MySQL Tutorial : floor and ceiling
 
01:51
Both floor and ceil function are confused for beginner. So, user can not work it properly. So to use this function properly visit to codesnipr to get full information about this article. Codesnipr tutorial introduces video tutorial where beginner can easily clear about this article. http://www.codesnipr.com/snippet/864/SQL-floor-and-ceiling
Views: 480 MrAmitweb