Home
Search results “Oracle sql ignore nulls”
SQL Null or Empty   How to Check for Null or Empty Column in SQL Server   SQL Training Online
 
03:41
http://www.sqltrainingonline.com SQL Null or Empty - How to Check for Null or Empty Column in SQL Server - SQL Training Online You can download the sample table script at http://www.sqltrainingonline.com/how-to-filter-for-sql-null-or-empty-string/. In this video, I show you how to filter for a SQL null or empty string. It can be difficult to filter a null because you can't simply compare with an equal sign. You have to use a special IS NULL clause to make the filter work. I also show you how to combine both the SQL Null and Empty String together in a special trick with the isnull SQL Server function. I use SQL Server 2012 to demonstrate the technique. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 18489 Joey Blue
Analytics: 18 Lag, Lead - Dealing with null
 
03:38
blog: https://connor-mcdonald.com Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at using our IGNORE NULLS extension for lag and lead to solve the "fill in the gaps" problem when rows are missing data. Scripts: https://livesql.oracle.com/apex/livesql/file/content_C0SXW1PG37G8REE0VTQH5LXJ8.html
Views: 320 Connor McDonald
ORACLE Analytic Functions for Data Warehousing 2/ Arabic
 
12:32
ORACLE Analytic Functions for Data Warehousing 2/ Arabic FIRST_VALUE last_VALUE row_number() --FIRST_VALUE and LAST_VALUE Analytic Functions select EMPLOYEE_ID, FIRST_NAME, HIRE_DATE from employees order by hire_date; select EMPLOYEE_ID, FIRST_NAME, HIRE_DATE , min(HIRE_DATE) over ( ) first_HIRE_DATE from employees select EMPLOYEE_ID, FIRST_NAME, HIRE_DATE , FIRST_VALUE(HIRE_DATE) over ( ) first_HIRE_DATE from employees order by hire_date; select EMPLOYEE_ID, FIRST_NAME, HIRE_DATE , max(HIRE_DATE ) over ( ) last_HIRE_DATE from employees select EMPLOYEE_ID, FIRST_NAME, HIRE_DATE , last_VALUE(HIRE_DATE ) over ( ) last_HIRE_DATE from employees order by HIRE_DATE drop table student_exam_result; CREATE TABLE student_exam_result (student_id number, exame_name varchar2(100), exame_try number, exame_results number ); insert into student_exam_result values(1,'calcluas',1,50); insert into student_exam_result values(1,'calcluas',2,66); insert into student_exam_result values(1,'calcluas',3,20); insert into student_exam_result values(2,'calcluas',1,66); insert into student_exam_result values(2,'calcluas',2,null); insert into student_exam_result values(2,'calcluas',3,7); insert into student_exam_result values(3,'calcluas',1,50); insert into student_exam_result values(3,'calcluas',2,98); insert into student_exam_result values(3,'calcluas',3,null); select * from student_exam_result select student_id, exame_name,exame_try,exame_results, last_value(exame_results) IGNORE NULLS over (PARTITION BY student_id, exame_name ) last_grade from student_exam_result order by student_id, exame_name, exame_try select student_id, exame_name,exame_try,exame_results, last_value(exame_results) IGNORE NULLS over (PARTITION BY student_id, exame_name ) last_grade, max(exame_results) over (PARTITION BY student_id, exame_name ) max_grade, avg(exame_results) over (PARTITION BY student_id, exame_name ) avg_grade from student_exam_result order by student_id, exame_name, exame_try ------------------------ select employee_id,first_name ,row_number() over(order by employee_id ) from employees select employee_id,first_name ,rownum from employees select employee_id,first_name ,department_id, row_number() over(partition by department_id order by employee_id ) from employees
Views: 701 khaled alkhudari
KISS series on Analytics: 18 Lag, Lead - Dealing with null
 
03:31
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at using our IGNORE NULLS extension for lag and lead to solve the "fill in the gaps" problem when rows are missing data. Scripts: https://livesql.oracle.com/apex/livesql/file/content_C0SXW1PG37G8REE0VTQH5LXJ8.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== 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.
Views: 556 Connor McDonald
Oracle SQL Tutorial 10 - Whitespace, Case Sensitivity, and Comments
 
07:48
SELECT "Hello World" FROM DUAL The first thing you should know about writing queries is that this SQL is not whitespace sensitive. That means we can space this out however we wish. The only requirement is that you do not separate keywords out with spaces. They must be as one entity. Another gotcha is that when you are inside of quotes, whitespace becomes very important. That means if inside of a string you put a character and then 10 spaces, every single one of those spaces is going to part of that string: SELECT "Hello World" FROM DUAL The next thing you should notice is the capitalization. When we type SQL, by convention we capitalize all keywords. I personally really like this because you can easily see the difference between keywords and words that we created or use. But obviously we could capitalize the letters in the quotes. Keep in mind that this is a convention, meaning you do not have to follow this. Oracle is also case insensitive in that SELECT and select both do the same thing. Strings, once again, care about casing. Take this, for example: SELECT 'true' FROM DUALWHERE 'Hello' = 'Hello' And compare the results to this: SELECT 'true' FROM DUALWHERE 'Hello' = 'hello' Only the first one outputs the value true. Once we get into creating database objects such as tables with columns, those are not case sensitive either. That means instead of selecting from DUAL, you can select from DuAl Finally, I shall introduce you to comments. Comments allow you to tell the database engine that you want it to ignore a certain part of your code and not execute it. This is helpful if you want to document your code. It is also useful if you want to have multiple SQL statements open in one tab, but don't want to hover over the one you want to execute. You can comment out the ones you are not using and uncomment them when you are done. Using – will comment out the rest of the line, Using /* */ will comment everything between. This can even be used over multiple lines. But now, let's move onto the important stuff… CREATING TABLES!!!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! 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: 17910 Caleb Curry
The WHERE Clause: Case Sensitivity and Collations
 
