Home
Search results “Return value in oracle”
Stored Procedures in PL/SQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar
 
18:54
Stored Procedures:- A Stored Procedure is also a Named PL/SQL block the accepts some input in the form of parameters and performs some task and many or many not returns a value Procedures are created to perform one or more dml operations over database.
Views: 50996 Naresh i Technologies
08 of  13 - Oracle APEX 5 - List of values (LOV) for a field in a form; display a hidden column
 
13:22
A new series using APEX 18.1 is now available. https://youtu.be/vgrkiIpJEiQ This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create two lists of values (LOVs) in the Shared Components section of our application. We use each LOV in place of a field in a form. We see how APEX will help us write the SQL for a LOV. The difference between a "display value"and a "return value"is discussed. Finally, we display the primary key field in a form, which APEX hides by default. See the primary key field in a form can be helpful during application development. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 37432 Jennifer Kreie
Stored procedure output parameters or return values   Part 20
 
16:45
In this video we will 1. Understand what are stored procedure return values 2. Difference between stored procedure return values and output parameters 3. When to use output parameters over return values Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedure-output-parameters-or.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-20-stored-procedure-output.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: 281068 kudvenkat
Oracle NVL2 Function
 
03:05
https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/ The Oracle NVL2 function is an extension of the NVL function and can be used to handle NULL values. It allows you to specify a value to check for NULL, a separate value to return if the value is NULL, and another value to return if the first value is not NULL. It’s very similar to NVL but allows for more flexibility. The syntax for NVL2 is: NVL2( value_to_check, value_if_not_null, value_if_null ) What are these parameters: Value_to_check is the value the function checks to see if it is NULL. Value_if_not_null is the value to return if the first value, value_to_check, is not NULL. Value_if_null is the value to return if the first value, value_to_check, is NULL. These parameters can have almost any data type (the second and third parameter can’t be a LONG data type). Oracle will determine the data type from the supplied parameters. There are quite a few of these conditional checking functions in Oracle, so the one to use would depend on your needs. But it’s good to know this function exists. For more information about the Oracle NVL2 function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/
Views: 276 Database Star
oracle mysql select max and return multiple values
 
06:25
Code and details: http://blog.softhints.com/oracle-mysql-select-max-and-return-multiple-values/ another example on max N per group http://blog.softhints.com/mysql-select-n-max-values-per-group/ Mysql group by column and return N max/min rows per group: * get max per group * get minimum per group * use additional constraints * return N per group --------------------------------------------------------------------------------------------------------------------------------------------------------------- If you really find this channel useful and enjoy the content, you're welcome to support me and this channel with a small donation via PayPal and Bitcoin. PayPal donation https://www.paypal.me/fantasyan Bitcoin: 1DBZu6N9JTpRDdc9QChLZnX3v2iVRaQ4ym Programming is a fun! :) Site: www.softhints.com Facebook: www.facebook.com/Softhints/ Twitter: www.twitter.com/SoftwareHints
Views: 31 Softhints
Oracle FROM_TZ Function
 
01:45
https://www.databasestar.com/oracle-timezone-functions/ The Oracle FROM_TZ function is used to convert a value in a TIMESTAMP data type, and a specific TIME ZONE, to a TIMESTAMP WITH TIME ZONE value. It’s a helpful conversion function if you work with times and time zones a lot. The syntax of the FROM_TZ function is: FROM_TZ ( timestamp_value, timezone_value ) The parameters of this function are: - timestamp_value: the value in a TIMESTAMP format to convert. - timezone_value: this is the timezone value that the timestamp_value will be converted in to. If you want to know what values can be used as a timezone value, you can look in the database view here: SELECT * FROM v$timezone_names; For more information about the Oracle FROM_TZ function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-timezone-functions/
Views: 69 Database Star
Oracle COVAR_SAMP Function
 
02:05
https://www.databasestar.com/oracle-variance-functions/ The Oracle COVAR_SAMP function calculates the covariance of a set of number pairs. If you know what a covariance is, then this function would be useful to you. I haven’t used it a lot though. This function is similar to the COVAR_POP and CORR functions, and it can also be used as an aggregate or analytic function. The syntax of the COVAR_SAMP function is: COVAR_SAMP ( expression1, expression2 ) If using it as an aggregate function, the parameters of the COVAR_SAMP function are: - expression1 (mandatory): The first set of numbers to use in the calculation. - expression2 (mandatory): The second set of numbers to use in the calculation. These parameters are numeric data types, and the return value is the same as the parameters. If you use COVAR_SAMP as an analytic function, the syntax is: COVAR_SAMP (expression1, expression2) OVER (analytic_clause) The analytic_clause is added here, which is common for analytic queries. For more information about the Oracle COVAR_SAMP function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-variance-functions/
Views: 20 Database Star
Oracle COVAR_POP Function
 
