Home
Search results “Abs oracle sql”
SQL Tutorial - 33: ABS() Function
 
04:39
In this tutorial we'll check out the ABS() function that returns the absolute value of a number.
Views: 29394 The Bad Tutorials
abs, sin & cos | sql functions | oracle database 11g version 2 |
 
04:12
executed in oracle database 11g version 2
Views: 336 Education 4u
Oracle SQL Tutorial 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: 43 Ganesh Anbarasu
mod, power  sqrt & trunc | sql functions | oracle database 11g version 2 |
 
07:19
executed in oracle database 11g version 2
Views: 388 Education 4u
SQL Tutorial - 34: ROUND() Function
 
06:51
In this tutorial we'll see how we can round off numbers conveniently in SQL using the ROUND() Function/
Views: 38801 The Bad Tutorials
.NEXT 2016 Solutions Demo: MCS/AHV, SQL Server/AHV, ABS/Oracle RAC
 
03:42
Watch the demo video form Nutanix .NEXT 2016 keynote showcasing multiple virtual and physical workloads being simultaneously supported including Citrix XenDesktop with MCS on Nutanix's built in virtualization )(AHV), SQL Server on AHV and Oracle RAC with storage being served through Nutanix Acropolis Block Services. Read the blog for more details: http://www.nutanix.com/2016/06/21/the-next-2016-keynote-demo-virtual-and-physical-workloads-on-ahv/
Views: 1930 Nutanix
Oracle - SQL - Number Functions
 
03:59
Oracle - SQL - Number Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SQL Tutorial - 24: The TOP and LIMIT Clauses
 
03:38
In this tutorial we'll see how we can use the LIMIT Clause in the MySQL environment to control the number of records that are returned in the result set of a query.
Views: 46138 The Bad Tutorials
ABS() Function in SQL
 
01:37
This Video will explain you how to use ABS() function in SQL. This SQL ABS() returns the absolute value of a number passed as argument.
Views: 312 Himadri Patel
How to Display  Middle Record Of a Table in Oracle SQL
 
11:13
Print Middle Record Of a Table in Oracle SQL
Views: 201 Adam Tech
SQL Tutorial - 35: DIV() & MOD() Functions
 
04:05
In this tutorial we'll learn to use the DIV() and MOD() functions to obtain the quotient and remainder of division operations respectively.
Views: 27939 The Bad Tutorials
3.5.1 Numeric Function-ABS Function
 
01:37
Numeric Function-ABS Function
Views: 141 educaterz
SQL: Savepoint (TCL Command)
 
03:55
In this tutorial, you'll learn one of the TCL command i.e Savepoint..
Views: 11513 radhikaravikumar
Oracle on Nutanix ABS (Acropolis Block Service) Failover
 
02:00
Oracle on Nutanix ABS (Acropolis Block Service) Failover
Views: 700 Albert Chen
Oracle ADD_MONTHS Function
 
03:15
https://www.databasestar.com/oracle-add_months/ The Oracle ADD_MONTHS allows you to add a specified number of months to a date value, and return the new date value. It’s great for performing calculations on dates, or date arithmetic, which can be hard in many different programming languages. The syntax of the ADD_MONTHS function is: ADD_MONTHS ( input_date, number_months ) The function returns a DATE value. The parameters of this function are: - input_date (mandatory): This is the starting date, or the date that you will add a number of months to. - number_months (mandatory): This is an integer value that represents the number of months to add to input_date. The input_date can be any datetime value, or even a character value that can be converted to a date. Also, the number_months can be any number value, or a character value that can be converted to a number. What if the number of days in the two months are different? For example, adding a month to Jan 31 could result in Feb 31, which does not exist. Well, in this case, Oracle would work out that the date does not exist, and use the last date of the month (e.g. Feb 28). You can also provide a negative value for ADD_MONTHS to subtract months from the specified date. For more information about the Oracle ADD_MONTHS function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-add_months/
Views: 587 Database Star
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: 1321 Database Star
length, concat & chr | sql functions | oracle database 11g version 2 |
 
05:24
executed in oracle database 11g version 2
Views: 278 Education 4u
Oracle LPAD Function
 
04:27
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: 815 Database Star
Oracle - SQL - Character Functions
 
08:46
Oracle - SQL - Character Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Oracle Tutorial - Date Functions MONTHS_BETWEEN | ADD_MONTHS
 