08:53
This video is part of LearnItFirst's Writing Queries for SQL Server (2005/2008/R2 Edition) course. More information on this video and course is available here: http://www.learnitfirst.com/Course160 In this video Scott will show you how to control collation and case sensitivity in your SQL statements using the COLLATE clause. Highlights from this video: - COLLATE - Override column-level collations - WHERE and ORDER BY - List all collations on server - Table valued function - Using COLLATE for case sensitivity and much more...
Views: 6009 LearnItFirst.com
Part 4   Delete duplicate rows in sql
 
03:26
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-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 349566 kudvenkat
Oracle Table Creation Inserting Records Null Values 1
 
13:31
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
How to Concatenate String Values with Integer values in SQL Server - TSQL Tutorial
 
10:23
How to Concatenate String and Integer Values in SQL Server ( + Sign vs CONCAT ) - TSQL Tutorial Working with Databases is fun. On daily basis we save data into tables in different columns and often we need to write queries which involve concatenation of multiple columns of different datatypes to produce our final output. In below example we have saved some data into #Customer Table which has Street Address column as string and zip as INT. we want to produce Full Address by concatenating these columns. To concatenate we can use + sign but this works only with String values. So if we have any Integer value/s we have to convert them to String first. We can use Cast or Convert function to convert Integer value to string. Also if there is any Null value among which values we are concatenating , our output will be Null by using + sign. To take care of that part we can use either ISNULL() or Coalesce Function to replace NULL with blank value in SQL Server. In SQL Server 2012 and Later versions, CONCAT function was introduced. You can concatenate multiple values by using this function. Fun part of this function is you don't have to worry about Null outcome as it will Ignore Null values and also you don't have to worry about converting INT into strings, It will take care of that automatically. So if you are using new versions such as 2012 or later, start taking advantage of this function. Blog post link for the video with script http://sqlage.blogspot.com/2015/03/how-to-concatenate-string-and-integer.html
Views: 15724 TechBrothersIT
LNNVL FUNCTION IN ORACLE SQL
 
09:11
This video is the 5th video in the series of 'working with null', this video explains the working of the lnnvl function in oracle sql with simple and easy to understand example. LNNVL provides a concise way to evaluate a condition when one or both operands of the condition may be null. The function can be used only in the WHERE clause of a query. It takes as an argument a condition and returns TRUE if the condition is FALSE or UNKNOWN and FALSE if the condition is TRUE. LNNVL can be used anywhere a scalar expression can appear, even in contexts where the IS [NOT] NULL, AND, or OR conditions are not valid but would otherwise be required to account for potential nulls. Oracle Database sometimes uses the LNNVL function internally in this way to rewrite NOT IN conditions as NOT EXISTS conditions. In such cases, output from EXPLAIN PLAN shows this operation in the plan table output. The condition can evaluate any scalar values but cannot be a compound condition containing AND, OR, or BETWEEN.
Views: 638 Kishan Mashru
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.
How to Resolve Oracle SQL Parent Key Not Found (ORA-02291)
 
05:49
In this video, we’ll explain what the ORA-02291 “parent key not found” error is, see an example, and look at how to resolve it. This error usually happens when we try to insert data into a table. It looks like this: Error is: ORA-02291: integrity constraint (constraint_name) violated - parent key not found So what does this error mean? It means we’re trying to insert data into a child table, and there is no related record in the parent table. If a foreign key has been set up to enforce this relationship, there needs to be a parent to insert a child that refers to it. Watch the video to see an example of this error as well as how to resolve it. For more information on Oracle SQL, refer to the Database Star website here: https://www.databasestar.com/
Views: 3574 Database Star
Removing Null From Prompt
 
03:46
How to Remove Null Values from Prompt drop down values
Views: 981 CK Singh
Video_017 How to Remove Null Columns with Power Query?
 
02:11
You may download the file example from this link: http://myexcelworld.ucoz.com/load/power_bi/video_017_how_to_remove_null_columns_with_power_query/19-1-0-110
Views: 2805 Aydin Aliyev
SQLite Insert or Ignore
 
04:11
This video shows how to use the "insert or ignore" SQL statement in SQLite in order to avoid error messages for duplicate keys. For more information on SQLite, see http://www.squidoo.com/sqlitehammer http://www.squidoo.com/sqliteprogramming http://www.squidoo.com/sqlitetutorial http://www.squidoo.com/sqlitedatabasedesign
Views: 4225 Jay Godse
How to avoid divide by zero - Introduction to NULLIF ?
 
04:56
Returns a null value if the two specified expressions are equal. watch full video for more detail.
Views: 2128 SqlIsEasy
Session6 Data type in Oracle
 
