Home
Search results “Oracle sql month add”
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 42150 etldeveloper
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: 1056 WingsOfTechnology
IsDate, Day, Month, Year and DateName DateTime functions in SQL Server   Part 26
 
12:51
In this video we will learn about built-in date and time functions in sql server, specifically IsDate, Day, Month, Year and DateName functions. Finally a practical example of using these DateTime functions. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/isdate-day-month-year-and-datename.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-26-datetime-functions-continued.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 141907 kudvenkat
Working with dates in Oracle PLSQL.
 
23:34
Dates in Oracle PL SQL is definitely the most powerful among all other databases. It gives us full flexibility to manipulate it of our choice, whether you are calculating days, months or year, printing date and time in various format. Useful date functions add_months, months_between, last_day, next_day and to_char helps us a lot in handling date time in our pl sql programming.
Views: 5167 Subhroneel Ganguly
Oracle || Date functions Part-1 by dinesh
 
17:06
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
SQL Tutorial - 45: Date & Time Functions (Part-1)
 
05:15
In this tutorial we'll see how we can add dates, subtract dates, view current date and current time using ADDDATE(), SUBDATE(), CURDATE() and CURTIME Functions respectively.
Views: 33279 The Bad Tutorials
Oracle SQL: Exploring Date Functions
 
07:29
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Exploring Date Functions is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 4640 LiveLessons
SQL Tutorial - SQL DATE Functions like GETDATE, DATEADD, CONVERT
 
09:54
http://www.learningsqlserver2008.com/ https://youtu.be/KmsmPOImpHo - Date functions in SQL Server 2012 GETDATE -- Today's date DATEADD - adding time interval to an existing Date DATEPART - return part of the date like year or month DATEDIFF - Give you the different between two dates DAY - returns the day of the month MONTH - return the Month of the Year YEAR - returns the year in the Sql expression CAST - Converts an expression of one data type to another in SQL Server 2008 R2 CONVERT - Convert expressions of one data type to another in sql server r2 SQL Tutorial
Views: 55153 baghul
Part 5   SQL query to find employees hired in last n months
 
04:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-5-sql-query-to-find-employees.html This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer. -- Replace N with number of months Select * FROM Employees Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 161224 kudvenkat
How to add days months or years to date using DateAdd function SQL Server
 
04:22
Published on Sep 10, 2017: In this video tutorial, we will learn to add subtract days,months, quarters and years from any given date. We can use the same logic for other date parts mentioned in the Microsoft documentation. Link to the microsoft documentation https://goo.gl/7M8Yjc Example 1 SQL Used: Select getdate() ,DateAdd(day,10,getdate())DayAdd --Add Day(s) ,DateAdd(day,-10,getdate())DaySubtract --Subtract Day(s) , DateAdd(month,1,getdate())MonthAdd--Add Month(s) ,DateAdd(month,-1,getdate())MonthSubtract--Subtract Month(s) ,DateAdd(year,1,getdate())YearAdd--Add Year(s) ,DateAdd(year,-1,getdate())YearSubtract--Subtract Year(s) Example 2 SQL Used: SELECT [FullDateAlternateKey] ,DateAdd(day,10,[FullDateAlternateKey])DayAdd --Add Day(s) ,DateAdd(day,-10,[FullDateAlternateKey])DaySubtract --Subtract Day(s) , DateAdd(month,1,[FullDateAlternateKey])MonthAdd--Add Month(s) ,DateAdd(month,-1,[FullDateAlternateKey])MonthSubtract--Subtract Month(s) ,DateAdd(year,1,[FullDateAlternateKey])YearAdd--Add Year(s) ,DateAdd(year,-1,[FullDateAlternateKey])YearSubtract--Subtract Year(s) FROM [AdventureWorksDW2012].[dbo].[DimDate] Previous Video:https://youtu.be/_voKLD97XH0 SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel and SQL Server! https://www.youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw Download the sample database used for the demo here: https://goo.gl/SVyVmT Our Playists: SQL Playlist :https://goo.gl/PS5Ep6 DAX PlayList : https://goo.gl/S4W41D Power BI PlayList: https://goo.gl/dXxvnB Power Query Playlist: https://goo.gl/5QS7P4 ABOUT DAGDOO: Website: Home Page: http://www.dagdoo.org/ Power BI Tutorials: http://www.dagdoo.org/excel-learning/tutorial-power-bi-desktop/ Questions? Comments and SUGESTIONS? You will find me here: Twitter: @dagdooe Category: Science & Technology License: Standard YouTube License
Views: 454 Learn 2 Excel
113- Oracle SQL 12c: Managing Data in Different Time Zones 1
 
