Home
Search results “Oracle function return error”
PL/SQL tutorial 38: Introduction to PL/SQL functions in Oracle Database
 
05:10
PL/SQL tutorial for beginners Introduction to PL/SQL functions in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-plsql-function Previous Tutorial ► Blocks in Oracle Database https://youtu.be/rbarR4_gaH8 ► ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 53402 Manish Sharma
5. Capture call stack, error code, error stack, error backtrace.
 
05:59
Ideally, this is a total non-issue for you, because you simply invoke a generic logger procedure in your exception handlers (example and recommendation: download and use Logger, an open source utility that does almost anything and everything you can think of). But if you are about to write your own (or are using a home-grown logging utility), make sure that you cal and store in your log (likely a relational table), the values returned by: SQLCODE DBMS_UTILITY.FORMAT_CALL_STACK (or corresponding subprograms in 12.1's UTL_CALL_STACK package) - answers question "How did I get here?" DBMS_UTILITY.FORMAT_ERROR_STACK (or corresponding subprograms in 12.1's UTL_CALL_STACK package) - answers question "What is my error message/stack?" We recommend using this instead of SQLERRM. DBMS_UTILITY.FORMAT_ERROR_BACKTRACE (or corresponding subprograms in 12.1's UTL_CALL_STACK package) - answers question "On what line was the error raised?" Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
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: 189 Tech Query Pond
PL/SQL: Mutating Triggers Part-1
 
06:24
In this tutorial, you'll learn... 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: 25330 radhikaravikumar
Oracle LISTAGG Function
 
04:57
https://www.databasestar.com/oracle-listagg/ The Oracle LISTAGG function allows you to aggregate or combine string values from multiple rows into a single row. For example, it turns this data: FIRST_NAME Adam Brad Carrie Into this data: FIRST_NAME Adam, Brad, Carrie The same data is shown, but it’s in one row and not multiple. It’s a valuable string manipulation function, and once you know what it is and how it works, you’ll be able to use it in your queries as needed. So what does it look like? The function is: LISTAGG ( measure_expr [, delimiter]) WITHIN GROUP (order_by_clause) [OVER query_partition_clause] These parameters are: measure_expr: This is a column or expression that you want to concatenate the values of. In the example above, it was the first_name column. Mandatory. delimiter: This is the character between each of the measure_expr values. Optional, the default is a comma. order_by_clause: This is the order that the values from the measure_expr are listed. Mandatory. query_partition_clause: This allows you to use LISTAGG as an analytic function, allowing you to show LISTAGG in groups for different rows. One thing to be aware of is that the output of the Oracle LISTAGG function is limited to 4,000 bytes. If you get more than this, you’ll receive an error. The most common way around this that I’ve seen is to write a custom function and use a CLOB. Watch the video to find out more and see some examples. For more information about the Oracle LISTAGG function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-listagg/
Views: 3354 Database Star
Oracle Database11g tutorials 11: SQL case manipulation function in Oracle Database
 
04:38
Part 2 SQL functions- character function -case manipulation functions Previous Video Link :: http://youtu.be/5rx8Q4x4-qI Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ------------------------------------------------------------------------------------- As discuss in last video we have 3 case manipulation functions. In case you miss the SQL functions intro video you can find the link in the description below. First let's see what these functions are. Upper (): This function takes a parameter converts it into uppercase and returns the new string. Initcap (): this function also takes parameter and converts the initial letter of or parameter into uppercase and returns the new string. Lower (): This function takes a parameter converts it into lowercase and returns the new string. Ok let's do some practical For this practical we will be using 2 tables First is dual table Which is a dummy table provided by oracle? And I have created another table again by the name of example. This will be our second table. Let's start with SQL function upper ( ); SELECT upper('hello world') FROM dual; As you can see I have used "hello world" completely in lowercase as parameter to SQL upper function. Execute it. Here, our result has given us a completely new hello world string which is in uppercase. Similarly you can also use SQL upper function to perform other DML Let's try This time we will work on our second table EXAMPLE; insert into example values (upper('manish')); first parentheses for values and second for SQL function upper. Let's check the result. As you can see here inserted value is in upper case. Lets compare it with simple insert query Insert into example values ('manish'); Execute it, i think now it's clear that when we perform simple insert DML the inserted value will be the same you provide. Similarly let's try SQL function initcap(); SELECT initcap('hello world') FROM dual; As you see here in result the initial letters of string hello world are in uppercase. Let's do the insert query insert into example values (initcap('hello world')); initial letters of string also are in uppercase. Let's try SQL function lower(); This time we have to write our hello world in all caps. SELECT lower('HELLO WORLD') FROM dual; Execute String totally in lower case. Similarly you can user SQL function lower in other DML like insert and all.
Views: 89518 Manish Sharma
Debugging Oracle PL/SQL code with ORACLE SQL DEVELOPER tool
 
15:04
Want to know how to debug procedures on Oracle sql developer 3.0? Well the you are at the correct place, we have worked out this simple tutorial to help you guys use this cool feature of debugging on Oracle sql developer tool. You can debug your procedures, functions, packages easly with the steps mentioned in the video.
Views: 8547 Kishan Mashru
Oracle Hints Tutorial for improving performance with examples
 
11:16
Oracle Hints Tutorial for improving performance with examples Oracle Hints Oracle Tutorial for beginners SQL Tutorial for beginners SQL Hints SQL Performance tuning
Views: 4704 TechLake
create function sql server ,Function scalar value,Speak Khmer
 
08:48
to get more video related Oracle,C#,VB.NEt, Crystal Report,Window server, LInux please happy to subscribe my channel SQL server have 2 functions: value table and scalar function. this method show how to create function return a value or scalar value with example. to visit all videos of SQL server visit : https://www.youtube.com/watch?v=hB23v5Gnv1A&list=PLTpb2Gk0K_lo89XR8BMVFskq7fj2wUTeJ
Views: 125 Sochan Van
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: 65959 baghul
Oracle : Stored Procedure with Input and Output Parameters
 
04:04
Java Source Code here: http://ramj2ee.blogspot.com/2015/07/oracle-stored-procedure-with-input-and.html Oracle : Stored Procedure with Input and Output Parameters JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 40372 Ram N
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 8763 Manish Sharma
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: 102005 Manish Sharma
CTS interview questions on Oracle SQL and PLSQL
 
06:45
Here are the CTS interview questions on SQL and PLSQL. PL/SQL: What are the activities are you doing daily in your project? Tell me ratio's of sql, pl/sql & Unix? Diff b/w primary key & unique key + not null? What is the use of views? If table dropped, then what happen view? What is index? types of indexes? Which functions are not supported to index? What is save point? What is ora-1555? What are the data types available in pl/sql, not in sql? What is the main use of %type,%rowtype? What is cursor? Types of cursors? Diff b/w explicit cursor & for loop cursor? What is exception? Types of exceptions? What is raise_application_error? How many LONG columns are allowed in a table? What cursor type do you use to retrieve multiple record sets? What is normalization ? What is an index and types of indexes. How many number of indexes can be used per table ? how can we find the select statement is indexed or not? What are wait events. Describe the wait event tables. How do u count no of rows in a table? When do we create bitmap indexes sql query to get zero records from a table having n no of records function can return multiple value? how give give sample coding Difference between NVL, NVL2 and NULLIF Name Salary Abc 50000 Abc 50000 xyz 20000, find the max salary using aggregate function? What are the Diff B/W Cursor and REF Cursor What is pragma_exception_init? Diff b/w triggers & procedures? Can you call procedure in select statement? Restrictions in functions? What is the use of packages? How to drop package body only? Can use pragma_autonamous_tranctions in packages? What is bulk collect? What is nullif()? What is mutating error?  What are the module's , you are working Which will fire default first statement level or row level trigger? What is bulk collect? And any restrictions in bulk collect? What is the use of limit clause in bulk collect? How to debug your code? How to trace error handling? How to find which line error was raised? What are the methods there in save exceptions? What is functional based index? Write syntax? In my next video i will be providing you the answers for each on of this questions. For HCL interview question : https://youtu.be/Pf0lRerwF5U For Global Analytics interview questions : https://youtu.be/joRTF8ZhVwg Please subscribe to my channel here for more videos on recent interview questions of MNC companies. https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ thanks to my subscribers !!
Views: 16010 Oracle PL/SQL
SQL tutorial 68: Union and Union All SQL Set Operator In Oracle Database By RebellionRider
 
05:23
Union and Union all Set operator in SQL/Oracle Database with example also the difference between union and union all. NExt tutorial will cover Intersect and minus set operator. Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog :http://bit.ly/union-union-all-set-operator-oracle ------------------------------------------------------------------------- ►►►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 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 27009 Manish Sharma
What is Hard-Coding in PL/SQL?
 
08:14
Practically Perfect PL/SQL with Steven Feuerstein See the first in a multi-video series that describes the nuances of hard-coding in PL/SQL. See the Practically Perfect PL/SQL YouTube channel for related videos. https://www.youtube.com/channel/UCpJpLMRm452kVcie3RpINPw 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.
Oracle NVL Function Explained with Examples
 
09:25
https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/ The Oracle NVL function allows you to check a value and return a different value if that value is NULL. It’s great for using another value if the first one is NULL or an optional value, for example people’s phone numbers. It’s also good alongside aggregate functions and grouping so you can see what the difference is between a subtotal row and an actual NULL value. The syntax of the Oracle NVL function is: NVL( check_value, replace_value ) The parameters are: - check_value (mandatory): This is the value that is displayed to the user. It is also the value that is checked for NULL. - replace_value (mandatory): This is the value that appears if the check_value is NULL. The function can use many different data types as parameters: string, date, or numeric. However, both parameters need to be the same type. For more information about the Oracle NVL 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: 719 Database Star
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: 294062 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: 49234 Jeff Smith
7. Compile-time warnings help avoid "WHEN OTHERS THEN NULL".
 
03:23
One of Tom Kyte's favorite pet peeves, the following exception sections "swallow up" errors. EXCEPTION WHEN OTHERS THEN NULL; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE (SQLERRM); In fact, any exception handler that does not re-raise the same exception or another, runs the risk of hiding errors from the calling subprogram, your users, and yourself as you debug your code. Generally, you should log the error, then re-raise it. There are certainly some cases in which this advice does not hold (for example: a function that fetches a single row for a primary key. If there is no row for the key, it's not an application error, so just return NULL). In those cases, include a comment so that the person maintaining your code in the distant future knows that you weren't simply ignoring the Wisdom of the Kyte. Example: EXCEPTION WHEN OTHERS THEN /* No company or this ID, let calling subprogram decide what to do */ RETURN NULL; One way to avoid this problem is to turn on compile-time warnings. Then when your program unit is compiled, you will be warned if the compiler has identified an exception handler that does not contain a RAISE statement or a call to RAISE_APPLICATION_ERROR. Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
SQL tutorial 51: DECODE function in Oracle Database By Manish Sharma (RebellionRider)
 