15:25
Session 6: Datatypes In Oracle   ALPHABET           : A-Z , a-z NUMBER              : 0-9 (with precision and scale) DATE / Temporal  : any Date and time (Hours, Minutes, Seconds, Mili-seconds, Timestamp, Timezone etc)   Alphabet + Number = Alphanumeric Data                                     = String / CHARACTER Datatype Category Number                    =  Numeric Datatype Category Date                         = Date Datatype Category 1. CHARACTER Datatype: CHAR, VARCHAR, NCHAR: CHAR is fixed length datatype and VARCHAR is Variable length datatype to store character data. i.e. A-Z , a-z , 0-9 , all keyboard characters etc. The default size is 1 character and it can store maximum up to 2000 bytes. Example : EName, EmpID, PassportNo, SSN, etc. EName CHAR(10) := ‘TOM’; wastage of 7 space after the string EName VARCHAR(10) := ‘TOM’; Spaces can be Reuse which left after the string NCHAR additionally handles NLS(National Language Support). Oracle supports a reliable Unicode datatype through NCHAR , NVARCHAR2 , and NCLOB  VARCHAR2, NVARCHAR2: These are Variable length datatype. VARCHAR2 handles alphanumeric character string whereas NVARCHAR2 handles alphanumeric character string with NLS(National Language Support). The default size is 1 character and it can store maximum up to 4000 bytes.   LONG:  Variable length string.  (Maximum size: 2 GB - 1) Only one LONG column is allowed per table. RAW:    Variable length binary string (Maximum size 2000 bytes) LONG RAW: Variable length binary string (Maximum size 2GB) 2. NUMERIC Datatype: NUMBER: It stores Numeric values and performs numeric calculations. NUMBER,   NUMBER(n),   NUMBER(p,s) It stores Numbers up to 38 digits of precision. SeqNo NUMBER;                     1, 123, 12345678 EmpID NUMBER(4);                 1, 123, 1234 Sal NUMBER(7,2);                     23456.78 , 123.45 — correction in video: Sal NUMBER(a7,2); which is wrong please ignore. 1234567 can be a type of NUMBER, NUMBER(7), NUMBER(7,0) It can store both integer and floating point numbers NUMERIC(p,s) FLOAT:   Ex:  EmpSal FLOAT;    FLOAT(7)       Decimal Points allowed DEC(p,s), DECIMAL(p,s) , REAL, DOUBLE PRECISION INTEGER:   Ex:  SSN INTEGER;       Decimal Points are not allowed INT, SMALLINT 3. DATE Datatype: DATE: It stores DATE(Date, Month, Year) and Time(Hour, Minute, Second, AM/PM) and performs calculations with such data. Default DATE format in Oracle is “DD-MON-YY” Based on "Gregorian calendar" where the date ranges from “JAN 1 4712 BC” to “DEC 31 9999 AD” doj DATE;    “18-MAR-2010 12:30:00 PM” TIMESTAMP:    It can store all parameters as DATE datatype and additionally it can have “Fraction of seconds” and TIMESTAMP WITH TIMEZONE / TIMESTAMP WITHOUT TIMEZONE. Range from 0-9 digits, the default size is 6. 4. LOB Datatype: LOB: “Large Object” data. It can store pictures, motion pictures, Textfiles etc. CLOB: “Character Large Object” is used to store structured information like a text file with a specific file format. BLOB: “Binary Large Object” is used to store Un-structured information like Image, JPEG files, MPEG files etc. BFILE: “Binary File” is used to store the pointer to a specific file / Just store the location of a file. Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB) Extra Information: NCLOB : It supports all the character set supported by CLOB and additionally it handles NLS(National Language Support ) Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB) ROWID and UROWID(optional size) Datatype: contains fixed length Binary data. BBBBBBB.RRRR.FFFFF combination of BLOCK-ROW-DATABASE FILE Physical and Logical ROWID Upcoming Session: Session 7: Populating Data into Tables(INSERT Statement): Inserting data into all columns of a table Inserting data into Required columns of a table Inserting NULL value into a table Inserting Special Values(USER / SYSDATE) into a table Supplying data at runtime(using & and &&) THANK YOU :)
Views: 228 Prabhat Sahu
Unique key constraint - Part 9
 
08:12
In this video we will learn 1. What is unique key constraint 2. When do you use unique key constraint over primary key constraint 3. Difference between unique key constraint and primary key constraint Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/unique-key-constraint-part-9.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-9-unique-key-constraint.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: 296938 kudvenkat
SSRS Tutorial 33 -Allow Null Value Parameter Option to Pass Null value From Parameter In SSRS Report
 
12:09
In this video of SSRS Tutorial, You will be learning How to SSRS Report with Single Value Parameter How to pass Null value to Parameter to get all Records with Null values for Main Query Why Allow Null Value is not working? How to write Query for Dataset to use Null values from SSRS Report Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 9381 TechBrothersIT
SSRS Tutorial 37 - Use Stored Procedure with Multi value Parameter in SSRS Report
 
18:30
In this video of SSRS Tutorial, You will be learning How to create Stored Procedure with Multi value parameter How to configure Multi value parameter in SSRS Report How to provide values to Parameter by using Query link to the post for Stored Procedure used in the demo Use Stored Procedure with Multi value Parameter in SSRS Report Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 25837 TechBrothersIT
Slime experiment!
 
07:09
Created and edited with #pocketvideo. Download the app here http://apple.co/1TE5iKV Thank you guys for watching! This was crazy! I hope you liked it! Also, don’t mind the made by PocketVideo nonsense, try to ignore it 🙄. It also says (null) if you know what it means please tell me in the comments below! But I hope you guys liked this video! Please be sure to like and subscribe and comment what I should do next, thx!(null)
Views: 29 Sophia Rudin
Aggregate Functions in SQL Server || AVG, COUNT, GROUPING functions in SQL
 
05:01
This video will provide you the details of each Aggregate functions in SQL Server 2014. I'll be walking through each and every kinds of build in function which are available in SQL Server in my next videos. ******************************************************************************** Aggregate Functions (Transact-SQL) Aggregate functions perform a calculation on a set of values and return a single value. Except for COUNT, aggregate functions ignore null values. Aggregate functions are frequently used with the GROUP BY clause of the SELECT statement. Aggregate functions can be used as expressions only in the following: • The select list of a SELECT statement (either a subquery or an outer query). • A HAVING clause. ******************************************************************************** AVG (Transact-SQL) Returns the average of the values in a group. Null values are ignored.  Syntax AVG ( [ ALL | DISTINCT ] expression ) OVER ( [ partition_by_clause ] order_by_clause )  Arguments ALL Applies the aggregate function to all values. ALL is the default. DISTINCT Specifies that AVG be performed only on each unique instance of a value, regardless of how many times the value occurs. expression Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type. Aggregate functions and subqueries are not permitted. OVER ( [ partition_by_clause ] order_by_clause) partition_by_clause divides the result set produced by the FROM clause into partitions to which the function is applied. If not specified, the function treats all rows of the query result set as a single group. order_by_clause determines the logical order in which the operation is performed.order_by_clause is required.  Return Types The return type is determined by the type of the evaluated result of expression. Expression result Return type tinyint int smallint int int int bigint bigint decimal category (p, s) decimal(38, s) divided by decimal(10, 0) money and smallmoney category money float and real category float ******************************************************************************** COUNT (Transact-SQL) Returns the number of items in a group. COUNT works like the COUNT_BIG function. The only difference between the two functions is their return values. COUNT always returns an int data type value. COUNT_BIG always returns a bigint data type value.  Syntax -- Syntax for SQL Server and Azure SQL Database COUNT ( { [ [ ALL | DISTINCT ] expression ] | * } ) [ OVER ( [ partition_by_clause ] [ order_by_clause ] [ ROW_or_RANGE_clause ] ) ]  Arguments ALL Applies the aggregate function to all values. ALL is the default. DISTINCT Specifies that COUNT returns the number of unique nonnull values. expression Is an expression of any type except text, image, or ntext. Aggregate functions and subqueries are not permitted. * Specifies that all rows should be counted to return the total number of rows in a table. COUNT(*) takes no parameters and cannot be used with DISTINCT. COUNT(*) does not require an expression parameter because, by definition, it does not use information about any particular column. COUNT(*) returns the number of rows in a specified table without getting rid of duplicates. It counts each row separately. This includes rows that contain null values. OVER ( [ partition_by_clause ] [ order_by_clause ] [ ROW_or_RANGE_clause ] ) partition_by_clause divides the result set produced by the FROM clause into partitions to which the function is applied. If not specified, the function treats all rows of the query result set as a single group. order_by_clause determines the logical order in which the operation is performed.  Return Types int ******************************************************************************** GROUPING (Transact-SQL) Indicates whether a specified column expression in a GROUP BY list is aggregated or not. GROUPING returns 1 for aggregated or 0 for not aggregated in the result set. GROUPING can be used only in the SELECT list, HAVING, and ORDER BY clauses when GROUP BY is specified.  Syntax GROUPING ( column_expression)  Arguments Is a column or an expression that contains a column in a GROUP BY clause.  Return Types tinyint
Views: 158 Softtech forum
Основы индексирования и расширенные возможности EXPLAIN в MySQL / Василий Лукьянчиков (Станигост)
 