15:42
EXAM 1Z0-061 EXAM 1Z0-071 •Time Zones. •Timestamp Data type •timestamp with time zone •timestamp with local time zone •V$TIMEZONE_NAMES •DBTIMEZONE •SESSIONTIMEZONE •current_date •current_timestamp •Localtimestamp •alter session set time_zone •Extract expression •TZ_OFFSET •from_tz •to_timestamp •to_yminterval •to_dsinterval
Views: 1458 khaled alkhudari
SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online
 
08:41
http://www.sqltrainingonline.com SQL Date Comparison - How to filter Datetime in SQL Server - SQL Training Online In this video, I show you how to do a SQL Date Comparison in SQL Server when your Datetime has an actual time in it. I also include the latest trick that will make this easier if you are using SQL Server 2008 or SQL Server 2012. How do you compare a Datetime in SQL Server? A SQL Datetime stores both Date and Time. So when you are filtering using the SQL Where clause, you have to know if you Datetime is storing the time also. Let's take a look at the employee table in SQL Training Online Simple DB The column we are looking at is the hire date. I want to go after the person who was hired on February, 22 2005. So, I use the following SQL. select * from employee where hire_date='02/22/2005' Now, this works because we don't have any times stored in this column. But, if I change the record from 2005-02-22 00:00:00.000 to 2005-02-22 08:22:25.000 and rerun the query, you see that I don't get any results. That is because the value of 02/22/2005 is really 2005-02-22 00:00:00.000 and I just changed the hire_date to include a time other than 00:00:00.000. So, I have to tweak my query to use a greater than and less than sign. This works. But, to really understand what is going on, let me show you what SQL Server really sees. There are other ways, and in this StackOverflow article you can read more about these other ways. But, I want to point out a few. If you are working in SQL Server 2005 or earlier, the following is supposed to be the fastest performing way to do this. select datediff(dd,0, hire_date),* from employee where dateadd(dd,0, datediff(dd,0, hire_date)) = '2005-02-22' But, if you are working in SQL Server 2008 or SQL Server 2012, they have introduced an actual Date datatype that doesn't include the Time portion. Since this is the case, you can use the CAST function to remove the time from the Datetime. Here is the SQL to do that. select * from employee where CAST(hire_date AS Date) = '2005-02-22' And that's it. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 26347 Joey Blue
add months in sql
 
02:03
Views: 67 asim
Date Functions (Introduction to Oracle SQL)
 
05:48
Learn what date functions are and see some examples of them. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 179 Database Star
TSQL: GROUP BY Quarter And Six Months/Half Year
 
05:19
This video is sponsored by FinTek Development. You can get the code on their sponsored post https://www.fintekdev.com/tsql-group-by-quarter-six-months-half-year/. Automating ETL: https://www.udemy.com/automatingetl/
Views: 1532 SQLInSix Minutes
SQL: Extract function
 
03:38
In this tutorial, you'll learn how to make use of extract function. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 3352 radhikaravikumar
ORACLE SQL  DATE FUNCTIONS
 
05:03
This video shows examples of oracle sql date functions
Views: 1344 SQL TUTORIALS
Oracle TO_TIMESTAMP Function
 