05:04
SQL Tutorial 51 Decode function in Oracle Database. ● What Is DECODE() ● DECODE ( ) vs CASE ● Syntax of DECODE() ● Query 1. String Matching using DECODE() ● Query 2. DECODE() comparing values form the COLUMN of the table Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] 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: 36459 Manish Sharma
Tutorial 42 - Creating Functions in PostgreSQL
 
12:41
Learn about Creating Functions in PostgreSQL
Views: 28300 Programming Guru
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: 36281 kudvenkat
Oracle PL/SQL - Procedures
 
10:41
Oracle PL/SQL - Procedures
Views: 134706 Chris Ostrowski
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 171341 BBarters
About that error: PLS-00306: wrong number or types of arguments
 
10:22
You want to call that subprogram. You NEED to call that subprogram. But you keep getting a compile error: "PLS-00306: wrong number or types of arguments". What is causing this? How do I fix it? In this video, Steven explores the PLS-00306 error and some of its nuances. After watching this, you should be well prepared to quickly resolve PLS-00306 the next time it attacks your code. ====================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
Essbase @RETURN Function
 
04:19
interRel presents Look Smarter Than You Are with Oracle Essbase BSO: @RETURN The Essbase Technical Reference documents the @RETURN function, but Oracle ACE Director Tracy McMullen demonstrates how to use the @RETURN function in a way that reading about it never could. If you've been looking for a more helpful and accurate version of the Essbase TechRef, here it is! To see more of our videos, go to http://epm.bi/videos
Views: 2460 interRel Consulting
Oracle Database Tutorial 70: IO ERROR: The network adapter could not establish the connection
 