47:25
РИТ++ 2015, HighLoad++ Junior Презентация и тезисы: http://junior.highload.ru/2015/ Индексы - типы индексов; - типы доступа к таблице; - составные индексы (когда они работают); - получение информации об индексе (show index; - описание формата); - примеры с поиском по нескольким полям и сортировкой: какие индексы будут использоваться, а какие нет; - что делать в случае нескольких условий по диапазону; - как сервер выбирает индекс, который будет использован; - директивы use/force/ignore index. .
Views: 613 HighLoad Channel
Unique and Non Unique Indexes in sql server   Part 37
 
11:02
In this video we will learn about 1. What is a Unique Index 2. Difference between unique index and unique constraint Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/unique-and-non-unique-indexes-part-37.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-37-unique-non-unique-indexes.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: 214555 kudvenkat
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Lesson - 69 : Hibernate - Mapping declaration(XML Tags)
 
43:29
Hibernate - Mapping declaration(XML Tags) : Doctype : All XML mappings should declare the doctype shown. The actual DTD can be found at the URL above, in the directory hibernate-x.x.x/src/org/hibernate , or in hibernate3.jar. Hibernate will always look for the DTD in its classpath first. If you experience lookups of the DTD using an Internet connection, check the DTD declaration against the contents of your classpath. <hibernate-mapping> : <hibernate-mapping schema="schemaName" catalog="catalogName" default-cascade="cascade_style" default-access="field|property|ClassName" default-lazy="true|false" auto-import="true|false" package="package.name" /> <class> : <class name="ClassName" table="tableName" discriminator-value="discriminator_value" mutable="true|false" schema="owner" catalog="catalog" proxy="ProxyInterface" dynamic-update="true|false" dynamic-insert="true|false" select-before-update="true|false" polymorphism="implicit|explicit" where="arbitrary sql where condition" persister="PersisterClass" batch-size="N" optimistic-lock="none|version|dirty|all" lazy="true|false" entity-name="EntityName" check="arbitrary sql check condition" rowid="rowid" subselect="SQL expression" abstract="true|false" node="element-name" /> <id> : <id name="propertyName" type="typename" column="column_name" unsaved-value="null|any|none|undefined|id_value" access="field|property|ClassName"> node="element-name|@attribute-name|element/@attribute|." <generator class="generatorClass"/> </id> <generator> : <generator class="org.hibernate.id.TableHiLoGenerator"> <param name="table">uid_table</param> <param name="column">next_hi_value_column</param> </generator> <composite-id> : <composite-id name="propertyName" class="ClassName" mapped="true|false" access="field|property|ClassName"> <key-property name="propertyName" type="typename" column="column_name"/> <key-many-to-one name="propertyName class="ClassName" column="column_name"/> ...... </composite-id> <discriminator> : <discriminator column="discriminator_column" type="discriminator_type" force="true|false" insert="true|false" formula="arbitrary sql expression" /> <version> : <version column="version_column" name="propertyName" type="typename" access="field|property|ClassName" unsaved-value="null|negative|undefined" generated="never|always" insert="true|false" node="element-name|@attribute-name|element/@attribute|." /> <timestamp> : <timestamp column="timestamp_column" name="propertyName" access="field|property|ClassName" unsaved-value="null|undefined" source="vm|db" generated="never|always" node="element-name|@attribute-name|element/@attribute|." /> <property> : <property name="propertyName“ column="column_name" type="typename" update="true|false" insert="true|false" formula="arbitrary SQL expression" access="field|property|ClassName" lazy="true|false" unique="true|false" not-null="true|false" optimistic-lock="true|false" generated="never|insert|always" node="element-name|@attribute-name|element/@attribute|." index="index_name" unique_key="unique_id" length="L" precision="P" scale="S" /> <many-to-one> : <many-to-one name="propertyName" column="column_name" class="ClassName" cascade="cascade_style "fetch="join|select" update="true|false" insert="true|false" property-ref="propertyNameFromAssociatedClass" access="field|property|ClassName" unique="true|false" not-null="true|false" optimistic-lock="true|false" lazy="proxy|no-proxy|false" not-found="ignore|exception" entity-name="EntityName" formula="arbitrary SQL expression" node="element-name|@attribute-name|element/@attribute|." embed-xml="true|false" index="index_name" unique_key="unique_key_id" foreign-key="foreign_key_name" /> <one-to-one> : <one-to-one name="propertyName" class="ClassName" cascade="cascade_style" constrained="true|false" fetch="join|select" property-ref="propertyNameFromAssociatedClass" access="field|property|ClassName" formula="any SQL expression" lazy="proxy|no-proxy|false" entity-name="EntityName" node="element-name|@attribute-name|element/@attribute|." embed-xml="true|false" foreign-key="foreign_key_name"/> <natural-id> : <natural-id mutable="true|false"/> <property ... /> <many-to-one ... /> ...... </natural-id> <component> : <component name="propertyName" class="className" insert="true|false" update="true|false" access="field|property|ClassName" lazy="true|false" optimistic-lock="true|false" unique="true|false" node="element-name|." > <property ...../> <many-to-one .... /> </component> <properties> : <properties name="logicalName" insert="true|false" update="true|false" optimistic-lock="true|false" unique="true|false"> <property ...../> <many-to-one .... /> </properties> Hibernate Examples Project Github Link : https://github.com/SadaLearningHub1/Hibernate-Projects
Views: 52 Sada Learning Hub
SSRS - Multivalue Parameter Report
 