02:01
https://www.databasestar.com/oracle-variance-functions/ The Oracle COVAR_POP function calculates the “population covariance” of a set of number pairs. If you know what a population covariance is, then this function would be useful to you. This function is similar to the COVAR_SAMP and CORR functions. It can also be used as an aggregate or analytic function. The syntax of the COVAR_POP function is: COVAR_POP ( expression1, expression2 ) If using it as an aggregate function, the parameters of the COVAR_POP function are: - expression1 (mandatory): The first set of numbers to use in the calculation. - expression2 (mandatory): The second set of numbers to use in the calculation. These parameters are numeric data types, and the return value is the same as the parameters. If you use COVAR_POP as an analytic function, the syntax is: COVAR_POP (expression1, expression2) OVER (analytic_clause) The analytic_clause is added here, which is common for analytic queries. For more information about the Oracle COVAR_POP function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-variance-functions/
Views: 41 Database Star
Oracle LOWER Function
 
01:30
https://www.databasestar.com/oracle-upper-lower/ The Oracle LOWER function is used to convert a string to a lowercase value. It’s useful for comparing text or string values that may have mixed case, such as user input or data from different tables. The opposite of the LOWER function is the UPPER function (which converts to upper case). The syntax of LOWER is: LOWER(input_string) The input_string is the string value to convert to a lower case value. It can be any of CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The return type is the same as the input type. You can use the LOWER function in a WHERE clause. However, unless you have a function-based index on the column, any indexes won’t be used. For example, if you have an index on first_name, a query that uses “WHERE LOWER(first_name)” won’t use this index. You’ll have to create an index on the LOWER(first_name) for this to be used. It’s not required, but it’s just something to keep in mind. For more information about the Oracle LOWER function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-upper-lower/
Views: 51 Database Star
How to Parse XML in Oracle
 
13:54
This Video Shows 1. How to Read and parse XML in Oracle using EXTRACTVALUE and XMLTABLE. 2. When to use extractvalue and XMLTable. 3. Brief Introduction to XMLPATH
Views: 12359 yrrhelp
Oracle Forms 11g - Creating and Displaying an LOV
 
06:17
This tutorial takes you through the process of defining and calling an Oracle Forms List of Values (LOV). Full audio narration by Ed Honour.
Views: 32588 Edward Honour
How to "return more than one value" from any function.
 
07:51
This is the Concept of call by reference . According to this concept if there would be any change in formal arguments then the corresponding change will be reflected in Actual arguments . This video contain a program : To calculate and return area and rectangle from the function. Call by vale and call by reference :https://www.youtube.com/watch?v=b7g4KQs7DWk Concept of pointers : https://www.youtube.com/watch?v=VT3Z0JKprOU
Views: 3350 Prakash Sharma
LAST VALUE function in SQL Server
 