11:40
Oracle Tutirials: Date functions MONTHS_BETWEEN () | ADD_MONTHS ()
Views: 376 Tech Acad
SQL 073 Numeric Scalar, ABSOLUTE, ABS or What are the positive values?
 
01:08
Explains the Numeric Scalar Function ABSOLUTE or ABS for finding the absolute value of a numeric field or expression. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 199 cbtinc
SQL ABS Function - how to use ABS Function
 
00:52
SQL ABS function returns the absolute value of a number. visit Dose for excel Add-In website: http://www.zbrainsoft.com/ Visit our channel: https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
Mathematical Functions in SQL SERVER Part I || ABS, CEILING, FLOOR, POWER functions in SQL 2014
 
04:23
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: 208 Softtech forum
ascii,instr | sql functions | oracle database 11g version 2 |
 
07:21
executed in oracle database 11g version 2
Views: 426 Education 4u
SQL 36, trunc function
 
02:36
What you can do with trunc function in SQL
Views: 4428 hammadshams
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: 617 Database Star
SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider
 
08:05
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 47556 Manish Sharma
Oracle GREATEST Function
 
02:43
https://www.databasestar.com/oracle-greatest/ The Oracle GREATEST function is a useful function, but I don’t think it’s very well understood. It returns the greatest or largest value in a set of values. You can provide the values, and use numbers or text values. The syntax for the Oracle GREATEST function is: GREATEST(expr1 [, expr_n]) The expr1 is the first expression to use for your comparison. Expr_n is one or more expressions to use in the comparison, separated by commas. This is optional. So how is GREATEST calculated? If the parameters are numeric, the GREATEST function finds the largest number. If the parameters are characters, the function finds the latest value if they were sorted alphabetically (using their character values). What data type is returned? It depends on the parameters you provide. It could be the same as the parameters you provide, or VARCHAR2 if the parameters are all characters. You can also use the GREATEST function with dates. It’s also the opposite of the LEAST function. For more information on the GREATEST function, including the SQL used in this video and the examples, read the related post here: https://www.databasestar.com/oracle-greatest/
Views: 356 Database Star
Oracle TO_NUMBER Function
 
02:42
https://www.databasestar.com/oracle-to_number/ The Oracle TO_NUMBER function is used to convert a text value into a number value. It’s similar to TO_CHAR and TO_DATE, but converts a value to a number. The number will also be rounded to a specified number of digits, and returned as a NUMBER value. The syntax is: TO_NUMBER( input_value, [format_mask], [nls_parameter] ) The input_value is the value to be converted to a number. Commonly this is provided as a string (e.g. CHAR or VARCAHR2) but can be several other data types as well. The format_mask is the format that the output value should be displayed as. It must be a valid number format. This is an optional value. The final parameter, nls_date_language, is used to work out how the output is displayed, such as how to display currency symbols. It’s also an optional value. For more information about the Oracle TO_NUMBER function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-to_number/
Views: 2728 Database Star
Oracle MONTHS_BETWEEN Function
 
02:17
https://www.databasestar.com/oracle-months_between/ The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference. This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions. The syntax of the MONTHS_BETWEEN function is: MONTHS_BETWEEN(date1, date2) What do these two parameters mean? The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative. What data type is returned? It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value. For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here: https://www.databasestar.com/oracle-months_between/
Views: 1253 Database Star
163 #Absolute (abs) function (Hindi)
 
04:08
This Video illustrates the concept of absolute (abs) function For more videos subscribe this channel - https://www.youtube.com/user/DrKapilGovil My Book: https://goo.gl/AkbjWT My Mobile: https://goo.gl/5VyPey My Laptop: https://goo.gl/Rn76C8 My Light Setup: https://goo.gl/KYzhAQ My Cellphone stand: https://goo.gl/9ChzJ7 My Lapel Mic: https://goo.gl/hmy7WY My Tripod: https://goo.gl/AfeiXf My Light: https://goo.gl/5sFzS1 Disclaimer: Content delivered in this video are as per best of my knowledge and experience. Viewers are suggested to refer standard reference books for further study.
Views: 53 Dr. Kapil Govil
#017 - ABS, CEIL,CEILING, FLOOR, ROUND, SELECT TRUNCATE, DIV
 
08:23
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: 190 João Ribeiro
Oracle on Nutanix ABS (Acropolis Block Service) Failback
 