08:15
Multi - Value Parameter Report, ssrs multiple parameters ssrs multi value parameter join ssrs multi value parameter stored procedure ssrs multi value parameter expression ssrs parameter multiple values default select all ssrs multiple parameters not working how to pass multiple values in a single parameter sql ssrs display multi value parameter in textbox
Views: 4254 Mukesh Singh
mysql tutorial for beginners (6/8) : Indexes
 
05:48
mysql tutorial for beginners (6/8) : Indexes As things stand, the table students works and can be searched without problem by MySQL—until it grows to more than a couple of hundred rows, At that point, database accesses will get slower and slower with every new row added, because MySQL has to search through every row whenever a query is issued. This is like searching through every book in a library whenever you need to look something up. Of course, you don’t have to search libraries that way, because they have either a card index system or, most likely, a database of their own. The way to achieve fast searches is to add an index, either when creating a table or at any time afterward. But the decision is not so simple. For example, there are different index types such as a regular INDEX, PRIMARY KEY, and FULLTEXT. Also, you must decide which columns require an index, a judgment that requires you to predict whether you will be searching any of the data in that column. And even when you’ve decided that, you still have the option of reducing index size by limiting the amount of each column to be indexed. If we imagine the searches that may be made on the students table, it becomes apparent that all of the columns may need to be searched. Anyway, go ahead and add an index to each of the columns, using the commands: ALTER TABLE students ADD INDEX(name(3)); An alternative to using ALTER TABLE to add an index is to use the CREATE INDEX command. They are equivalent, except that CREATE INDEX cannot be used for creating a PRIMARY KEY CREATE INDEX surname ON students (surname(5)); DESCRIBE students; These commands create indexes on both the name and surname columns, limiting name index to only the first 3 characters, and surname index to the first 5 characters. For instance, when MySQL indexes the following name: SAFAA It will actually store in the index only the first 3 characters: SAF This is done to minimize the size of the index, and to optimize database access speed. DESCRIBE command shows the key MUL for each column. This key means that multiple occurrences of a value may occur within that column, which is exactly what we want, as name or surname may appear many times. You don’t have to wait, until after creating a table to add indexes. In fact, doing so can be time-consuming, as adding an index to a large table can take a very long time. Therefore, let’s look at a command that creates the table students with indexes already in place. CREATE TABLE students ( Id_studnet SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(10) NOT NULL, surname VARCHAR(20) NOT NULL, email VARCHAR(30) NOT NULL, INDEX(name(3)), INDEX(surname(5)), ,PRIMARY KEY(id_studnet),UNIQUE(email)); Another important index, PK, its single unique key for each student to enable instant accessing of a row. The importance of having a key with a unique value for each row will come up when we start to combine data from different tables. You can add PK, while you create the table at the first time, or later by issuing the following command: ALTER TABLE students ADD PRIMARY KEY(id_student); The last important index, FULLTEXT index Unlike a regular index, MySQL’s FULLTEXT allows super-fast searches of entire columns of text. It stores every word in every data string in a special index that you can search using “natural language,” in a similar manner to using a search engine. It’s not strictly true that MySQL stores all the words in a FULLTEXT index, because it has a built-in list of more than 500 words that it chooses to ignore because they are so common that they aren’t very helpful for searching anyway. This list, called stopwords, includes the, as, is, of, and so on. The list helps MySQL run much more quickly when performing a FULLTEXT search and keeps database sizes down. FULLTEXT indexes can be created for CHAR, VARCHAR, and TEXT columns only. A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE (or CREATE INDEX). Adding a FULLTEXT index to the table students for the columns name and surname ALTER TABLE classics ADD FULLTEXT(name,surname); this index is in addition to the ones already created and does not affect them You can now perform FULLTEXT searches across this pair of columns. If you find that MySQL is running slower than you think it should be when accessing your database, the problem is usually related to your indexes. Either you don’t have an index where you need one, or the indexes are not optimally designed. Tweaking a table’s indexes will often solve such a problem. In the next tutorial, we will learn about, using FOREIGN KEY Constraints and how to join tables together. Subscribe for more: ---------------------------------------------------------------------------- https://www.youtube.com/subscription_center?add_user=saf3al2a SWE.Safaa Al-Hayali - saf3al2a
Views: 29268 Safaa Al-Hayali
SSRS Interview-How to write TSQL Query/Stored Procedure with Single Value Parameter in SSRS Report
 
07:22
Parameters are used to filter the data in report. Single value parameter is parameter which can accept only one value at a time. To create your report with single value parameter , in Where clause you will be using "=" sign and Parameter name. Let's say we want to create RegionName Parameter, we can write query as below SELECT Col1Name ,Col2Name ,Col3Name FROM dbo.TABLE WHERE Region = @RegionName Let's say if you would like to create two single value parameters RegionName and CountryName in your report SELECT Col1Name ,Col2Name ,Col3Name FROM dbo.MyTableName WHERE Region = @RegionName AND Country = @CountryName You can also use the Stored Procedure for your report with Single value parameter/s. The where clause will be using "=" and then Parameter name as shown below. In below Stored Procedure we are only using @Region Parameter. You can create Stored Procedure with Multiple Single Value parameters if required by adding conditions in Where clause as we did in above query for Region and Country. Create procedure dbo.sp_SalesTotal @Region VARCHAR(100) AS BEGIN Select [SalePersonFName] ,[SalePersonLName] ,[ProductName] ,[ItemsSold] ,[SoldPrice] ,[SoldDate] ,[City] ,[State] ,[Country] ,[Region] from dbo.TotalSale where [email protected] END Check out our website for Different Technology tutorials and interview questions http://www.techbrothersit.com/
Views: 3873 TechBrothersIT
Difference between UNION and UNION ALL in SQL Server
 