03:34
IO ERROR: The network adapter could not establish the connection Learn how to solve this Oracle Database / SQL Developer Error with in 4 minutes ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-developer-error-the-network-adapter-could-not-establish-the-connection Previous Tutorial ► Intersect and Minus SQL set operators https://youtu.be/sDZFpwEw1k8 ------------------------------------------------------------------------- ►►►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 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 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: 168235 Manish Sharma
Single Row Subqueries (Introduction to Oracle SQL)
 
03:01
Explains what a single row subquery is and how it's used. This is a subquery that returns one row. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 1228 Database Star
PL/SQL tutorial 37: User Defined Record Datatype variable By Manish Sharma
 
05:39
Learn What are User Defined Record Datatype variable and How To Create User Defined Record Datatype variable in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/User-defined-record Previous Tutorial ►Anchored Datatype Variable: https://youtu.be/Zt0vlmTqhP4 ► ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 24203 Manish Sharma
Debugging PL/SQL with Oracle SQL Developer
 
02:37
Quick 2 minute video showing how to open a PL/SQL program in Oracle SQL Developer and debug it, line by line.
Views: 40980 Jeff Smith
Row Number function in SQL Server
 
07:24
sql server row_number example sql server row number by partition sql server row_number over partition by order by In this video we will discuss Row_Number function in SQL Server. This is continuation to Part 108. Please watch Part 108 from SQL Server tutorial before proceeding. Row_Number function Introduced in SQL Server 2005 Returns the sequential number of a row starting at 1 ORDER BY clause is required PARTITION BY clause is optional When the data is partitioned, row number is reset to 1 when the partition changes Syntax : ROW_NUMBER() OVER (ORDER BY Col1, Col2) Row_Number function without PARTITION BY : In this example, data is not partitioned, so ROW_NUMBER will provide a consecutive numbering for all the rows in the table based on the order of rows imposed by the ORDER BY clause. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (ORDER BY Gender) AS RowNumber FROM Employees Please note : If ORDER BY clause is not specified you will get the following error The function 'ROW_NUMBER' must have an OVER clause with ORDER BY Row_Number function with PARTITION BY : In this example, data is partitioned by Gender, so ROW_NUMBER will provide a consecutive numbering only for the rows with in a parttion. When the partition changes the row number is reset to 1. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (PARTITION BY Gender ORDER BY Gender) AS RowNumber FROM Employees Use case for Row_Number function : Deleting all duplicate rows except one from a sql server table. Discussed in detail in Part 4 of SQL Server Interview Questions and Answers video series. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server_30.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: 90205 kudvenkat
Tutorial 50 : User Defined Exception || RAISE_APPLICATIN_ERROR || SQLERRM
 