01:31
https://www.databasestar.com/oracle-to_timestamp/ The Oracle TO_TIMESTAMP function can be confusing, but we’ll explain it in this video. This function allows you to convert a string value into a TIMESTAMP value. A TIMESTAMP value is a type of DATE, but has a few components: - A date, including day, month, and year - A time, including hours, minutes, seconds, and fractional seconds This is a useful data type because it allows you to store a time down to fractions of a second. The syntax of the TO_TIMESTAMP function is: TO_TIMESTAMP ( input_string [, format_mask] [, nls_param] ) The input_string parameter is the string you want to convert. The format_mask is where you specify the format of the input_string parameter. This is so you can specify the input_string in a variety of formats, and just use this format_mask to indicate which format it is in. The nls_param parameter is another optional parameter, and allows you to specify the returning language of the month and day names. The default format will depend on the region you’re running your database in. In my example (using Oracle Express in Australia), the default format is ‘DD-MM-RRRR HH:MI:SS AM’. For more information on the Oracle TO_TIMESTAMP function, including the SQL used in this video, read the related article here: https://www.databasestar.com/oracle-to_timestamp/
Views: 295 Database Star
Using DATEADD to Add and Subtract Days from a Date in SQL (C1B1T1 7.3)
 
03:52
Using DATEADD to Add and Subtract Days from a Date in SQL (C1B1T1 7.3)
Views: 1713 Ian Martyn
TO_CHAR(datetime) Function in SQL Query
 
03:59
TO_CHAR (datetime) : TO_CHAR (datetime) converts a datetime datatype to a value of VARCHAR2 datatype in the format specified by the date format. The following is a list of valid parameters when the TO_CHAR function is used to convert a date to a string. These parameters can be used in many combinations. YEAR Year, spelled out YYYY 4-digit year YYY Last 3 digits of year. YY Last 2 digits of year. Y Last 1 digit of year. IYYY 4-digit year based on the ISO standard Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1). MM Month (01-12; JAN = 01). MON Abbreviated name of month. MONTH Name of month, padded with blanks to length of 9 characters. RM Roman numeral month (I-XII; JAN = I). WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. IW Week of year (1-52 or 1-53) based on the ISO standard. D Day of week (1-7). DAY Name of day. DD Day of month (1-31). DDD Day of year (1-366). DY Abbreviated name of day. J Julian day; the number of days since January 1, 4712 BC. HH Hour of day (1-12). HH12 Hour of day (1-12). HH24 Hour of day (0-23). MI Minute (0-59). SS Second (0-59). SSSSS Seconds past midnight (0-86399). FF Fractional seconds. Thanks for watching...:)
Views: 9924 WingsOfTechnology
T-SQL: Find Last Day of Month
 
22:04
Follow Jen as she steps you through 3 progressively elegant solutions for finding the last day of the month.
Views: 114 MidnightDBA
ORACLE SQL 24: NEXT_DAY, LAST_DAY
 
05:16
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 744 studyandsharevn
Calculate running total in SQL Server 2012
 
06:23
running total sql server cumulative total in ms sql server running total column In this video we will discuss how to calculate running total in SQL Server 2012 and later versions. We will use the following Employees table for the examples in this video. SQL Script to create Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 5000) Insert Into Employees Values (2, 'John', 'Male', 4500) Insert Into Employees Values (3, 'Pam', 'Female', 5500) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 3500) Insert Into Employees Values (6, 'Mary', 'Female', 5000) Insert Into Employees Values (7, 'Ben', 'Male', 6500) Insert Into Employees Values (8, 'Jodi', 'Female', 7000) Insert Into Employees Values (9, 'Tom', 'Male', 5500) Insert Into Employees Values (10, 'Ron', 'Male', 5000) Go SQL Query to compute running total without partitions SELECT Name, Gender, Salary, SUM(Salary) OVER (ORDER BY ID) AS RunningTotal FROM Employees SQL Query to compute running total with partitions SELECT Name, Gender, Salary, SUM(Salary) OVER (PARTITION BY Gender ORDER BY ID) AS RunningTotal FROM Employees What happens if I use order by on Salary column If you have duplicate values in the Salary column, all the duplicate values will be added to the running total at once. In the example below notice that we have 5000 repeated 3 times. So 15000 (i.e 5000 + 5000 + 5000) is added to the running total at once. SELECT Name, Gender, Salary, SUM(Salary) OVER (ORDER BY Salary) AS RunningTotal FROM Employees So when computing running total, it is better to use a column that has unique data in the ORDER BY clause. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/calculate-running-total-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/calculate-running-total-in-sql-server_3.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 50208 kudvenkat
Year-to-Date using Partition By with Windowing - SQL Training Online
 