03:03
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg This operation combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union and will ignore any duplicates that exist. Union all also does the same thing but include even the duplicate values.
Views: 77 IT Port
9. Sending an Email through Eclipse || Adempiere
 
13:37
Sending an Email through Adempiere: 1. Eclipse - New configuration - Adempiere 2. Eclipse - Modifying the hook for Mmommy (code shown below) 2. Eclipse - Alter Mmommy code, save, utils_dev, run ant build. 3. Eclipse - Run configurations - run Adempiere model 4. Adempiere - Create new user 5. Adempiere - In Minutes of Meeting, change something in the agenda. Save - email should have sent. Special thanks to Kevin Baltazar, Jordan Stevens, Caleb Unger, Seth Marselus, Emily Wade, and Ashley Russell for your resources and support! Helpful Videos Calebseth ENGI360 || https://www.youtube.com/watch?v=fhGVUGv-pU0 Jsteves448 || https://www.youtube.com/watch?v=Xrk0pvMd6R4 Code for Mmommy.java: package org.compiere.model; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Properties; import java.util.logging.Level; import org.compiere.util.DB; import org.compiere.util.EMail; //extend the generated x_c_mommy model public class Mmommy extends X_c_mommy { public Mmommy(Properties ctx, int c_mommy_ID, String trxName) { super(ctx, c_mommy_ID, trxName); } protected boolean afterSave(boolean newRecord, boolean success) { String mommyId = String.valueOf(this.getc_mommy_ID()); int m_c_mommy_ID = Integer.valueOf(mommyId); log.info("c_mommy_ID=" + m_c_mommy_ID); System.out.println(" (1) c_mommy_ID=" + m_c_mommy_ID); // Client Info MClient m_client = MClient.get (getCtx()); System.out.println(" (2) m_client i.e. 11" + m_client); if (m_client.getAD_Client_ID() == 0){ System.out.println(" (3) m_client i.e. 11" + m_client.getAD_Client_ID()); return false; } if (m_client.getSMTPHost() == null || m_client.getSMTPHost().length() == 0){ System.out.println(" (4) m_client SMTP: " + m_client.getSMTPHost()); return false; } //send mail to the participants send2Participants(m_client, m_c_mommy_ID); return success; } private void send2Participants(MClient m_client, int m_c_mommy_ID) { System.out.println(" (5) here is my m_c_mommy_id" + m_c_mommy_ID); log.info("C_Mommy_ID=" + m_c_mommy_ID); String sql = "SELECT a.ad_user_id " + "FROM adempiere.c_mommy_participantsline a " + "WHERE a.c_mommy_id=?"; PreparedStatement pstmt = null; try { System.out.println(" (6) here is SQL" + sql); //get the participants pstmt = DB.prepareStatement(sql, get_TrxName()); System.out.println(" (7) prep DD" + pstmt); pstmt.setInt(1, m_c_mommy_ID); System.out.println(" (8) Set Int" + m_c_mommy_ID); ResultSet rs = pstmt.executeQuery(); System.out.println(" (9) Result set" + rs); while (rs.next()) //for each participant { //send mail to the participant Boolean ok = sendIndividualMail (m_client, m_c_mommy_ID, rs.getInt(1)); if (ok == null) ; } rs.close(); pstmt.close(); pstmt = null; } catch (SQLException ex) { log.log(Level.SEVERE, sql, ex); } try { if (pstmt != null) pstmt.close(); } catch (SQLException ex1) { } pstmt = null; } //Method to send mail to a user private Boolean sendIndividualMail (MClient m_client, int m_c_mommy_ID, int AD_User_ID){ MUser to = new MUser (getCtx(), AD_User_ID, null); Mmommy m_mommy = new Mmommy(getCtx(), m_c_mommy_ID, get_TrxName()); MUser m_from = new MUser (getCtx(), m_mommy.getAD_User_id(), get_TrxName()); String message = "Greetings " + to.getName() + ",\n\n" + m_mommy.getName() + " has been updated in the system! Following is the agenda mentioned:\n\n" + m_mommy.getagenda() + "\n\nAll the best,\nNick & Gloria"; String subject = "AfterSave : " + m_mommy.getName(); //call createMail method available in MClient object EMail email = m_client.createEMail(m_from, to, subject, message); System.out.println(" (10) TESTING TO: "+to+"FROM:"+m_from+"SUBJECT"+subject+"M­ESSAGE"+message); //email.setSubject (subject); email.setSubject ("Minutes of Meeting: Update"); email.setMessageText (message); if (!email.isValid() && !email.isValid(true)) { log.warning("NOT VALID - " + email); to.setIsActive(false); to.addDescription("Invalid EMail"); to.save(); return Boolean.FALSE; } //send mail boolean OK = EMail.SENT_OK.equals(email.send()); if (OK) log.fine(to.getEMail()); else log.warning("FAILURE - " + to.getEMail()); return new Boolean(OK); } private int getAD_User_id(){ int user_id = 101; return user_id; } } Creating Adempiere java application: Main: Project - adempiere_360 Main class - org.compiere.Adempiere Arguments: No program arguments VM arguments: -DPropertyFile="C:\Adempiere\Adempiere.properties" -DADEMPIERE_HOME='C:\Adempiere'
Views: 141 Losee & Phan
Search and Replace Case Insensitive Text - Python Recipe
 
05:54
This tutorial explains how to search and replace case insensitive text in Python using real world examples.
Views: 51 ma academy
Alter database table columns without dropping table   Part 67
 