04:46
Hi Friends, Here we are learning about RAISE_APPLICATION_ERROR and SQLERRM. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (PL SQL Exception || User Defined Exception || Predefined Exception) : https://youtu.be/zPupDCGhS0U Link (Pre-Defined Exception's Example || too_many_rows || zero_divide || no_data_found) : https://youtu.be/M0481xJ3qqA Link (User Defined Exception Example || Exception Datatype) : https://youtu.be/UmMq1Zbp-Sg Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 75 YourSmartCode
Learn Oracle | Exception Handling in PL SQL
 
06:32
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 236 Pebbles Tutorials
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 117044 kudvenkat
CredSSP Encryption Oracle Remediation Error in Windows 10 (SOLVED)
 
03:15
Fix CredSSP Encryption Oracle Remediation Error In Windows 10: https://techempty.org/?p=708 Those of you who may have installed the security updates on Windows 10 workstations recently in the past few days may notice that you receive a strange error when trying to establish a remote desktop connection to a server that worked before like An Authentication error has occurred. The function requested is not supported. CredSSP Encryption Oracle Remediation Error after updating the Windows 10 computer. And here is the fix showing you on how to rectify CredSSP Encryption Oracle Remediation Error by following these two simple methods. Basically, the reason behind this error is, when you try to connect to the client whose Windows machine is outdated, you may get this CredSSP Encryption Oracle Remediation Error. When both the clients are up to date, then you won’t get any kind of error. Now let’s take a look at Windows 10 RDP CredSSP encryption oracle remediation error fix. The first one. Search for ‘Edit Group Policy’ and then open it. Now under the ‘Computer Configuration’, expand the ‘Administrative Tools’ then ‘System’ then ‘Credentials Delegation’ and here find ‘Encryption Oracle Remediation’. Right click on it then choose ‘Edit’ and now here Enable Encryption Oracle Remediation then change the protection level to ‘Vulnerable.’ Finally, Apply the changes then click on Ok. Here is how you can fix CredSSP Encryption Oracle Remediation Error In Windows 10. Second method is for the one who doesn’t have Group Policy editor or can’t find the Encryption Oracle Remediation within Group Policy editor. Search for ‘regedit’ to open the registry editor. Now expand ‘HKEY_LOCAL_MACHINE’ then ‘Software’ then ‘Microsoft’ then ‘Windows’ then ‘CurrentVersion’ then ‘Policies’ then ‘System’. Now you need to create a new key. So, right click on the System folder then choose ‘New Key’ and name it as CredSSP. Again create another ‘Key’ within CredSSP with the name ‘Parameters’. Inside the Parameters, you need to create a new DWORD value and name it as ‘AllowEncryptionOracle’. Finally change the DWORD value to 2 and Base to ‘Decimal.’ Save all the settings then try to connect to the RDP client. Subscribe to TechEmpty at https://www.youtube.com/user/techempty?sub_confirmation=1 **Stay Connected with Sai Praveen** Facebook: https://www.facebook.com/imsaipraveen Twitter: https://twitter.com/praveenhub Google Plus: https://plus.google.com/+techempty Website: https://techempty.org
Views: 57004 TechEmpty
FIX :ORA-01017: invalid username/password; logon denied
 