05:43
You can use the Partition By Function in SQL Server to get a Year-to-Date and Month-to_Date calculation. In this video I show you how to create a Year-to-Date value using the Windowing Partition By Function in TSQL. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/year-to-date-using-the-partition-by-function-with-windowing-in-sql-server/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 1802 Joey Blue
Running total in SQL
 
04:21
Using a correlated subquery to produce a running total (or running balance) column.
Views: 10096 Barry Brown
Oracle Date Format
 
07:13
http://www.databasestar.com/oracle-to_date/ - A video that explains the different date formats in the Oracle SQL database.
Views: 3339 Database Star
13 Interval Datatype in PL SQL
 
06:59
Oracle PL/SQL Tutorial - A Comprehensive Training Course https://www.youtube.com/channel/UCXLir0qvG4xDmgLtGZBd8qg
Views: 228 Satyam Rai
[Oracle] Bài 23 - ADD MONTHS, MONTHS BETWEEN
 
05:24
============================================== - NLITS VietNam là kênh truyền thông đa phương tiện được quản lý bởi NLits nhầm cung cấp các video thuộc mọi lĩnh vực từ giải trí cho đến học tập. - Vui lòng ghi rõ nguồn NLitsolution khi re-up video từ kênh của chúng tôi lên website của bạn. Chân thành cảm ơn. © Bản Quyền Thuộc Về NLITSolution + Website: http://www.nlits.net + Email: [email protected]
Views: 137 NLITS VietNam
SQL MONTH() Function
 
01:36
The SQL MONTH() is a function, and return or extract the month value (a whole integer number from 1 to 12) of a given input date value.
Views: 203 suresh babu
Part 6   Transform rows into columns in sql server
 
08:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 178878 kudvenkat
PIVOT Tutorial - generating dynamic column with PIVOT Interview Question SQL
 
14:14
In this lecture you will learn about PIVOT operator and using it to generate dynamic columns.PIVOT is very use full operator to convert values into columns. PIVOT: •Convert your output from (values)vertical order to horizontal(making columns) one Topic to cover: •PIVOT example •PIVOT syntax •Interview Question •PIVOT on northwind •Dynamic PIVOT query http://www.techsapphire.in/index/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/0-158
Views: 27096 techsapphire
MariaDB TX 3.0, the OSS Alternative to Closed Databases like Oracle, MSSQL & DB2
 
52:29
MariaDB TX 3.0, the OSS Alternative to Closed Databases like Oracle, MSSQL & DB2 by Rasmus Johansson, VP of Engineering, MariaDB • Funny pre-event tech-trivia: https://youtu.be/rgBpE9dwBjs We have a reason to celebrate! You finally have an open-source alternative to proprietary databases like Oracle, IBM DB2 and MS SQL Server! In the past, features like temporal tables and queries, purpose-built storage engines, data masking and obfuscation with instant, invisible or compressed columns required the use of a proprietary database, but now MariaDB TX 3.0 delivers these in an enterprise open source database. This presentation introduces the latest features available in MariaDB TX 3.0, why they were developed, how you can use them and what they mean for your business. You will learn about: • Oracle compatibility, including sequences and stored procedures • Temporal tables and queries, as well as deployment strategies • The use of different storage engines for different tables • Protecting personal data with masking and obfuscation • Adding columns without ever needing to rebuild tables As part of our celebration, we will be pouring Salmiakki Koskenkorva, a licorice-flavored black vodka that is a favorite of Finland! ••• Rasmus Johansson, VP of Engineering, MariaDB ••• Rasmus manages MariaDB Server development. He joined Monty Program Ab in 2010 where he served as the COO of the company. Monty Program became MariaDB Corporation after merging with SkySQL in 2013. Previously, Rasmus worked for Microsoft where he focused on SQL Server and before that he worked for CGI and Icon Medialab. He started his career as a developer and still enjoys being part of engineering. He is based in Helsinki, Finland.
Custom date time format in Oracle SQL Developer?
 