02:58
Oracle on Nutanix ABS (Acropolis Block Service) Failback
Views: 357 Albert Chen
Essbase @ABS Function
 
02:14
interRel presents Look Smarter Than You Are With Oracle Essbase Calc Scripts: @ABS Function Edward Roske
LNNVL FUNCTION IN ORACLE SQL
 
09:11
This video is the 5th video in the series of 'working with null', this video explains the working of the lnnvl function in oracle sql with simple and easy to understand example. LNNVL provides a concise way to evaluate a condition when one or both operands of the condition may be null. The function can be used only in the WHERE clause of a query. It takes as an argument a condition and returns TRUE if the condition is FALSE or UNKNOWN and FALSE if the condition is TRUE. LNNVL can be used anywhere a scalar expression can appear, even in contexts where the IS [NOT] NULL, AND, or OR conditions are not valid but would otherwise be required to account for potential nulls. Oracle Database sometimes uses the LNNVL function internally in this way to rewrite NOT IN conditions as NOT EXISTS conditions. In such cases, output from EXPLAIN PLAN shows this operation in the plan table output. The condition can evaluate any scalar values but cannot be a compound condition containing AND, OR, or BETWEEN.
Views: 718 Kishan Mashru
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: 48 Hkau Doi
Numeric Functions in SQL | Oracle SQL fundamentals
 
06:16
Enroll into full course with free cloud access for 30 days: https://dbagenesis.com/p/oracle-sql-fundamentals/
Views: 118 DBA Genesis
How to Implement Numeric or maths Functions in Oracle 10g Database.
 
12:58
Hello Friends, Today we will see how to implement various Numeric / Maths Functions in Oracle 10g Database. In this Video we will Implement following Numeric Functions 1) abs() 2) ceil() 3) exp() 4) floor() 5) power() 6) mod() 7) round() 8) trunc() 9) sqrt() 10) sin() 11) cos() 12) tan() If you like this video then Subscribe to my Channel and share this video. Thank You for watching.
Views: 41 Hardik Parmar
Oracle EXP Function
 
01:15
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: 195 Database Star
SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS
 
05:17
In this tutorial we'll see how we can use the Group By clause with Joins in SQL.
Views: 53010 The Bad Tutorials
29. SQL Functions - Numeric
 
09:40
ORACLE SQL NUMERIC FUNCTIONS This video shows oracle numeric functions for beginners. For Group / Aggregate Functions visit : https://youtu.be/tF_qnt_Nt7Y
Views: 148 ProSchool
ORACLE SQL NUMERIC FUNCTIONS
 
05:26
This video shows Oracle numeric function.
Views: 1697 SQL TUTORIALS
Oracle SQL Practical question with answer claculate the group salary
 
07:46
https://easy-learning-tech.blogspot.com/2018/12/compute-group-salary.html -------------------------------------------------------------------------------------------- SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis SQL scenario based interview questions -------------------------------------------------------------------------------------------- Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 458 Siva Academy
ADD_MONTHS Function in SQL Query with Example
 
02:32
ADD_MONTHS(): The Oracle/PLSQL ADD_MONTHS function returns a date plus n months. Syntax: ADD_MONTHS( date1, n ) Arguments: date1 is the starting date (before the n months have been added). n is the number of months to add to date1. Example: Let's look at some Oracle ADD_MONTHS function examples and explore how you would use the ADD_MONTHS function in Oracle/PLSQL. ADD_MONTHS('01-Aug-03', 3) would return '01-Nov-03' ADD_MONTHS('01-Aug-03', -3) would return '01-May-03' ADD_MONTHS('21-Aug-03', -3) would return '21-May-03' ADD_MONTHS('31-Jan-03', 1) would return '28-Feb-03' Thanks for watching..:)
Views: 1185 WingsOfTechnology
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: 908 Neri Neitzke
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: 1799 Vijay Mulsaniya
LENGTH Function in SQL Query
 
02:33
Length(): This function is used to calculate the length of a string or column in query. Here space is also treated as one more character. so the count is 10. Queries used in Video: select ename,length(ename) from emp; select length('oracle num') from dual; Thanks for watching..:)
Views: 2520 WingsOfTechnology
SQL Tutorial - 29: SQL JOINS
 
07:54
In this tutorial we'll take a look at SQL JOINS and see how we can pull data from two tables through a single query!
Views: 109832 The Bad Tutorials