03:49
copy and paste - sqlplus "/as sysdba" COPY PASTE BELOW LINE ALTER USER user_name IDENTIFIED BY new_password; ** user_name - example SYSTEM new_password - ENTER NEW PASSWORD Blog - maheshkarandeprojects.wordpress.com MUSIC : You're free to use this song and monetize your video, but you must include the following in your video description: Essence by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ Keywords: ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied 12c,ora-01017 invalid username/password logon denied oracle 12c,ora-01017 invalid username/password logon denied sap,ora-01017 invalid username/password logon denied ora-02063 preceding line from,ora-01017 invalid username/password logon denied rman,ora-01017 invalid username/password logon denied oracle 10g,ora-01017 invalid username/password logon denied standby database,ora-01017 invalid username/password logon denied (dbd error ocisessionbegin),ora-01017 invalid username/password logon denied dblink,ora-01017 invalid username/password logon denied brtools,ora-01017 invalid username/password logon denied brconnect,ora-01017 invalid username/password logon denied brbackup,ora-01017 invalid username/password logon denied bi publisher,ora-01017 invalid username/password logon denied burleson,ora-01017 invalid username/password logon denied sap backup,br0301e ora-01017 invalid username/password logon denied,log by0= ora-01017 invalid username/password logon denied,sap brtools ora-01017 invalid username/password logon denied,dg broker ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied c#,ora-01017 invalid username/password logon denied change password,ora-01017 invalid username/password logon denied connection string,ora-01017 invalid username/password logon denied cloud control,ora-01017 invalid username/password logon denied config tool,ora-01017 invalid username/password logon denied the connect descriptor was,ora-01017 invalid username/password logon denied oracle client,ora 01017 invalid username password logon denied error code 1017,ora-01017 invalid username/password logon denied system copy,ora-01017 invalid username/password logon denied at oci call ocisessionbegin,ora-01017 invalid username/password logon denied dgmgrl,ora-01017 invalid username/password logon denied db13,ora-01017 invalid username/password logon denied during switchover,data guard ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied discoverer,ora-01017 invalid username/password logon denied dbca,ora-01017 invalid username/password logon denied dbsnmp,ora-01017 invalid username/password logon denied switchover data guard,ora 01017 invalid username password logon denied enterprise manager,ora-01017 invalid username/password logon denied external user,ora-01017 invalid username/password logon denied emca,ora-01017 invalid username/password logon denied expdp,ora-01017 invalid username/password logon denied error,ora-01017 invalid username/password logon denied expired,ora 01017 invalid username password logon denied identified externally,ora-01017 invalid username/password logon denied in eclipse,ora-01017 invalid username/password logon denied for sys user,ora-01017 invalid username/password logon denied for sys,ora-01017 invalid username/password logon denied forms,ora-01017 invalid username/password logon denied for dblink,ora 01017 invalid username password logon denied oracle forms,failed ora-01017 invalid username/password logon denied,test failed ora-01017 invalid username/password logon denied jdeveloper,authentication failed ora-01017 invalid username/password logon denied,brconnect failed ora-01017 invalid username/password logon denied,failure test failed ora 01017 invalid username password logon denied,ora-01017 invalid username/password logon denied data guard,error ora-01017 invalid username/password logon denied dataguard,glassfish ora-01017 invalid username/password logon denied,oracle data guard ora-01017 invalid username/password logon denied,data guard switchover ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied hibernate,ora-01017 invalid username/password logon denied hr,how to resolve ora-01017 invalid username/password logon denied,how to solve ora-01017 invalid username/password logon denied,ora-28001 the password has expired ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied in 12c,ora-01017 invalid username/password logon denied in sql developer,ora-01017 invalid username/password logon denied in sap,ora-01017 invalid
Views: 22687 Mahesh Karande
TRY CONVERT function in SQL Server 2012
 