01:03
From Oracle SQL Developer's menu go to Tools -- Preferences. From the Preferences dialog, select Database -- NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS or for 24-Hour, DD-MON-YY HH24:MI:SS Or just for an active session use below instead. alter SESSION set NLS_DATE_FORMAT = 'required_date_format' i.e. alter SESSION set NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS' into the Date Format field. Save and close the dialog.
Views: 367 Maruti AIR Tech
How to use partitioning to improve performance of large tables
 
42:49
In this video we cover in much more detail the improvement in performance that can be achieved by using partitioning. MS SQL server databases can scale well using this feature. We cover how partitioning a table gives similar performance as a single table with a clustered index, we then explore how adding NC index improve performance of the heap table as well as the partitioned table.
Views: 17303 Jayanth Kurup
Oracle Date Function - 2
 
07:10
Oracle Date Function, Order by Month Year. Getting employee count hired month, yearwise and order by hiring month and year. SQL Used in the video below. select * from employees order by hire_date; select hire_date,to_char(hire_date,'Month,YYYY') from employees; select to_char(hire_date,'Month,YYYY')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_char(hire_date,'Month,YYYY') select to_char(hire_date,'Month,YYYY')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_date(to_char(hire_date,'Month,YYYY'),'Month,YYYY') select replace(to_char(hire_date,'Month,YYYY'),' ','')Month_Year,count(*) No_Of_Employees from employees group by to_char(hire_date,'Month,YYYY') order by to_date(to_char(hire_date,'Month,YYYY'),'Month,YYYY')
Views: 40 Ganesh Anbarasu
SQL Aggregation queries using Group By, Sum, Count and Having
 
10:01
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 161936 Joes2Pros SQL Trainings
SQL 37 -How to calculate age Part 1
 
05:05
Structured Query Languge
Views: 6308 hammadshams
Introduccion al lenguaje SQL - Las funciones SYSDATE, MONTHS BETWEEN y otras (27)
 
02:29
En el curso de sql gratuito hoy es el turno de las funciones SYSDATE, MONTHS BETWEEN, ADD_MONTHS, NEXT_DAY y LAST_DAY. Todo el contenido del curso de lenguaje SQL para bases de datos Oracle está disponible en http://cursodelenguajesql.blogspot.com
Views: 1236 Asteriscoo Mas
SQL: Lag
 
04:40
In this tutorial, you'll learn how to make use of lag function in oracle sql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 1873 radhikaravikumar
Recuparando data atual (SYSDATE) Oracle
 
00:13
Comando para recuperar data atual do banco de dados Oracle.
Views: 185 Tecla Nossa
Cast and Convert functions in SQL Server   Part 28
 
17:26
In this video we will learn, converting one data type to another using cast() and convert() functions. We will also learn how to use the style parameter, with convert() function. Finally we will look at a practical example of using CAST or CONVERT functions, along with group by. We will also talk about the differences between CAST and CONVERT functions and when to choose one over the other. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/cast-and-convert-functions-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-28-cast-and-convert-functions.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 168968 kudvenkat
Fetch or Filter Data from Date to Date
 
17:35
The Data Fetch or filter or search From date to date ( month to month , year to year ) by using datetimepicker in Dot Net.
Views: 54924 C# Tutorial
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Filtering on Date Values using the SQL WHERE Clause (Introduction to Oracle SQL)
 