05:35
last_value function in sql server 2008 sql server last_value function returns incorrect data sql server last_value function example sql server last_value function with partition example LAST_VALUE function in SQL Server In this video we will discuss LAST_VALUE function in SQL Server. LAST_VALUE function Introduced in SQL Server 2012 Retrieves the last value from the specified column ORDER BY clause is required PARTITION BY clause is optional ROWS or RANGE clause is optional, but for it to work correctly you may have to explicitly specify a value Syntax : LAST_VALUE(Column_Name) OVER (ORDER BY Col1, Col2, ...) LAST_VALUE function not working as expected : In the following example, LAST_VALUE function does not return the name of the highest paid employee. This is because we have not specified an explicit value for ROWS or RANGE clause. As a result it is using it's default value RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary) AS LastValue FROM Employees LAST_VALUE function working as expected : In the following example, LAST_VALUE function returns the name of the highest paid employee as expected. Notice we have set an explicit value for ROWS or RANGE clause to ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING This tells the LAST_VALUE function that it's window starts at the first row and ends at the last row in the result set. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees LAST_VALUE function example with partitions : In the following example, LAST_VALUE function returns the name of the highest paid employee from the respective partition. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (PARTITION BY Gender ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server_9.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 Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 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: 33875 kudvenkat
Analytical Functions in oracle explained with real examples
 
25:24
This video explains analytical functions and how they are implemented in real projects. Analytical functions are somewhat similar to aggregate functions,but they offer much more. Why use analytical function ? They allow you to write fast and concise queries which otherwise will involve self join and long processing times They allow you to perform aggregate functions independently on sets of partitions. You can access values from previous rows in current row and you can restrict the window on which you want to apply this analytical function. I have given additional practice exercises along with the dataset so that you can comfortably work with analytical functions. You can find the sample problems along with dataset in the below link. http://www.internshipsfromhome.com/oracle-analytical-functions-ddl-and-dml/
Views: 20130 Tech Coach
Oracle INSTR Function
 
03:28
https://www.databasestar.com/oracle-instr/ The Oracle INSTR function allows you to search a string for the occurrence of another string, and return the position of the occurrence within a string. It’s helpful for finding if a string exists within another string. It can also be used for performing further string manipulation on, like substrings. The syntax of the INSTR function is: INSTR(string, substring [, start_position [, occurrence]]) These parameters are: string: The text string that is searched in. It’s usually the larger of the two strings. Mandatory. substring: The text to search for. It’s usually the smaller of the two strings. Mandatory. start_position: This is an integer value which indicates where in the string value to start the search. Optional, and the default is 1. occurrence: The occurrence of the substring to search for. Optional, and the default is 1, which means the first occurrence. Also, the searches performed by the INSTR function are case-sensitive. The value returned by INSTR is a number value, which is the number in the location of the string where the substring is found. The first character is 1. For more information about the Oracle INSTR function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-instr/
Views: 4913 Database Star
Function In Oracle PL SQL
 
07:49
Function In Oracle 1)A stored / user defined function is a set of PLSQL statements you can call by name. 2)Stored functions are very similar to procedures. 3)function always return a value. 4)User functions can be used as part of a SQL expression. Parameters to Function : a)IN Parameters b)OUT Parameters c)IN OUT Parameters Create Function : CREATE OR REPLACE FUNCTION FIND_AGE ( EMP_ID IN VARCHAR2 ) RETURN NUMBER IS EMP_AGE NUMBER; SQLSTRING VARCHAR2(4000); BEGIN SQLSTRING:=’SELECT AGE FROM EMPLOYEE WHERE EMP_ID=’||EMP_ID; EXECUTE IMMEDIATE SQLSTRING INTO EMP_AGE; RETURN EMP_AGE; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR(-20001,’Error in Find Age function – ‘||SQLCODE||’ -ERROR- ‘||SQLERRM); END; Call Function : SELECT FIND_AGE('1') FROM DUAL DROP FUNCTION : Syntax : DROP FUNCTION function_name; DROP FUNCTION FIND_AGE; #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 186 Tech Query Pond
PL/SQL Tutorial | COALESCE Function in Oracle Database
 
05:31
Learn fetching all non-null expression using oracle Coalesce function with example. If all expressions evaluate to null, then the COALESCE function will return null. Coalesce function in Oracle, What is coalesce function, When to use coalesce function, How to use coalesce function in oracle, How to fetch non-null values in oracle using coalesce, Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
How to find out Highest ,Second highest Third highest salary and Nth highest salary in SQL Server
 
07:25
A Chanel Where you can learn about Computer Information and Technology Like Asp.Net C#,Asp.Net MVC,SQL Server,Bootstrap,Oracle and more Website design. Website : http://www.dawacit.com Facebook : https://www.facebook.com/dawacit05 Twitter : https://twitter.com/dawacit How to send email in ASP.NET C# using Gmail smtp server step by step https://youtu.be/rnQphXehu7g How to send email with attachment in Asp.Net through Gmail smtp server,simple steps https://youtu.be/mhRe_we4hhA How to create Navigation bar in Asp.Net with CSS https://youtu.be/xVgtAdxhIxk How to create website using ASP.NET very attractive design https://youtu.be/uAKWaCl-vK4 How to create login and logout in Asp.Net MVC https://youtu.be/7E8IK_eAsWE
Views: 32984 Dawa CIT
0606 Functions That Returns Multiple Values
 