07:46
try convert function in sql sql server try_convert try_convert in sql server 2012 try convert sql try_parse vs try_convert sql server In this video we will discuss TRY_CONVERT function Difference between CONVERT and TRY_CONVERT functions Difference between TRY_PARSE and TRY_CONVERT functions TRY_CONVERT function Introduced in SQL Server 2012 Converts a value to the specified data type Returns NULL if the provided value cannot be converted to the specified data type If you request a conversion that is explicitly not permitted, then TRY_CONVERT fails with an error Syntax : TRY_CONVERT ( data_type, value, [style] ) Style parameter is optional. The range of acceptable values is determined by the target data_type. For the list of all possible values for style parameter, please visit the following MSDN article https://msdn.microsoft.com/en-us/library/ms187928.aspx Example : Convert string to INT. As the string can be converted to INT, the result will be 99 as expected. SELECT TRY_CONVERT(INT, '99') AS Result Example : Convert string to INT. The string cannot be converted to INT, so TRY_CONVERT returns NULL SELECT TRY_CONVERT(INT, 'ABC') AS Result Example : Converting an integer to XML is not explicitly permitted. so in this case TRY_CONVERT fails with an error SELECT TRY_CONVERT(XML, 10) AS Result If you want to provide a meaningful error message instead of NULL when the conversion fails, you can do so using CASE statement or IIF function. Example : Using CASE statement to provide a meaningful error message when the conversion fails. SELECT CASE WHEN TRY_CONVERT(INT, 'ABC') IS NULL THEN 'Conversion Failed' ELSE 'Conversion Successful' END AS Result Output : As the conversion fails, you will now get a message 'Conversion Failed' instead of NULL Example : Using IIF function to provide a meaningful error message when the conversion fails. SELECT IIF(TRY_CONVERT(INT, 'ABC') IS NULL, 'Conversion Failed', 'Conversion Successful') AS Result What is the difference between CONVERT and TRY_CONVERT CONVERT will result in an error if the conversion fails, where as TRY_CONVERT will return NULL instead of an error. Since ABC cannot be converted to INT, CONVERT will return an error SELECT CONVERT(INT, 'ABC') AS Result Since ABC cannot be converted to INT, TRY_CONVERT will return NULL instead of an error SELECT TRY_CONVERT(INT, 'ABC') AS Result Example : Using TRY_CONVERT() function with table data. We will use the following Employees table for this example. SQL Script to create Employees table Create table Employees ( Id int primary key identity, Name nvarchar(10), Age nvarchar(10) ) Go Insert into Employees values ('Mark', '40') Insert into Employees values ('John', '20') Insert into Employees values ('Amy', 'THIRTY') Insert into Employees values ('Ben', '21') Insert into Employees values ('Sara', 'FIFTY') Insert into Employees values ('David', '25') Go The data type of Age column is nvarchar. So string values like (THIRTY, FIFTY ) are also stored. Now, we want to write a query to convert the values in Age column to int and return along with the Employee name. Notice TRY_CONVERT function returns NULL for the rows where age cannot be converted to INT. SELECT Name, TRY_CONVERT(INT, Age) AS Age FROM Employees If you use CONVERT instead of TRY_CONVERT, the query fails with an error. SELECT NAME, CONVERT(INT, Age) AS Age FROM Employees The above query returns the following error Conversion failed when converting the nvarchar value 'THIRTY' to data type int. Difference between TRY_PARSE and TRY_CONVERT functions TRY_PARSE can only be used for converting from string to date/time or number data types where as TRY_CONVERT can be used for any general type conversions. For example, you can use TRY_CONVERT to convert a string to XML data type, where as you can do the same using TRY_PARSE Converting a string to XML data type using TRY_CONVERT SELECT TRY_CONVERT(XML, '[root][child/][/root]') AS [XML] Converting a string to XML data type using TRY_PARSE SELECT TRY_PARSE('[root][child/][/root]' AS XML) AS [XML] The above query will result in the following error Invalid data type xml in function TRY_PARSE Another difference is TRY_PARSE relies on the presence of .the .NET Framework Common Language Runtime (CLR) where as TRY_CONVERT does not. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/tryconvert-function-in-sql-server-2012.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/tryconvert-function-in-sql-server-2012_16.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: 27985 kudvenkat
SQL Tutorial 12 Advanced Subqueries returning multiple columns
 
14:22
SQL Tutorial on Advanced Subqueries returning multiple columns Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 71592 Telusko
authentication login
 
35:04
custom authentication login in oracle apex 5.1 ----------------------------------------------------------------------------- create table companies( userid varchar2(50), password_ varchar2(50), company_name varchar2(120) not null, logo blob, constraint companies_pk primary key(userid,password_)); ------------------------------------------------- insert into companies(userid,password_,company_name) values ('wael','wael123','ibdis'); insert into companies(userid,password_,company_name) values ('ali','alil123','zaitoons'); ------------------------------ function my_authentication ( p_username in varchar2, p_password in varchar2 ) return boolean is l_user companies.userid%type := upper(p_username); l_pwd companies.password_%type; begin select userid , password_ into l_user, l_pwd from companies where upper(userid) = upper(l_user) and upper(password_)=upper(p_password); return true; exception when NO_DATA_FOUND then return false; end;
Views: 3183 Wael Albetar
DIFFERENCE BETWEEN PROCEDURE AND FUNCTION
 