04:06
In this video, we will discuss, altering a database table column without having the need to drop the table. Let's understand this with an example. Text version of the video http://csharp-video-tutorials.blogspot.com/2013/08/part-67-alter-database-table-columns.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-67-alter-database-table-columns.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 We will be using table tblEmployee for this demo. Use the sql script below, to create and populate this table with some sample data. Create table tblEmployee ( ID int primary key identity, Name nvarchar(50), Gender nvarchar(50), Salary nvarchar(50) ) Insert into tblEmployee values('Sara Nani','Female','4500') Insert into tblEmployee values('James Histo','Male','5300') Insert into tblEmployee values('Mary Jane','Female','6200') Insert into tblEmployee values('Paul Sensit','Male','4200') Insert into tblEmployee values('Mike Jen','Male','5500') The requirement is to group the salaries by gender. To achieve this we would write a sql query using GROUP BY as shown below. Select Gender, Sum(Salary) as Total from tblEmployee Group by Gender When you execute this query, we will get an error - Operand data type nvarchar is invalid for sum operator. This is because, when we created tblEmployee table, the "Salary" column was created using nvarchar datatype. SQL server Sum() aggregate function can only be applied on numeric columns. So, let's try to modify "Salary" column to use int datatype. Let's do it using the designer. 1. Right click on "tblEmployee" table in "Object Explorer" window, and select "Design" 2. Change the datatype from nvarchar(50) to int 3. Save the table At this point, you will get an error message - Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created. So, the obvious next question is, how to alter the database table definition without the need to drop, re-create and again populate the table with data? There are 2 options Option 1: Use a sql query to alter the column as shown below. Alter table tblEmployee Alter column Salary int Option 2: Disable "Prevent saving changes that require table re-creation" option in sql server 2008 1. Open Microsoft SQL Server Management Studio 2008 2. Click Tools, select Options 3. Expand Designers, and select "Table and Database Designers" 4. On the right hand side window, uncheck, Prevent saving changes that require table re-creation 5. Click OK
Views: 92856 kudvenkat
Relational Operators Section 8.1
 
08:42
Video overview of relational operators
Views: 52 Vishal Sachdev
SSRS Tutorial 28 - Single Value Parameter with Values from Query in SSRS Report
 
12:03
In this video of SSRS Tutorial, you will learn How to create Tabular Report with Single Value Parameter How to provide values to Parameter from Query How to Set Default Value to Parameter by using Query Results Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 9943 TechBrothersIT
SQL BASICS - CS50 on Twitch, EP. 6
 
01:29:39
Join CS50's David J. Malan on a tour of the basics of SQL -- Structured Query Language -- which powers so many of the world's databases. From Excel to a simple web app, we'll look at some relational database principles and ultimately some simple syntax to get you started in the world of database programming. Co-hosted by Colton Ogden. Join us live on twitch.tv/cs50tv. This is CS50 on Twitch.
Views: 2732 CS50
How NOT to Handle Exceptions - Part 1
 
06:43
In which Steven Feuerstein takes a look at several ways you should never handle an exception in your PL/SQL block. To summarize: 1. Don't swallow up or hide errors. 2. Don't simply display error information on the screen through a call to DBMS_OUTPUT.PUT_LINE. 3. Don't handle and re-raise without adding value (logging or doing *something*). Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2017/02/now-not-to-handle-exceptions.html Related LiveSQL script: https://livesql.oracle.com/apex/livesql/file/content_EHHFC36YW2834RB7Z9OE846C6.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2016 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.
CS50 2018 - Lecture 8 - SQL
 
01:54:22
00:00:00 - Introduction 00:00:50 - Hackathon Teaser 00:02:23 - Week 7 Recap 00:05:35 - C$50 Finance 00:07:47 - Cookies 00:15:46 - store 00:22:22 - Databases 00:27:15 - Mock Database 00:29:07 - SQL 00:39:32 - SQLite 00:51:52 - phpLiteAdmin 01:12:54 - lecture 01:38:39 - Race Conditions 01:45:57 - SQL Injection Attacks
Views: 17375 CS50
Part 28 C# Operators 4 Unary And Member Accessing
 
04:49
Unary And Member Accessing C# provides many operators, which are symbols that specify which operations (math, indexing, function call, etc.) to perform in an expression. You can overload many operators to change their meaning when applied to a user-defined type. Operations on integral types (such as ==, !=, &, |) are generally allowed on enumeration (enum) types. The sections below list the C# operators starting with the highest precedence to the lowest. The operators within each section share the same precedence level. Arithmetic Overflow The arithmetic operators (+, -, *, /) can produce results that are outside the range of possible values for the numeric type involved. You should refer to the section on a particular operator for details, but in general: • Integer arithmetic overflow either throws an OverflowException or discards the most significant bits of the result. Integer division by zero always throws a DivideByZeroException. When integer overflow occurs, what happens depends on the execution context, which can be checked or unchecked. In a checked context, an OverflowException is thrown. In an unchecked context, the most significant bits of the result are discarded and execution continues. Thus, C# gives you the choice of handling or ignoring overflow. By default, arithmetic operations occur in an unchecked context. In addition to the arithmetic operations, integral-type to integral-type casts can cause overflow (such as when you cast a long to an int), and are subject to checked or unchecked execution. However, bitwise operators and shift operators never cause overflow. • Floating-point arithmetic overflow or division by zero never throws an exception, because floating-point types are based on IEEE 754 and so have provisions for representing infinity and NaN (Not a Number). • Decimal arithmetic overflow always throws an OverflowException. Decimal division by zero always throws a DivideByZeroException. Assignment and Lambda Operators Conditional Operator Null-coalescing Operator #HindiTutorial #DilipSir #askDilipSir #Youtuber #YouTube #you_tuber #Dilip #sir #india #tech #technology #videos #best #tutorial #how #know_how #CSharp #Excel #Word #HTML #CSS #ComputerTips_Tricks #ASP.net #WinFormApp #HowtoFix #VisualStudio #MSPowerPoint #OutLook #SQL #Hindi #Urdu #SocialTech #Facebook #GamePlays #gameplay #game_play #playGame #CallofDuty #CsharpinHindi #HTML5 #Advance_Excel #IA, #RRB, #IBPS, #SSC, #UPPSC, #2nd Grade, #LDC, #POLICE, #COMPUTER, #RAILWAY, #ASSISTANT, #TEACHER
Views: 18 Dilip MJ Gangwar
Apply the appropriate changes to the database to allow entering from zero to many telephone...
 