06:50
PHP is one of the leading technical web building education . Its very simple and easy to learn. Here we are showing 1 PHP Uses 2 PHP Installation 3 PHP Development 4 PHP using with PL/Sql 5 Pl/Sql Installation 6 Create and using Database using Oracle etc are shown in this video Thanks for watching
Views: 174 PHP 2015 Tutorial
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: 917948 kudvenkat
Return Value - Stored Procedure
 
05:41
Return Value. Microsoft SQL Server Online Training For Beginners With Advance Concepts https://sekhar.thinkific.com/courses/microsoft-sql-server-online-training-for-beginners Learn at Udemy https://www.udemy.com/microsoft-sql-server-training-for-beginners/?couponCode=ULSQLLEARN981 • Return value returns only integer value. • Also it is not possible; to return more than one value using return value. Create Procedure GetCustomersByCountryNameReturn @CountryName varchar(50) AS Begin Select * From Customers Where [email protected] return (Select count(CustomerId) From Customers Where [email protected]) The return will return the total customer’s count country wise. END Open a new query window. Declare @TotalCount int In order to get the return value exec @TotalCount=GetCustomersByCountryNameReturn 'India' Select @TotalCount
Views: 155 Way2Achieve
PART-2 (Oracle Functions) Oracle PL SQL Training - Fast Track Series
 
26:20
Topic 2: Functions in PL SQL. In oracle there are two types of functions available. 1. Oracle Supplied Function (Built in Functions) Scaler Functions a) String Functions Length, instr, substr, rtrim, ltrim, lower, upper, concat, replace sqlplus sanket/patel SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 14 11:38:56 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL# SQL# select length('sanket') from dual; LENGTH('SANKET') ---------------- 6 SQL# select instr('sanket','n') from dual; INSTR('SANKET','N') ------------------- 3 SQL# select substr('sanket',1,3) from dual; SUB --- san SQL# select ltrim(' sanket ') from dual; LTRIM('S -------- sanket SQL# select rtrim(' sanket ') from dual; RTRIM('S -------- sanket SQL# select trim(' sanket ') from dual; TRIM(' ------ sanket SQL# select lower('SanKet') from dual; LOWER( ------ sanket SQL# select upper('SanKet') from dual; UPPER( ------ SANKET SQL# select concat('sanket','patel') from dual; CONCAT('SAN ----------- sanketpatel SQL# SQL# select replace('patel','e','i') from dual; REPLA ----- patil SQL# b) Date Functions Sysdate, add_months, extract, last_day, next_day, months_between c) Numeric Functions Trunc, ceil, round d) Oracle Type Cast or Conversion Functions To_char, to_date, to_number e) Null functions Nvl, Nvl2 Aggregate Functions Count,min,max,sum 2. User Defined Functions (PL SQL) CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [function_name]; Characteristics of Functions • Function must returns some value • Function can be called from select statement • Function support all three types of parameters available in oracle like IN, OUT and IN OUT parameters. Types of Parameters: IN Parameter: We can’t overwrite value of such kind of parameters. It is used to pass reference values to program and utilized it within the programs or sub-programs or other standalone programs. OUT Parameter: We can overwrite value of such kind of parameters. It is not useful to pass reference values to program and utilized it within the programs or sub-programs or other standalone programs but output value must need to be hold by calling program. IN OUT Parameter: We can overwrite value as well as pass reference value to program or sub-programs or other standalone programs but output value must need to be hold by calling program. EXAMPLES: --FUNCTION WITH OUT PARAMETER CREATE OR REPLACE FUNCTION GET_DATE_HH24TIME RETURN VARCHAR2 IS HH24DATE_TIME VARCHAR2(20); BEGIN HH24DATE_TIME := TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS'); RETURN HH24DATE_TIME; END; / --FUNCTION WITH PARAMETER CREATE OR REPLACE FUNCTION GET_P_DATE_HH24TIME (P_HH24DATE_TIME IN DATE) RETURN VARCHAR2 IS HH24DATE_TIME VARCHAR2(20); BEGIN HH24DATE_TIME := TO_CHAR(P_HH24DATE_TIME,'DD/MM/YYYY HH24:MI:SS'); RETURN HH24DATE_TIME; END; / SELECT GET_P_DATE_HH24TIME(SYSDATE) FROM DUAL; Drop Functions: We can drop function from the database. DROP FUNCTION GET_P_DATE_HH24TIME; SQL# SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'FUNCTION'; OBJECT_NAME --------------------------------------------------------------------------GET_DATE_HH24TIME GET_P_DATE_HH24TIME DROP FUNCTION GET_DATE_HH24TIME;
Views: 4722 Sanket Patel
PL/SQL tutorial 6: Bind Variable in PL/SQL By Manish Sharma RebellionRider.com
 