03:36
How to filter on date values in SQL using the SQL WHERE clause. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 143 Database Star
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
Looking for a best Webhosting Company at low and Best Service click this link:https://www.ipage.com/join/index.bml?AffID=739220 From Last Few Months I Was Looking For Best Webshosting Company Where I Can Host My 100 Of Website At Low Price And With Best Quality Service , And Then I Came To Know About https://www.ipage.com/join/index.bml?AffID=739220 A Hosting Company Where I Get Hosting For Unlimited Domains At Just 1.6$ Per Month With Control Panel , 24hrs Support And All In All A Best Platform To Host Any Website( one-click install wordpress option) .Dont Be Late Offer Valid Till 25th October 2014 , Host Your WebSite With Best Service Provider Today By Clicking The Link Above Or Here: https://www.ipage.com/join/index.bml?AffID=739220 To get a responsive and Modern design contact http://www.variabletips.com and get at just 20$ Now !!! Check my Website: http://variabletips.com for more details. If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Open the sql plus in your system. Login as username : sys as sysdba and the password which is given at the time of installation. After connected to Oracle database you need to create the scott schema. Run this script: CREATE USER scott IDENTIFIED BY tiger; scott is the user tiger is the password. Grant all access to user scott,run this script: GRANT ALL PRIVILEGES TO scott; Download the Oracle default tables file: https://www.dropbox.com/s/m9lr8cnc00vqy3i/oracle.zip https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA/edit?usp=sharing Extract the downloaded file in your system. Then Connect to Scott user as: CONNECT scott Password: tiger Then type this in your sql command prompt: @(extract file path)\oracle.sql; for example: @C:\Users\ABC\oracle\oracle.sql; Now you done all the steps completely and you can work with scott schema and all the default tables. Check This in your system to show all the tables in scott user: Select * from tab; After that you can see all the default table in scott user. Just run it to show the default data inside the tables. Select * from emp; If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your system. Like and subscribe this video: http://www.youtube.com/watch?v=vHcAs7k93AQ
Views: 17153 variabletips
How to Fetch Latest record/row from the Table in Oracle Database
 
03:32
You will learn how to How to Fetch Latest record/row from the Table in Oracle Database. Realtime Scenario: This logic can be implemented to find whether the latest record should be inserted or updated to datawarehouse
Writing Basic SQL to get Sales Data
 
10:53
http://www.ReportingGuru.com produced this video. This video shows basic SQL that you would need to aggregate your data for a sales report. The query would be used in a various reporting tools as a data source. The reporting tool is then used to display and format your data. Email us at [email protected] if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759
Views: 2725 Reporting Guru
Part 1   How to find nth highest salary in sql
 
11:45
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the end of this video, we will be able to answer all the following questions as well. How to find nth highest salary in SQL Server using a Sub-Query How to find nth highest salary in SQL Server using a CTE How to find the 2nd, 3rd or 15th highest salary Let's use the following Employees table for this demo Use the following script to create Employees table Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) GO To find the highest salary it is straight forward. We can simply use the Max() function as shown below. Select Max(Salary) from Employees To get the second highest salary use a sub query along with Max() function as shown below. Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees) To find nth highest salary using Sub-Query SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP N SALARY FROM EMPLOYEES ORDER BY SALARY DESC ) RESULT ORDER BY SALARY To find nth highest salary using CTE WITH RESULT AS ( SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK FROM EMPLOYEES ) SELECT TOP 1 SALARY FROM RESULT WHERE DENSERANK = N To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. Similarly, to find 3rd highest salary, simple replace N with 3. Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates. WITH RESULT AS ( SELECT SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER FROM EMPLOYEES ) SELECT SALARY FROM RESULT WHERE ROWNUMBER = 3
Views: 828755 kudvenkat

Term paper writing service
What is a good essay writing service
Web content writing service
Annotated bible slavery condone
Professional writing service