01:37
Apply the appropriate changes to the database to allow entering from zero to many telephone numbers for every contact entry. Enter the phone number 2310256555 to Stelios Lambropoulos and the phone number 2310246652 to Kostas Goutoudis. Insert the appropriate indexes.Want more? Then download our TEST4U demo from https://www.test4u.eu/en/demo TEST4U provides an innovative approach to learning. Ignore the boring e-courses and use a new, interactive tool like 700 000 satisfied users did. TEST4U is an automated test which cooperates with the actual applications and can be used to prepare the students for certification exams (e.g. Microsoft-Certiport, ECDL/ICDL, DIPLOMA etc.) and train and assess employees. More on https://www.test4u.eu/en/demo
Views: 7 test4u.eu
T-SQL: MAX vs TOP 1 - Which is better?
 
14:24
Do you think MAX is better than TOP 1? Or are they effectively the same? The results might surprise you!
Views: 119 Steve Endow
jQuery in Oracle APEX - An Introduction for Database Developers
 
45:39
Learn jQuery from SkillBuilders.com/APEX! Oracle Application Express (APEX) developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. Luckily JavaScript libraries, such as jQuery which is integrated into APEX, have made the language much easier to use. In this session, learn about jQuery through a series of analogies, nine in total, which will relate important concepts in the library back to what you already know in the database world. From Dan McGhan, Oracle ACE at SkillBuilders.com/APEX
Views: 14131 SkillBuilders
Spark Tutorial - Data Sources | How to load data in Spark
 
15:17
I have already talked about loading data into Apache Spark from a CSV source file. In this Spark tutorial video, we will extend the same idea and explore some other commonly used Spark data sources. We will not only load but also explore the process of writing data to a variety of file formats. We will primarily work with five different types of data files. 1. Parquet 2. JSON 3. ORC 4. AVRO 5. XML All the Spark code examples available at below URL. --------------------------------------------------------------------------------------------- https://www.learningjournal.guru/courses/spark/spark-foundation-training/file-based-data-sources/
Views: 9944 Learning Journal
How to extract a substring from a string in string in javascript
 
05:15
extract a substring from a string.
Views: 40 Mr Code Monster
Insert into dan insert ignore SI widyatama
 
12:50
Pengantar Database tentang penggunaan insert, fakultas teknik prodi sistem informasi unviersitas widyatama - Usep Setiana - Syaiful Imam - Mega Cahya - Amir Rizal menjelaskan tentang penggunaan insert into dan insert ignore
Siebel CRM - Project 9 (part 3b) (Bidirectional Related SRs)
 
28:21
Siebel CRM - Project 9 (part 3b) (Bidirectional Related SRs) 27/9/2014 Clarification: The "Related Child SRs" field only shows if a specific SR has at least one Related SR underneath it or not. The "Related SRs" field shows if a specific SR is related in any way to any other SR or not ("Y" or "N" respectively). No matter if that specific SR is a Related SR to some other SR or has Related SRs underneath it, the indication will be "Y". If it has no Related SRs underneath it and it's not a Related SR to any other SRs the indication will be "N". If you see a SR with empty "Related Child SRs" but with the "Related SRs" set to "Y" it means that this specific SR is a Related SR to at least one other SR but it doesn't have any Related SRs underneath it. I kept the "Related Child SRs" in the Applets because of it's functionality (direct drill down to the Related Service Request View) and for reference purposes. If the users need only an indicator then that field/list column/control may be considered redundant. Thoughts: As always, we must honor (or at least try) Siebel's best practices. In my humble opinion, it's not a set of arbitrary rules, it's a set of information, a guideline if you will that reflects Siebel's structure and philosophy to a certain degree. I am only mentioning this because like with many Siebel's projects / implementations there are several different ways to reach the same goal and get the same results. But at the end of the day, it's all about performance, maintenance and consistency. These will make the difference. Speaking of which, I've been asked to completely ignore the fact that the users can delete SRs (the system allows them to do it, it's not disabled) and not to bother to update anything in that case. On top of that, I've been "suggested" to write something and schedule it to run once per day to take care the "inconsistencies" as a solution. According to my almost 14 years of experience as a Software/Systems developer we must never make any assumptions of anything. If there is button that does something and the users can press it then chances are they'll press it eventually and it won't be their fault either. Our job is to take that (and all the rest of the parameters after we have done our analysis) into consideration and take care of it the best way we can. Also, having yet another "thingy" running to correct any inconsistencies that exist doesn't make any sense since we can avoid them in the first place with minimum "cost". The heart of this implementation is just one custom Business Service which takes care of everything on the fly. One of the methods is just for the initialization (to update all existing SRs correctly to either Y or N or set the respective field to empty/null for testing/demo purposes). There isn't any kind of scripting (say at BC or Applet level) and it can be done in a more declarative way which is something I'd love and might try to do if/when I have the time. Testing/Verifying: Phase #1: we will set the field of all the existing SRs to empty/null, this is how the production system will look when we decide to deploy the implementation. This is only for developing / demonstration purposes. This will take about 90-120 seconds so you might as well go make a coffee. Phase #2: we will set correctly the field of every SR that exists in the Siebel database to either Y or N and we'll take it from there. That's the first thing we will have to do in the live system anyway, not necessary in this way (remember, I use the Demo/Sample environment here, in a live system I'd prefer to do this asynchronously, not in the AOM). That will take about 120-180 seconds. In a live system that might have, say half a million SR records, that would be done on a weekend, asynchronously or using a different method (there are other ways and I do NOT mean "updating" the Siebel database directly using SQL which is a big no-no for several reasons). After that we'll spend some time to verify that there are no inconsistencies. Phase #3: we will verify that the field is being set correctly after a new SR has been created. Phase #4: we will verify that the field is being set correctly (to the respective SRs) after one or more SRs have been added as a Relative Service Requests. Phase #5: we will verify that the field is being set correctly (to the respective SRs) after a SR has been removed as a Relative Service Request. Phase #6: we will verify that the field is being set correctly (to the respective SRs) after a SR - which is related in any way to others - has been deleted.
Views: 376 Nikolaos Skampas