07:56
Watch and learn what are bind variables in PL/SQL how to declare or create them using Variable command, Initialize them using Execute (exec)command and different ways of displaying current values of a bind variable for example using AutoPrint parameter. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/bind-variable Previous Tutorial ► Constants in PL/SQL https://youtu.be/r1ypg7WH4GY ►User Variables :https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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 ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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: 93342 Manish Sharma
Member Function with class type return value (Object) | C ++ Tutorial | Mr. Kishore
 
14:45
C ++ Tutorial Videos | Mr. Kishore ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Also Watch C Language Tutorials: https://goo.gl/qDhJ2r Core Java FAQ's: https://goo.gl/qGh5mA Core Java Tutorials: https://goo.gl/NbaEge Java Programming Tutorials by Mr.Hari krishna: https://goo.gl/HThq6H Advanced Java Programming Tutorials by Mr.Nataraj: https://goo.gl/1U2Qgy Subscribe to our channel and hit the bell 🔔🔔🔔 icon to get video updates. 💡 Visit Our Websites For Classroom Training: https://nareshit.in/cpp-training/ For Online Training: https://nareshit.com/c-online-training/ #JavaCollectionsFramework #Tutorials #Videos #corejava #Quiz #Clanguage -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 11780 Naresh i Technologies
Oracle tutorial : Using execution plan to optimize query in oracle
 
12:54
Oracle tutorial: Explain plan for query optimization in Oracle PLSQL oracle tutorial for beginners using execution plan to optimize query sql query analyzer sql query cost analysis https://techquerypond.wordpress.com This oracle tutorial show you how to use EXPLAIN PLAN in oracle. This video covers how to check cost of the query from DBMS_XPLAN.DISPLAY . You can find the cost of the query using the Using EXPLAIN PLAN FOR and based on the result you can optimize the query for faster performance. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://twitter.com/techquerypond
Views: 12140 Tech Query Pond
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: 173630 Joes2Pros SQL Trainings
Calling a stored procedure with output parameters   Part 7
 
20:13
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/10/calling-stored-procedure-with-output.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-7-calling-stored-procedure-with.html All ADO .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html All ADO .NET Slides http://csharp-video-tutorials.blogspot.com/p/adonet-slides.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 In this video, we will learn about calling a stored procedure with output parameters from an asp.net web application.
Views: 189630 kudvenkat
Lead and Lag functions in SQL Server 2012
 
07:27
In this video we will discuss about Lead and Lag functions. Lead and Lag functions Introduced in SQL Server 2012 Lead function is used to access subsequent row data along with current row data Lag function is used to access previous row data along with current row data ORDER BY clause is required PARTITION BY clause is optional Syntax LEAD(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) LAG(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) Offset - Number of rows to lead or lag. Default_Value - The default value to return if the number of rows to lead or lag goes beyond first row or last row in a table or partition. If default value is not specified NULL is returned. We will use the following Employees table for the examples in this video SQL Script to create the 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', 1000) Insert Into Employees Values (2, 'John', 'Male', 2000) Insert Into Employees Values (3, 'Pam', 'Female', 3000) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 5000) Insert Into Employees Values (6, 'Mary', 'Female', 6000) Insert Into Employees Values (7, 'Ben', 'Male', 7000) Insert Into Employees Values (8, 'Jodi', 'Female', 8000) Insert Into Employees Values (9, 'Tom', 'Male', 9000) Insert Into Employees Values (10, 'Ron', 'Male', 9500) Go Lead and Lag functions example WITHOUT partitions : This example Leads 2 rows and Lags 1 row from the current row. When you are on the first row, LEAD(Salary, 2, -1) allows you to move forward 2 rows and retrieve the salary from the 3rd row. When you are on the first row, LAG(Salary, 1, -1) allows us to move backward 1 row. Since there no rows beyond row 1, Lag function in this case returns the default value -1. When you are on the last row, LEAD(Salary, 2, -1) allows you to move forward 2 rows. Since there no rows beyond the last row 1, Lead function in this case returns the default value -1. When you are on the last row, LAG(Salary, 1, -1) allows us to move backward 1 row and retrieve the salary from the previous row. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (ORDER BY Salary) AS Lag_1 FROM Employees Lead and Lag functions example WITH partitions : Notice that in this example, Lead and Lag functions return default value if the number of rows to lead or lag goes beyond first row or last row in the partition. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lag_1 FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server_5.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: 50910 kudvenkat
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 44289 Jeff Smith
Pass by value and Pass by reference (Animated)
 