06:33
Function must return a value but in Stored Procedure it is optional. Even a procedure can return zero or n values. Functions can have only input parameters for it whereas Procedures can have input or output parameters . Functions can be called from Procedure whereas Procedures cannot be called from a Function. 1. Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter. 2. Function can be called from SQL statements where as procedure can not be called from the sql statements 3. Functions are normally used for computations where as procedures are normally used for executing business logic. 4. You can have DML (insert,update, delete) statements in a function. But, you cannot call such a function in a SQL query. 5. Function returns 1 value only. Procedure can return multiple values (max 1024). 6.Stored Procedure: supports deferred name resolution. Example while writing a stored procedure that uses table named tabl1 and tabl2 etc..but actually not exists in database is allowed only in during creation but runtime throws error Function wont support deferred name resolution. 7.Stored procedure returns always integer value by default zero. where as function return type could be scalar or table or table values 8. Stored procedure is precompiled execution plan where as functions are not. 9.A procedure may modify an object where a function can only return a value The RETURN statement immediately completes the execution of a subprogram and returns control to the caller.
Views: 15 P T
Part 7   Using stored procedures with entity framework
 
12:09
Text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-7-using-stored-procedures-with.html Slides http://csharp-video-tutorials.blogspot.com/2014/05/part-7-using-stored-procedures-with_13.html Entity Framework - All Text Articles http://csharp-video-tutorials.blogspot.com/2014/05/entity-framework-tutorial.html Entity Framework - All Slides http://csharp-video-tutorials.blogspot.com/2014/05/entity-framework-tutorial-slides.html Entity Framework Playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhUPBSX-E2aJCnCR3-_6zBZx Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd In this video we will discuss using our own custom stored procedures to perform Insert, Update and Delete operations using entity framework. Step 1: Create and populate Employee table. Step 2: Create Insert, Update and Delete stored procedures Step 3: Create a new empty asp.net web application Step 4: Add a new ADO.NET Entity Data Model. a) On Choose Model Contents screen select "Generate from database" option and click Next b) On "Choose Your Data Connections" screen give a meaningful name for the connection string that will be stored in the web.config file. I have named it EmployeeDBContext. Click Next. c) On "Choose Your Database Objects" screen, select Employees Table and the 3 strored procedures (InsertEmployee, UpdateEmployee, DeleteEmployee). Provide a meaningful name for the Model namespace. I have named it EmployeeModel. CLick Finish. At this point on the ADO.NET Entity Model designer surface, we should be able to see the Employee entity but not the stored procedures. To view the stored procedures, 1. Right click on entity model designer surface and select "Model Broswer" from the context menu. 2. Expand Stored Procedures folder Step 5: Add a webform to the project. Drag and drop the following 3 controls and build the solution. 1. GridView 2. DetailsView 3. EntityDataSource Step 6: Configure EntityDataSource control a). Right click on EntityDataSource control and select "Show Smart Tag" option b) Click on Configure Data Source link c) Select EmployeeDBContext from the Named Connection dropdownlist and click Next d) Select the options on "Configure Data Selection" screen as shown in the video Step 7: Configure GridView control a). Right click on GridView control and select "Show Smart Tag" option b) Click on "Auto Format" link and select "Colourful" scheme c) Select "EntityDataSource1" from "Choose Data Source" dropdownlist d) Select Enable Editing and Enable Deleting checkboxes Step 8: Configure DetailsView control a) Right click on DetailsView control and select "Show Smart Tag" option b) Click on "Auto Format" link and select "Colourful" scheme c) Select "EntityDataSource1" from "Choose Data Source" dropdownlist d) Select Enable Inserting checkbox e) Set DeafultMode=Insert. Use properties window to set this. f) Set InsertVisible="false" for the ID BoundField. You can do this directly in the HTML Source. g) Generate ItemInserted event handler method for DetailsView control. Copy and paste the following code. protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e) { GridView1.DataBind(); } At this point if you run the application, and if you insert, update and delete employees, by default entity framework will use the sql it autogenerates and not our custom stored procedures. To tell the entity framework to use the stored procedures, we have to map them to the Employee entity. Here are the steps. 1. Right click on "Employee" entity on "EmployeeModel.edmx" and select "Stored Procedure Mapping" option from the context menu. 2. In the "Mapping Details" windows specify the Insert, Update and Delete stored procedures that you want to use with "Employee" entity At this point, 1. Run SQL Prrofiler 2. Run the application 3. Insert, Update and Delete Employee, and notice that the respective stored procedures are being called now.
Views: 142365 kudvenkat
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: 198067 kudvenkat
Oracle SQL Tutorial 9 - Intro to Queries
 