07:09
The Pass by reference method of passing arguments to a function copies the reference of an argument into the formal parameter. Inside the function, the reference is used to access the actual argument used in the call. This means that changes made to the parameter affect the passed argument. Pass by value means you are making a copy in memory of the actual parameter's value that is passed in, a copy of the contents of the actual parameter. Use pass by value when when you are only "using" the parameter for some computation, not changing it for the client program. Music: Cute Music by BENSOUND http://www.bensound.com/royalty-free-... Creative Commons — Attribution 3.0 Unported— CC BY 3.0 http://creativecommons.org/licenses/b... Music provided by Audio Library https://youtu.be/gnvwBNvVfuU Suggested Videos Inline Function :-https://www.youtube.com/watch?v=4dyvufOBbZ8 STATIC FUNCTIONS IN C++ :- https://www.youtube.com/watch?v=QERw8N_mOgU CONSTRUCTOR IN C++:-https://www.youtube.com/watch?v=zzLc7HVIRsQ STATIC VARIABLE OR STATIC DATA MEMBER IN C++ :-https://www.youtube.com/watch?v=0dSDJJzWqQI Constructor Overloading in C++- 32 :- https://www.youtube.com/watch?v=OcAJn7zUA5k FRIEND FUNCTION IN C++(THE CONCEPT):-https://youtu.be/BJLiUqvPy30 FRIEND FUNCTION VS REGULAR FUNCTION:-https://youtu.be/CO1RekmsBac FRIEND FUNCTION IN MULTIPLE CLASSES:-https://youtu.be/uwKCu2eSL2M INHERITANCE IN C++(THE CONCEPT):-https://youtu.be/5pJyKzON8Ww SINGLE INHERITANCE IN C++:-https://youtu.be/VmDUgxflYSQ ACCESS SPECIFIER IN C++:-https://youtu.be/F75zgvDKWI8 MULTILEVEL INHERITANCE:-https://youtu.be/t9I4Xmxa-3Q MULTIPLE INHERITANCE:-https://youtu.be/2DKRmhBmH7E HIERARCHICHAL INHERITANCE:-https://youtu.be/9ZpeeilvNQY HYBRID INHERITANCE:-https://youtu.be/1VdYat6Yqxs
Views: 40010 Codearchery
How to Use Value calculation ?
 
02:08
Developer:Md.Abdullah Al Mamun
Views: 838 Oracle Apex
SQL Distinct and Multiple Columns
 
02:52
Jamie King of Neumont University showing how SQL DISTINCT varies when multiple columns are present in the result set.
Views: 19529 Jamie King
[Hindi/Urdu] Part # 20 || Stored Procedure with Output Parameter or Return Value
 
16:11
Assalam-o-Alaikum Dosto..!!! Kaisy hein aap sub log...!!! Dosto is video mein hum ny bat ki in topics py. ▶ Difference between output parameters and return values. ▶ When to use output parameters and return values. ▶ Which is better output parameter or return value. ▶ Advantages and Disadvantages of output parameters and return values. To dosto aghar aap ny is video sy kuch sikha hy to lazmi mery channel ko subscribe karein or meri nayi any wali videos sy update rahein. nechy diyae gay links py click kr k mujhy follow karein. Youtube Channel: https://www.youtube.com/channel/UCctW... All Youtube Videos: https://www.youtube.com/channel/UCctW... Facebook Page: https://www.facebook.com/BeTechnical786/ Twitter Account: https://twitter.com/umer__ali
Views: 100 Be Technical
Rank and Dense Rank in SQL Server
 
10:08
rank and dense_rank example difference between rank and dense_rank with example rank vs dense_rank in sql server 2008 sql server difference between rank and dense_rank In this video we will discuss Rank and Dense_Rank functions in SQL Server Rank and Dense_Rank functions Introduced in SQL Server 2005 Returns a rank starting at 1 based on the ordering of rows imposed by the ORDER BY clause ORDER BY clause is required PARTITION BY clause is optional When the data is partitioned, rank is reset to 1 when the partition changes Difference between Rank and Dense_Rank functions Rank function skips ranking(s) if there is a tie where as Dense_Rank will not. For example : If you have 2 rows at rank 1 and you have 5 rows in total. RANK() returns - 1, 1, 3, 4, 5 DENSE_RANK returns - 1, 1, 2, 3, 4 Syntax : RANK() OVER (ORDER BY Col1, Col2, ...) DENSE_RANK() OVER (ORDER BY Col1, Col2, ...) RANK() and DENSE_RANK() functions without PARTITION BY clause : In this example, data is not partitioned, so RANK() function provides a consecutive numbering except when there is a tie. Rank 2 is skipped as there are 2 rows at rank 1. The third row gets rank 3. DENSE_RANK() on the other hand will not skip ranks if there is a tie. The first 2 rows get rank 1. Third row gets rank 2. SELECT Name, Salary, Gender, RANK() OVER (ORDER BY Salary DESC) AS [Rank], DENSE_RANK() OVER (ORDER BY Salary DESC) AS DenseRank FROM Employees RANK() and DENSE_RANK() functions with PARTITION BY clause : Notice when the partition changes from Female to Male Rank is reset to 1 SELECT Name, Salary, Gender, RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS [Rank], DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS DenseRank FROM Employees Use case for RANK and DENSE_RANK functions : Both these functions can be used to find Nth highest salary. However, which function to use depends on what you want to do when there is a tie. Let me explain with an example. If there are 2 employees with the FIRST highest salary, there are 2 different business cases 1. If your business case is, not to produce any result for the SECOND highest salary, then use RANK function 2. If your business case is to return the next Salary after the tied rows as the SECOND highest Salary, then use DENSE_RANK function Since we have 2 Employees with the FIRST highest salary. Rank() function will not return any rows for the SECOND highest Salary. WITH Result AS ( SELECT Salary, RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2 Though we have 2 Employees with the FIRST highest salary. Dense_Rank() function returns, the next Salary after the tied rows as the SECOND highest Salary WITH Result AS ( SELECT Salary, DENSE_RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2 You can also use RANK and DENSE_RANK functions to find the Nth highest Salary among Male or Female employee groups. The following query finds the 3rd highest salary amount paid among the Female employees group WITH Result AS ( SELECT Salary, Gender, DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS Salary_Rank FROM Employees ) SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 3 AND Gender = 'Female' Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server_1.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: 77066 kudvenkat
Get the Last Value in a Row - Excel Formula
 
09:37
In this video we look at how to get the last value in a row using a formula. In this example, the last value is the current weeks data. We always want to see the current week, even as time goes by and more weeks are added. This formula dynamically returns the last value in the row even as it expands An example is shown for a list of values, then it is taken further into a reporting scenario and running from a drop down list. Find more great free tutorials at; http://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► http://bit.ly/2klIl6H Excel Formulas Made Easy ► http://bit.ly/2t3netw The Complete Excel Course ► http://bit.ly/2HI7die Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1
Views: 2011 Computergaga
How to create Text or CSV File Dynamically from a Stored Procedure in SSIS Package-P180
 
30:34
SSIS Tutorial Scenario: How to create Text or CSV File Dynamically from a Stored Procedure in SSIS Package You are working as SQL Server Integration Services developer. You need to create an SSIS Package that should execute Stored Procedure and write the results to flat file. Every time the SSIS Package will run, it should create new flat file with date-time. This is simple requirement. You might think to use OLE DB Source and then use Flat file destination. But there is small problem. The definition of Stored Procedure can change anytime, that means the number of columns returned by Stored Procedure can change. You need to develop an SSIS Package in such a way that you don't have to reopen and remap the columns every-time the definition of Stored Procedure change. link to script used in the video http://www.techbrothersit.com/2016/04/how-to-create-text-or-csv-file_7.html Check out http://www.techbrothersit.com/ for free Technology Tutorials /Interview Questions SQL Server Integration Services(SSIS) Tutorial SQL Server Reporting Services (SSRS) Tutorial SQL Server / TSQL Tutorial SQL Server DBA Tutorial Team Foundation Server Microsoft Dynamics AX
Views: 8774 TechBrothersIT
SQL DISTINCT Within a SELECT - Retrieving Unique Values
 
03:41
Jamie King of Neumont University demonstrating use of DISTINCT within a SQL SELECT command.
Views: 23175 Jamie King
3  Oracle ADF - Creating LOVs and dependent LOVs
 
16:50
Creating LOV and dependent LOV for View Object attribute in Oracle ADF.
Views: 8109 Sushant Sharma
Oracle Quote to Cash Solution
 
02:43
Integrate your applications, automate processes, and gain immediate business value with Oracle's Quote to Cash Solution.
Views: 2853 OracleSupplyChain
JAVA - How To Search Values From MySQL Database And Set It Into JTextfield In Java NetBeans | + Code
 
07:14
JAVA - How To Search And Set Values From MySQL Database Into Textfield In Java NetBeans Source Code:http://1bestcsharp.blogspot.com/2015/02/java-how-to-search-and-set-values-from.html ------------------ Check out my Java Projects! -------------------- ▶ Inventory Management System - http://bit.ly/Java_Inventory ▶ Students Information System - http://bit.ly/JavaStudent_System ▶ Contacts Management System - http://bit.ly/Java_Contacts ▶ All My Programming Projects Here - http://bit.ly/2HrU8hK ▶ My Source Code Store Here - http://bit.ly/2OsC0TU -------------------------- JAVA COURSE ----------------------------- ▶ master Java core development step-by-step - http://bit.ly/2HXSuAn -------------------------------------------------------------------- java - How to display data from database into JTextfield visit our blog https://1bestcsharp.blogspot.com/ facebook: https://www.facebook.com/1BestCsharp twitter: https://www.twitter.com/1BestCsharp_ subscribe: http://goo.gl/nRjPKk *************************************************************************** *************************************************************************** C# And Java Programming Projects Source Code: http://1bestcsharp.blogspot.com/p/programming-projects.html *************************************************************************** *************************************************************************** in this java tutorial we will see how to get data into jtextfield in netbeans from mysql database we are gonna use: java programming language MySQL Database NetBeans Ide now to retrieve data from mysql database into jtextfield in netbeans we have firs to connect java to MySQL and to do this watch this video: https://www.youtube.com/watch?v=zM7oe2_S-jY and follow this java video thanks for watching this java tutorial where we Fetch data from database into Jtextfield in Netbeans for more java tutorials subscribe Java - How To Create Login Form With MySQL Database [with source code] Part 1 : https://www.youtube.com/watch?v=7sNYhlBz9xo Part 2 : https://www.youtube.com/watch?v=meGhTnlS9k4
Views: 88989 1BestCsharp blog
Part 2   SQL query to get organization hierarchy
 
10:14
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-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 286978 kudvenkat
Sql query to select all names that start with a given letter without like operator
 
03:02
Text Article http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that.html Slides http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that_31.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR 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 In this video we will discuss writing a SQL query to retrieve all student names that start with letter 'M' without using the LIKE operator. If the interviewer has not mentioned not to use LIKE operator, we would have written the query using the LIKE operator as shown below. SELECT * FROM Students WHERE Name LIKE 'M%' We can use any one of the following 3 SQL Server functions, to achieve exactly the same thing. CHARINDEX LEFT SUBSTRING The following 3 queries retrieve all student rows whose Name starts with letter 'M'. Notice none of the queries are using the LIKE operator. SELECT * FROM Students WHERE CHARINDEX('M',Name) = 1 SELECT * FROM Students WHERE LEFT(Name, 1) = 'M' SELECT * FROM Students WHERE SUBSTRING(Name, 1, 1) = 'M'
Views: 60325 kudvenkat
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: 194553 kudvenkat
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.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: 743543 kudvenkat
Unleash Business Value and Meet Supply Chain Challenges with Oracle SCM Cloud
 
02:21
Hear Simon D. Ellis, Program Vice President, IDC, speak about how Oracle SCM Cloud can help supply chain organizations to unlock business value. Landing Page: https://go.oracle.com/LP=71718?elqCampaignId=162579 Webcast: https://go.oracle.com/LP=72215?elqCampaignId=156783&src1=:se:lw:ie:pt:SEO100725843&evite=NAMK180515P00132:se:lw:ie:pt:SEO100725843
Views: 267 OracleSupplyChain