04:55
This video is for beginners who have never worked with SQL Developer, and we are going to teach how to begin writing queries. So the queries we are going to start with are queries when we give the database an expression and it will return back some kind of value. The most common keyword you are going to need to know for Oracle is SELECT. SELECT is the command we use to get data from the database. Even though we have not really put any data in our database, we can still use the SELECT statement to get data. That's because the database is capable of doing more than just creating tables and retrieving data from tables. So our first goal is to essentially write a Hello World, which just displays the text hello world to us. A good place to start is with: SELECT 'Hello World' This would actually work for many database management systems, but when you run it you will get an error. This actually doesn't work with Oracle, it will tell us we always need the FROM keyword. To get around this, there is a magical table called DUAL. We can put anything we want to SELECT and then say FROM DUAL and it will work. SELECT 'Hello World' FROM DUAL We can also do math: SELECT 1+1 FROM DUAL And we can run even run functions: SELECT SYSTIMESTAMP FROM DUAL To put all of this together, you can grab all of this data at the same time using commas to separate different columns from our generated table: SELECT 'Hello World', 1+1, SYSTIMESTAMP FROM DUAL Support me on Patreon: http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 32841 Caleb Curry
SQL CAST Function - how to use CAST Function
 
02:09
SQL CAST function converts an expression from one datatype to another datatype. visit Dose for excel Add-In website: http://www.zbrainsoft.com/ Visit our channel: https://www.youtube.com/channel/UCI4bMWYzrBTs47KINXL92Kw
Error 404 not found - The Requested URL was Not Found on This Server
 
02:55
This video shows "How to solve error 404 in Windows and other operating system". It also showing other information about Error 404. Error 404 is a normal error. It may occur when you are trying to access wrong URL. It may be possible that you that page you are accessing is moved to other URL or removed. Stay Connected: -------------------------- Facebook: https://www.facebook.com/trickstable/ Twitter: https://twitter.com/ketan7529 Google+: https://plus.google.com/u/0/106634414... Instagram: https://www.instagram.com/techketan/ Visit My site: http://www.trickstable.com
Views: 372796 KP Geek
SQL*Loader - Loading data with SQL *loader, Example of Loading MS-Access Data in Oracle
 
13:03
SQL*Loader - Loading data with SQL *loader, Example of Loading MS-Access Data in Oracle For Students of B.Tech, B.E, MCA, BCA, B.Sc., M.Sc., Courses - As Per IP University Syllabus and Other Engineering Courses
SQLAlchemy: Connecting to a database
 
03:10
Learn how to connect to your database: https://www.datacamp.com/courses/introduction-to-relational-databases-in-python In the python world, there are several great tools that we can use when working with databases. One of those is SQLAlchemy that we will be using throughout this course. SQLAlchemy will allow us to generate SQL queries by writing Python code. You should still consider learning how to write queries in SQL as well. SQLAlchemy has two main components. The part we will be focusing on is often referred to as "core" part of SQLAlchemy. It's really focused around the relational model of the database. Additionally, there is the Object Relational Model or ORM part of SQLAlchemy that is really focused around data models and classes that you as a programmer create. There are many different types of databases, and each database type has its own quirks and unique capabilities. You'll commonly find SQLite, PostgreSQL, MySQL, Microsoft SQL Server, and Oracle when working with data. SQLAlchemy provides a way to operate across all of these database types in a consistent manner. To connect to a database, we need a way to talk to it, and an engine provides that common interface. To create an engine, we import the create_engine function from sqlalchemy; we then use the create_engine function and supply it a connection string that provides the details needed to connect to a database. Finally once we have an engine, we are ready to make a connection using the connect method on the engine. It's worth noting that SQLAlchemy won't actually make the connection until we give it some work to execute. So to review, an engine is the common interface to the database, which requires a connection string to provide the details used to find and connect to the database. Before we go any further, let's talk a bit more about connection strings. In their simplest form, they tell us what kind of database we are talking to and how we should access it. In this example, you can see that we are using the sqlite database driver and the database file named census_nyc.sqlite which is in the current directory. Now that we have an engine and a connection, we need to know what tables are in the database. We'll start again by importing the create_engine function and creating an engine to our database. Finally, We can use the table_names method of the engine which returns a list of tables. Once we know what table we want to work on, we need a way to access that table with python. To do that we are going to use a handy process called reflection, which reads the database and builds a Table object that we can use in our code. We already have created our engine, so we begin by importing the MetaData and Table objects needed for reflection. The MetaData object is a catalog that stores database information such as tables so we don't have to keep looking them up. To reflect the table, we initialize a MetaData object. Next, we use the SQLAlchemy Table object and provide the table name we got earlier from the table_names method. We also supply our metadata instance, and then instruct it to autoload the table using the engine. Finally, we can use the function repr to view the details of our table that we stored as census. This allows us to see the names of the columns, such as 'state' and 'sex', along with their types, such as VARCHAR and INTEGER. This process of reflection may seem a bit of an overhead, but it will make understanding your databases and extracting information from them far easier downstream. Now it's your turn to practice writing connection strings, connecting to databases and reflecting tables. Then we'll be back here writing our first SQL queries.
Views: 41097 DataCamp