https://www.databasestar.com/oracle-greatest/ The Oracle GREATEST function is a useful function, but I don’t think it’s very well understood. It returns the greatest or largest value in a set of values. You can provide the values, and use numbers or text values. The syntax for the Oracle GREATEST function is: GREATEST(expr1 [, expr_n]) The expr1 is the first expression to use for your comparison. Expr_n is one or more expressions to use in the comparison, separated by commas. This is optional. So how is GREATEST calculated? If the parameters are numeric, the GREATEST function finds the largest number. If the parameters are characters, the function finds the latest value if they were sorted alphabetically (using their character values). What data type is returned? It depends on the parameters you provide. It could be the same as the parameters you provide, or VARCHAR2 if the parameters are all characters. You can also use the GREATEST function with dates. It’s also the opposite of the LEAST function. For more information on the GREATEST function, including the SQL used in this video and the examples, read the related post here: https://www.databasestar.com/oracle-greatest/
Views: 292 Database Star
SQL Oracle Greatest and Least Functions You can use https://livesql.oracle.com to run you r sample queries and learn. Commands used: /*List Functions – GREATEST and LEAST*/ SELECT GREATEST(employee_id, department_id,salary), employee_id, department_id,salary from hr.employees; SELECT GREATEST(5, 18, 21, 3, 65) AS GREATEST_CHECK, LEAST(5, 18, 21, 3, 65) AS LEAST_CHECK FROM dual; SELECT GREATEST('Fred', 'Edward', 'Ruby', 'Jane') AS GREATEST_CHECK, LEAST('Fred', 'Edward', 'Ruby', 'Jane') AS LEAST_CHECK FROM dual; SELECT GREATEST('9', '12', '73', '15') AS GREATEST_CHECK, LEAST('9', '12', '73', '15') AS LEAST_CHECK FROM dual; SELECT GREATEST('45', 'apple', 'banana', 100) AS GREATEST_CHECK, LEAST('45', 'apple', 'banana', 100) AS LEAST_CHECK FROM dual; SELECT GREATEST( TO_DATE('25-MAR-2017'), TO_DATE('14-APR-2017'), TO_DATE('7-JAN-2017')) AS GREATEST_CHECK, LEAST( TO_DATE('25-MAR-2017'), TO_DATE('14-APR-2017'), TO_DATE('7-JAN-2017')) AS LEAST_CHECK FROM dual; SELECT GREATEST('Fred', 'Edward', NULL, 'Jane') AS GREATEST_CHECK, LEAST('Fred', 'Edward', NULL, 'Jane') AS LEAST_CHECK FROM dual; SELECT GREATEST('x', 'w','y', 'a', 'q', 'u', 'i', 'a', 'd', 's', 'g', 'k', 'e', 'w', 'i', 'p','a', 'z', 'b', 'c', 'm','w', 'r', 'y', 'n', 'Z') AS GREATEST_CHECK, LEAST('x', 'w','y', 'a', 'q', 'u', 'i', 'a', 'd', 's', 'g', 'k', 'e', 'w', 'i', 'p','a', 'z', 'b', 'c', 'm','w', 'r', 'y', 'n') AS LEAST_CHECK FROM dual;
Views: 42 Nids Dixit
SQL Coding Lesson 3 in Jinghpaw Language - Lessons Continued. Please watch in HD mode for better video quality. --numeric functions SELECT ABS(12) FROM DUAL; SELECT ABS(-12.65) FROM DUAL; SELECT CEIL(48.99) FROM DUAL; SELECT CEIL(48.11) FROM DUAL; SELECT FLOOR(49.99) FROM DUAL; SELECT FLOOR(49.11) FROM DUAL; SELECT ROUND(49.11321,2) FROM DUAL; SELECT ROUND(49.11321,3) FROM DUAL; SELECT POWER(4,2) FROM DUAL; SELECT POWER(3,4) FROM DUAL; SELECT MOD(4,2) FROM DUAL; SELECT MOD(5051,100) FROM DUAL; select greatest(34,567,290,86) from dual; select least(34,567,290,86) from dual; select INSTR('Tech on the net', 'e') from dual; select INSTR('Tech on the net', 'e', 1, 1) from dual; select TRIM(' tech ') from dual; select TRIM(' ' FROM ' tech ') from dual; select TRIM(LEADING '0' FROM '000123') from dual; select TRIM(BOTH '1' FROM '123Tech111') from dual; select GREATEST(2, 5, 12, 3) from dual; select GREATEST('2', '5', '12', '3') from dual; select GREATEST('apples', 'oranges', 'bananas') from dual; select LEAST('2', '5', '12', '3') from dual; --null select (9000*null) from dual; select (null/9000) from dual; select (9000-null) from dual; select (9000+null) from dual; select distinct department_id from employees where commission_pct is not null; select last_name,job_id,coalesce(department_id,0) as dept,salary,commission_pct,coalesce(commission_pct,0) as comm_not_null, salary*commission_pct as multiplied_by_null, salary*coalesce(commission_pct,0) as commission_amt, salary+ (salary*coalesce(commission_pct,0)) as salary_plus_comm from employees where commission_pct is not null or department_id=20 order by dept; desc locations; select coalesce(postal_code,city,STATE_PROVINCE,COUNTRY_ID) as new_address,postal_code,city,STATE_PROVINCE,COUNTRY_ID from locations where COUNTRY_ID in ('JP','IT','UK'); --add more departments SELECT first_name ||'.'||last_name as "Employee Name",department_id, CASE when department_id in (10) THEN 'Accounting' WHEN department_id in (20) THEN 'Research' -- WHEN commission_pct is not null THEN 'Sales' WHEN department_id in (30) THEN 'Operations' ELSE 'Unknown' END department FROM employees ORDER BY first_name ||'.'||last_name ; SELECT last_name, department_id, DECODE( department_id ,10 ,'Accounting' ,20 ,'Research' ,30 ,'Sales' ,40 ,'Operations' ,'Unknown') department FROM employees ORDER BY last_name; select country_id,decode(country_id,'BR','Southern Hemisphere', 'AU','Southern Hemisphere', 'Northen Hemisphere') hemisphere from locations order by hemisphere; --set define on; select 'Coke & Popcorn' from dual; --upper,lower,coalesce and null select upper('sql') from dual; select lower('SQL') from dual; select initcap('sql') from dual; Select * from employees where email like '%SON'; Select * from employees where lower(email) like '%son'; Select * from employees where upper(last_name) like '%SON'; Select * from employees where lower(job_id) ='pu_clerk'; Select * from employees where initcap(email) ='Sbaida'; select * from employees where substr(phone_number,1,3) eq '515'; select * from employees where substr(phone_number,1,3) ne '515'; select * from employees where last_name gt 'King'; select * from employees where hire_date lt '01-JAN-1992'; --special character select * from jobs where job_id like 'SA\_%' escape '\'; select * from jobs where job_id like 'SA$_%' escape '$'; --translate, replace --( string1, string_to_replace, replacement_string ) select TRANSLATE('1tech23', '123', '456') from dual; select phone_number,translate(phone_number,'.','-') as modified_phnum from employees where rownum le 10; select job_id,translate(job_id,'_','&') as modified_phnum from employees where rownum le 10; select phone_number,translate(phone_number,'515','415') as modified_phnum from employees where rownum le 5; select phone_number,REPLACE(phone_number,'515','415') as modified_phnum from employees where rownum le 5; select REPLACE('123123tech', '123') from dual; select REPLACE('123tech123', '123') from dual; select REPLACE('222tech', '2', '3') from dual;
Views: 45 Hkau Doi
https://www.databasestar.com/oracle-replace/ The Oracle REPLACE function is a string manipulation function that allows you to replace one text string with another. It can be a whole word or sentence, or even a single value. The syntax of the REPLACE function is: REPLACE ( whole_string, string_to_replace, [replacement_string]) To use this function, the parameters are: - whole_string (mandatory): This is the string that will be checked for the characters to be replaced. - string_to_replace (mandatory): This is the string that will be searched for within whole_string. - replacement_string (optional): This is the string that will be used to replace occurrences of string_to_replace. Because the last parameter is optional, if it is not specified, then the Oracle REPLACE function removes all occurrences of string_to_replace. You can replace carriage returns with REPLACE, but you’ll need to use the CHR function. You can replace NULL values in Oracle, but this is best done with another function such as NVL, rather than REPLACE. If you want to replace multiple characters, you can do this using nested REPLACE functions or a REGEXP_REPLACE function. For more information about the Oracle REPLACE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-replace/
Views: 1188 Database Star
https://www.databasestar.com/oracle-months_between/ The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference. This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions. The syntax of the MONTHS_BETWEEN function is: MONTHS_BETWEEN(date1, date2) What do these two parameters mean? The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative. What data type is returned? It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value. For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here: https://www.databasestar.com/oracle-months_between/
Views: 1011 Database Star
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-8-sql-query-to-find-department.html Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC
Views: 126140 kudvenkat
NULL is a keyword used to represent ‘unknown’ or ‘missing’ data. NULL is not ‘zero’ or ‘blank’. SQL NULL functions are used to validate it. Explained NVL(), NVL2(), NULLIF(), DECODE() & COALESCE() in detail with examples SQL Interview Q & A Playlist: https://www.youtube.com/watch?v=t2qoqI5TjSk&list=PLSo-SnVTqbBLavDdG89zpQZDWkoEc9LP_ LINUX Interview Q & A Playlist: https://www.youtube.com/watch?v=1WEZqImoxzs&list=PLSo-SnVTqbBIBjEhxwRV3hbYmfXOWiYmR Technology You Must Know Playlist: https://www.youtube.com/watch?v=9FPrr1f2yjo&list=PLSo-SnVTqbBK4qk42HRrawr17mBITQmJd
Views: 1120 Shivanand V
The TEXT data types have not yet been discussed, but they are another string data type. They are similar to the VARCHAR data type with some minor differences that are important to know. The first thing to note is that there are four versions used to determine different sizes. From least to greatest size is TINYTEXT, TEXT, MEDIUMTEXT, LARGETEXT. These each have different maximum byte sizes: 255, 65535, 16 million something, and 4 billion something. You create a column as one of these data types just as you would with a varchar column. You work with them exactly the same, too. If that is the case, what are the primary differences between these and VARCHAR? The first difference is that VARCHAR is restricted by the row limit of a table. TEXT tables do not contribute nearly as much (max of 12 bytes) because the data is not stored inline in the table. This means that if you need to allow for extra space for other rows, you can use a TEXT column. And even though the table only contains a pointer to the data, it is all hidden to us and working with a TEXT column is the same as working with a VARCHAR column. The second primary difference is that TEXT data types do not allow for a default other than NULL. Thirdly, VARCHAR is limited to just under 64KB, whereas you can use MEDIUMTEXT or LARGETEXT to allow for more storage. So if what you are trying to store as an individual value is over 64KB, use a text column. Other than those three things, VARCHAR will usually work just fine for our text needs. Now, last thing is that these data types are often called CLOB data types. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 5765 Caleb Curry
Music used is "Crystallize," by Lindsey Stirling. FAQs; Q: What happened when your armor shot down to 60%? A: The Sansha's Slave Lord which was firing at me just so happened to shoot while my radial velocity in comparison to him was low. This resulted in a near-perfect hit which caused me to take a lot of damage. If you want to prevent this, then manually maneuver your ship as opposed to simply orbiting your target, though it shouldn't be necessary (I tanked it just fine). Q: What's your fit? (It didn't stay on screen for very long) A: 8x dual light pulse lasers 1x 1MN afterburner 2x Heat Sink 1x Small armor repairer 1x Capacitor power relay 3x Small capacitor control circuit In all honesty, you could probably make do with less capacitor stuff; either change the capacitor power relay into a third heat sink or tracking enhancer, or change 1-2 of the rigs into damage/tracking rigs. However, if your skills are low, having a good cap buffer is a plus. Q: Where are you, and would this work in other regions? A: I'm in space with Sansha rats, so EM/thermal damage is good, which happens to be what the Coercer is good at. It would probably also work in Blood Raiders space, where the rats are weak to the same damage type. I probably wouldn't recommend this for other NPCs, which are resistant to that damage type; however, the other destroyers are all viable for this as well. For Serpentis/Guristas space, use hybrids (the Catalyst or Cormorant) or a Thrasher using Phased Plasma ammunition. For Angel space, the best destroyer is really only the Thrasher using Fusion ammo, given that it's the only one to reliably deal explosive damage. Q: How much skill training would this require? A: Bare bones, you could fly destroyers in 4 days or so. If you're also including getting the relevant skills to 4 (Destroyers IV, gunnery skills to IV, cap skills to IV) it would probably be about 2.5 weeks? Q: What other PvE activities can this be used for? A: It will probably also work for low to mid level missions (L1s and L2s, *maybe* L3s?). I would not recommend it for cosmic anomalies or deadspace complexes - at least not solo - because of a large number of cruisers and frigates which will ruin your day. Q: What's the DPS of your fit? A: 250 with t1 multifrequency. If you drop the capacitor power relay for a third heat sink, that goes up to 290 (as much as a Drake shooting EM missiles), and if you use imperial navy multifrequency that hits around ~320. With decent skills, you should be able to break the tank of any Sansha rat, and can probably kill most of them even with low support skills. Q: How are you tanking battleships in a destroyer? A: By using the afterburner to keep your speed up, you can greatly reduce the damage that enemy battleships and cruisers will deal to you - this is due to the way weapons in EVE work. Essentially, if a turret is firing at you, you will take more damage if you are going slowly than if you are going fast. This alone won't save you, though; you also need to travel at an angle in relation to the opponent, as opposed to straight on. This essentially means that you're barely going to get hit, so what little damage you do take can be comfortably soaked up by the repper. As you saw, my actual tank really isn't very good - at the 3:20 mark, I accidentally took a direct hit, and my armor was brought down to 60% with a single shot. This is why you keep moving, and always watch the angles so that you try not to let yourself fly in a straight line compared to something else. Edit - Added tips, courtesy of ZaiRoX on Reddit: Find an empty null. Systems without npc stations are usually less populated. Use a "travel" fit between highsec and null. It should have some buffertank and a couple WCS. Just pick your refit station carefully!. Make a insta-undock bm if you can. While travelling. Check your map for ship destroyed/podkills along your route. Every gatecamp will kill you... Bring a secure container. You get more cargospace and get the benefit of keeping the loot locked at a safespot (requires anchoring lvl 1). This is important to minimize your losses. Also the fit is very dependent on speedtanking. You'll die instantly if you crash into an asteroid. Manual flying is a must.
Views: 11227 Roosterton
Subscribe to Devoxx on YouTube @ https://bit.ly/devoxx-youtube Like Devoxx on Facebook @ https://www.facebook.com/devoxxcom Follow Devoxx on Twitter @ https://twitter.com/devoxx The Optional class was introduced in Java 8 in order to solve a narrow but frequently occurring problem: what to return if you have nothing to return. It is a single class with less than 20 methods, but it turns out to have been one of the most controversial and most misunderstood APIs, having generated several "centithreads" of discussion on OpenJDK mailing lists. Indeed, Brian Goetz (Oracle's Java Language and Libraries Architect) has mentioned that one aspect of Optional was his biggest mistake in Java 8. Optional is also one of the more widely misused APIs. A brief survey of OpenJDK code revealed several embarrassing examples of Optional usage, and expert Java programmers have admitted to not making the most of this API. This session covers the history and rationale of Optional, provides recommendations and examples of proper and effective usage, shows several antipatterns and code smells and how to fix them, and finally describes some current and proposed work on Optional for Java 9. Stuart Marks is a Principal Member of Technical Staff in the Java Platform Group at Oracle. He is currently working on a variety of JDK core libraries projects, including Collections, Lambda, and Streams, as well as improving test quality and performance. As his alter ego "Dr Deprecator" he also works on the Java SE deprecation mechanism. He has previously worked on JavaFX and Java ME at Sun Microsystems. He has over twenty years of software platform product development experience in the areas of window systems, interactive graphics, and mobile and embedded systems. Stuart holds a Master's degree in Computer Science and a Bachelor's degree in Electrical Engineering from Stanford University. [VXM-7030]
Views: 25763 Devoxx
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 199 OracleDBA
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 177984 Joes2Pros SQL Trainings
Welcome to the VIDEO 8 of PL/SQL In these video We will learn about the Relational operator in PL/SQL. Operator: An operator is a symbol that tells the compiler to perform specific mathematical or logical manipulations. Relational Operator: Relational operators compare two expressions or values and return a Boolean result As you can see we used the relational operator greater than to find greatest number we also used LOGICAL Operator AND Which we will learn in the upcoming video as you can see 14 is the greatest we also used substitution variable Please SUBSCRIBE to our Channel Thank you for Watching.
Views: 283 Programming Nightmare
Want to count how many rows your query returns? Or the number of orders per customer? Or find your fastest time to run races of 1k, 5k and 10k? You can answer all these questions in SQL using group by and aggregate functions. Watch this video to find out how! For a complete list of aggregate functions available in Oracle Database 12.2 g to: http://docs.oracle.com/database/122/SQLRF/Aggregate-Functions.htm#SQLRF20035 Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/devgym/database-for-developers.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon 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: 5301 The Magic of SQL
"ORA-06502: numeric or value error" is one of the most commonly occurring and irritating errors for PL/SQL developers. Value too big for its "container"? Trying to stuff a non-numeric string value into a number through implicit conversion? [naughty naughty] In this video, Steven takes a close look at ORA-06502, exploring the ways it can be raised and how best to deal with those scenarios. ============================ 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.
In this turial, I will show you How To Use Logical Operators in SQL SELECT Statement, How To Use OR Operators in SQL SELECT Statement, How To Use AND Operators in SQL SELECT Statement, How To Use Logical Operators in SQL SELECT Statement, How To Use Logical AND Operators in SQL SELECT Statement. I hope you enjoy this tutorial. Please subscribe my channel. mysql greater than and less than query - mysql operators - mysql logical operators in where clause - mysql logical operators mysql or - mysql && - mysql select where - mysql between,mysql comparison operators - mysql operators - mysql greatest - mysql greater than or equal to - mysql greater than and less than query - mysql not equal string - mysql not equal null - mysql not equal operator - not equal to in mysql query - mysql greater than - mysql between - mysql query greater than or equal to - mysql less than or equal to - mysql tutorial in bangla - mysql bangla tutorial - mysql - tutorial - beginner - advanced - mysql tutorial.
Views: 326 Soft-All
Hi Guys, This is Sandeep Kumar Maurya I have Always been asked to share my code which I use in my video. Answering people’s questions is great, and the feeling you get when you solve a problem always felt good. The only problem I have is making tutorials is a little bit time consuming. It requires planning the subjects that need to be covered, recording the tutorial, editing the video, rendering it and finally uploading it on YouTube. So I need your help in Collecting All the codes at one place. I made a website Codebind.com for sharing my code and other programming stuff. But I alone can not do this. So Ask you guys to become contributor to this site. Just Share the code Which you learn by watching Programming Knowledge or You can simply share your Programming Knowledge with others. What is your Benefit? 1 - Together we can collect all the codes of All my videos and share it with others. 2 - Sharing Knowledge is the biggest learning. By sharing You can understand the concepts better. Bindas Programming..........
Views: 48 Bindas Programming
Edit like a Game Theorist! CLICK HERE ►► http://www.lynda.com/matpat With the release of Hyrule Warriors, I got to thinking...clearly not all Legendary Heroes are created equally. So across all the various reincarnations of Link in the Legend of Zelda series, which Link would be the best, the one to rule them all? We analyze their strength, smarts, stealth, experience, and equipment to find out which Link is the best Link! Special thanks to Drake for his help researching and capturing for this video: http://bit.ly/1uwhtBl Join the Loyal Theorists: http://bit.ly/1qV8fd6 OTHER LoZ Theories: What's in Link's Potions? ► http://bit.ly/Zj2FsS Link is Dead Theory ► http://bit.ly/1uwhjtJ Majora's Moon ISN'T a Moon ► http://bit.ly/1DN6lTa More Nintendo Theories: Can Bullet Bill kill you? ►► http://bit.ly/1lu41Lo Mario is a Psychopath! ►►►http://bit.ly/1nSum0E Check out some more of our awesome video game content: Game Theory: http://bit.ly/1zz3t7E Culture Shock: http://bit.ly/1sw7aZ8 Digressing and Sidequesting: http://bit.ly/1rxBUgz Crossover: http://bit.ly/1t9AclA
Views: 9314859 The Game Theorists
For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors Goal is to write your first PL/SQL program. The basic program unit in PL/SQL is the block. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords partition the block into a declarative part, an executable part, and an exception-handling part. Example of a Block DECLARE bonus NUMBER(8,2); emp_id NUMBER(6) := 100; BEGIN SELECT salary * 0.10 INTO bonus FROM employees WHERE employee_id = emp_id; Exception When NO_DATA_FOUND THEN null ; END; This is a typical PL/SQL block where 10% of salary is selected and stored on a temp variables bonus. If for some reason there is no employee with empid = 100 then the control will come to exception area and the code in the exception area will be executed. These blocks can be entirely separate or nested one within another. The basic units (procedures and functions, also known as subprograms, and anonymous blocks) that make up a PL/SQL program are logical blocks, which can contain any number of nested sub blocks. Therefore, one block can represent a small part of another block, which in turn can be part of the whole unit of code. Anonymous Blocks Anonymous blocks are unnamed blocks. They are declared at the point in an application where they are to be executed and are passed to the PL/SQL engine for execution at run time. You can embed an anonymous block within a pre-compiler program and within iSQL*Plus or Server Manager. Triggers in Oracle Developer components consist of such blocks. Subprograms Subprograms are named PL/SQL blocks that can accept parameters and can be invoked. You can declare them either as procedures or as functions. Generally use a procedure to perform an action and a function to compute a value. You can store subprograms at the server or application level. Using Oracle Developer components (Forms, Reports, and Graphics), you can declare procedures and functions as part of the application (a form or report) and call them from other procedures, functions, and triggers (see next page) within the same application whenever necessary. Note: A function is similar to a procedure, except that a function must return a value.
Views: 65779 Oresoft LWC
Most epic Haikyuu!! soundtracks out there, Fighting Anime ost, Motivational anime ost ,battle ost , battle soundtrack Anime OST , Emotional OST , Anime Battle Mix ほとんどの叙事詩アニメサウンドトラック TRACKLIST 00:00:00 Team Potential 00:02:53 Let the Games Begin 00:05:29 Declaration of War 00:09:09 The Destroyer 00:12:01 God-like Quick 00:14:51 Ground Warfare 00:16:56 Outbreak of War 00:18:58 Limit Switch 00:21:36 Into the Fray 00:24:12 Above 00:28:13 Baby Bird 00:30:30 An Interesting Team 00:32:39 Frustration 00:35:16 A Reason 00:37:51 Into the Fray 00:41:33 Six Who Are Strong Are Stronger 00:44:27 Moving Like Normal 00:46:30 Winners and Losers 00:48:52 Declaration of War 00:52:33 Back in Action 00:55:27 Beginning of a Duo 00:57:48Confrontation with the King 01:00:19 Declaration of War I hope you will like this video and dont forget to subscribe for more videos, share, like, and comment your ideas. cheers THANKS FOR READING!! ≈≈≈≈≈≈≈≈ More Info ≈≈≈≈≈≈≈≈ ≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈ ● Non-monetized account ● I do not own any of the music or images displayed in this video ● The music and images belong to their composers and artists ≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈≈ Follow on Twitter nakama ;) ➝ https://twitter.com/Matarife22 🌐 SUBSCRIBE HERE NAKAMA: https://www.youtube.com/channel/UCQd_ITKCA4B6DxxQhdCUMhw/?sub_confirmation=1 Become a nakama by subscribing : We are 1840 (Thx nakamas!) ➝Support the channel: https://www.paypal.me/MATARIFE ▲ DISCLAIMER: ▲ I do not own song or any footage used in this video. No copyright intended. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. haikyuu best ost,Haikyuu!! Best OST,haikyuu ost,MATANIME,haikyuu soundtrack,haikyuu best songs,haikyuu best soundtrack,haikyuu ost above,haikyuu ost outbreak of war,outbreak of war haikyuu,epic anime music,epic anime battle music,epic anime ost 2019,epic anime ost mix,epic anime ost playlist,best sport anime to watch,best sport anime 2019,Matanime mix,Haikyuu!! Best soundtrack #Haikyuu #MATANIME #AnimeMix
Views: 56 MATANIME Top anime/OST/Montage
Comparison operators are used in WHERE clause that compare one expression to another, In this turial, I will show you How To Use Comparison Operators in SQL SELECT Statement, How To Use greater than Operators in SQL SELECT Statement, How To Use less than Operators in SQL SELECT Statement, How To Use greater than or equal Operators in SQL SELECT Statement, How To Use less than or equal Operators in SQL SELECT Statement, How To Use equal Operators in SQL SELECT Statement, How To Use not equal Operators in SQL SELECT Statement. I hope you enjoy this tutorial. Please subscribe my channel. mysql comparison operators - mysql operators - mysql greatest - mysql greater than or equal to - mysql greater than and less than query - mysql not equal string - mysql not equal null - mysql not equal operator - not equal to in mysql query - mysql greater than - mysql between - mysql query greater than or equal to - mysql less than or equal to - mysql tutorial in bangla - mysql bangla tutorial - mysql - tutorial - beginner - advanced - mysql tutorial.
Views: 367 Soft-All
►Arcana giveaway 150K SUB: https://goo.gl/k8SrAv ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ►Dotabuff: https://www.dotabuff.com/matches/3716036880 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⏩Submit Your Replay, Video: https://goo.gl/nxH2We ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⏩Social Media: Must visit and like! 😁 ►Youtube: https://www.youtube.com/c/dota2divine ►Facebook: https://www.facebook.com/DotaIIDivine ►Google Plus: https://plus.google.com/u/0/+DOTA2Divine ►Twitter: https://twitter.com/dota2divine ►Reddit: https://www.reddit.com/user/Dota2Divine/ ►VK: https://vk.com/id402585880 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⏩Our Cool Playlist: Must Check ►EPIC DOTA MOMENTS: https://goo.gl/i0eCfN ►Dendi the best Player: https://goo.gl/WObGCL ►Meracle SEA pride: https://goo.gl/Y1G9JJ ►MidOne Funny Player: https://goo.gl/VrKHIB ►W33, invoker God: https://goo.gl/giRTeH ►Dota 2 miracle- 9000 MMR: https://goo.gl/u5Cmfu ►Arteezy 9000 MMR: https://goo.gl/PBzw9m ►Enternal Envy Try Hard DOTA: https://goo.gl/DnpGhe ►ANA Young Blood: https://goo.gl/1c5gLJ ►ABED Best Meepo World: https://goo.gl/6qJbjl ►ARISE Best Magnus World: https://goo.gl/rfCcUh ►Wagamama Teach me Please: https://goo.gl/JgI5G0 ►Game-Leap Learn to play like a Pro: https://goo.gl/LoRwBB ►Singsing funny moment: https://goo.gl/bfKRT8 ►Bulldong funny momnet: https://goo.gl/QK2eUj ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Others DOTA 2 Channel You should Subscribe to: ►JustWant2PlayAGame: https://goo.gl/Z20Hib ►DOTA 2 Rapier: https://goo.gl/SnGwYv ►Dota Dagon: https://goo.gl/p6wMF9 ►OnlyBrothers Dota 2: https://www.youtube.com/user/OnlyBrothersGamers ►Noobfromua: https://www.youtube.com/user/noobfromua ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Dota 2 is a free-to-play multiplayer online battle arena (MOBA) video game developed and published by Valve Corporation. The game is the stand-alone sequel to Defense of the Ancients (DotA). http://store.steampowered.com/app/570/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⏩CREDIT --------------------------------------------------------------------------------------- 🎧MUSIC: Guardian Watch https://www.youtube.com/watch?v=ZUcOAL_53kg New Altitudes https://www.youtube.com/watch?v=qwnqVxgQcQQ When Hope Persists https://www.youtube.com/watch?v=wwyENWmgkAo Shaping Our World https://www.youtube.com/watch?v=u5ljKDJv0fA Epic Adventure Music? A Legend's Adventure https://www.youtube.com/watch?v=LFa6REIA-mE Ansia Orchestra - Battle Theme https://www.youtube.com/watch?v=I9-rnxvxJMc Shattered Helium - Under The Sky https://www.youtube.com/watch?v=a4YUrTdsFCI Escape from the Temple by Per Kiilstofte https://www.youtube.com/watch?v=fcV0ZoLbtBY ►Others: Warcraft 3 OST, Dota 2 Within Music Pack, Crysis Warhead OST ►Dota 2 Music: Soundtrack composed by Valve members Jason Hayes and Tim Larkin. Orchestration and conduction by Timothy Williams. Performed by the Northwest Sinfonia and Recorded at Bastyr University. --------------------------------------------------------------------------------------- 🌲ART ►Intro by RavenProDesign: http://www.RavenProDesign.com ►Outro by sheron1030: http://sheron1030.deviantart.com/gallery/ ►Thumbmail: →http://rabidvegeta567.deviantart.com/art/PUDDIN-POP-321565742 If you have some problem with the art, please inbox me! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🍅Welcome to DOTA 2 DIVINE, At DIVINE DOTA you can find all Pro Dota 2 Gameplay, funny Dota moment, Pro highlight, Amazing Build, WTF Funny video. Hope you enjoy watching Dota 2 Divine and Make sure to subscribe DIVINE DOTA to watch all the coming video. Like and share it to your friends. ►Favorite Dota Players: Dendi, Miracle, s4, Arteezy, AdmiralBulldog, Alohadance, Loda, Sumail, Notail, Aui_2000, Fear, Puppey, Akke, Enternal Envy, w33, zai, ANA, Meracle, Abed. ►Favorite Team: Team Secret, Evil Geniueses, Navi, Liquid, OG, Alliance. ►Favorite Hero: Pudge, Invoker, Legion commander, Phantom Assassin, Sniper, Slark, Juggernaut, Mirana, Monkey King, Riki. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 7.06 META is Great, share your thought about dota 2 patch at comment section The international 2017 is comming, let us know your thought on comment sections! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Wraith King New Style Null × Throne Babyknight Dota 2 Gameplayhttps://youtu.be/LiDWSpkJZtY
Views: 6053 DOTA 2 Divine
By using pointers we swap the two numbers and returned to main function.
Views: 912 Not Null Tutorials
Want an entry on the Live Show Giveaway while the show is live? Get your entry here. https://store.markeedragon.com/index.php?cat=18 We will draw near the end of the live show and the winner will be notified by email. If you are viewing the giveaways while the show is offline only monthly giveaways will appear. http://store.markeedragon.com/affiliate.php?id=4&redirect=index.php?cat=4 Special Viewer Discount or Bonus. YOUR CHOICE! Want a bonus on your EVE new account or Plex? Use the discount code of "discount" and get 3% off your order. Or want 3.3% cash back for even more savings? Use bonus code "bonus" and get 3.3% credit in your account for future purchases This is for a limited time and the discount/bonus codes may be changed or removed at any time. The discount / bonus is provided by Markee Dragon Game Codes and we are an authorized CCP reseller. Codes delivered in 20 minutes or less. Twitter: http://twitter.com/markeedragon What's my computer build? Want to know what other stuff I use? Find it here: https://www.amazon.com/shop/markeedragon Want to Try EVE for free? Get it here: http://secure.eveonline.com/signup/?invc=d6baec26-231d-4ced-9cd2-1a8b3713d72d&action=buddy [!nojob] Want to get rid of your day job and be your own boss? Markee Dragon is sharing how he does it with a step by step guide to independence. Get it here: http://jedimarketingtricks.com/ultimate/ Join me and your favorite streamers! Put my 10+ years of experience to work for YOU. Learn how to start generating income while playing your favorite games! I include everything you need to know to get started PLUS plenty of support for when you get stuck! Join us for chat in Discord https://discord.gg/markeedragon Discord is what we use for in game chat and voice comms. This is a simulcast of http://twitch.tv/markeedragon . You can watch here live on YouTube and talk in chat. but for the giveaways mentioned on the show those currently only work in Twitch chat. You do not have to watch on Twitch. You only need to be in the Twitch chat to get in on the giveaways. WTFast is what I use to improve my connection to EVE. I get at least a 20% improvement at all times. Try it here: http://www.wtfast.com/markeedragon Videos How to convert Loyalty Points This video shows how we decided what items to use. Items Sold. https://www.youtube.com/watch?v=rnv4eW9hwP0 What worked Successful conversion of 1m LP to 1.5b ISK in 13 days. https://www.youtube.com/watch?v=eiGEj4XhKt0 Hauling Introduction https://www.youtube.com/watch?v=7NjY9aU-uBQ Hauling is a great secondary income. Market Blue Line Hauling is a great secondary income. EVE Sites Mentioned on the Show EVE Guides and Ship Fits: http://news.markeedragon.com/category/game-guides-how-to/eve-online-guides/ Moose Army Corp - My Null Corp I am a member of. http://moose.army Airhogs - The best all around corp and great for new players. I am also a member http://docs.google.com/document/d/1cCPjgTfOxMN7JpagSs5iUCyES2OalT5j6O4zaP5qVNw/edit?usp=sharing LP Store Conversion See what LP items are currently worth on the market. https://www.fuzzwork.co.uk/lpstore/ Daopa's LP Stores Database LP store items information http://www.ellatha.com/eve/LP-Stores EVE Assets Manager Find your stuff. Know where your money is sitting! http://eve.nikr.net/jeveasset EVE Markets Market history data. http://eve-markets.net/ EVEPraisal Quick values for your loot and other market actions. http://evepraisal.com/ EVE Maps All kinds of map related information. http://evemaps.dotlan.net/ Deepsafe https://deepsafe.xyz Excellent crowed sourced information on cosmic signatures. All explorers should use this. EVE University EVE Wiki http://wiki.eveuniversity.org/Main_Page Live shows Schedule: https://docs.google.com/spreadsheets/d/1zQZoKQnzGRgWXBefzGKlyfDppGQWzJy6PafWm-4c4sQ/pubhtml Music by Monstercat http://www.monstercat.com
Views: 888 Markee Dragon Gameplay
Unspoken Alliance premiering their new Leshak doctrine vs Cure coalition in Great Wildlands. CURE was hitting an E.B.O.L.A raitaru and we were waiting for EBOLA to drop on them. EBOLA stood down, but we decided to go in anyways. https://br.inyour.space/?s=992&b=8210580&e=90&t=urqc
Views: 2918 Mark Jones
Сообщение на стриме: http://www.donationalerts.ru/r/iworstplayerever Isk Donation: Lussy Lou Делайте ставки и выигрывайте https://www.eve-bet.com/ ! Paypal: https://www.paypal.me/ibeast Yandex: 410012682387501 Qiwi: +79313116518 Сбербанк: 4276 8410 4013 4070 http://www.donationalerts.ru/r/iworstplayerever
Views: 3736 worstplayerever
Steal This Video Any duplication in whole or in part of this video is strictly forgiven. Fair Use Notice: This video contains some copyrighted material whose use has not been authorized by the copyright owners. We believe that this not-for-profit, educational use on the Web constitutes a fair use of the copyrighted material (as provided for in section 107 of the US Copyright Law. If you wish to use this copyrighted material for purposes that go beyond fair use, you must obtain permission from the copyright owner. Fair Use notwithstanding we will immediately comply with any copyright owner who wants their material removed or modified, wants us to link to their web site, or wants us to add their photo. Disclaimer: The owner and operators of this web site user page do not engage in illegal activities, nor do they know any individuals who do. This web site user page is intended to inform the public about the NEW WORLD ORDER, We value all opinions. In our time online, no rebuttal has been had. --- ---- --- ---- --- ---- --- ---- ---- ---- ---- ---- --- ---- ---- ----NEVER FORGIVE ----We know the Truth! Rude1-RIP! Why are we in an economic collapse, January 26 2009 Keywords: American Militia, American Resistance Movement, American Revolution, Revolution, Revolt, American Militia Movement, A.R.M, Alex Jones, New World Order, Illuminati, NWO, Skull and Bones, Bush, 911 Conspiracy, The Civilians Military, Militia, American Resistance Movement, Revolt, Bilderberg, CFR, Alex Jones, Jordan Maxwell, Loose Change, End Game, Terrorstorm, Patriot Act, HR 1955, 911 was an inside job, truth, iraq war, black water, free masons, Ron Paul, New World Order carbon tax CO2 Global Warming is a fearmongering scam. The sun is getting hotter. Alex Jones is just one source. Police State is just making some X-military clones. MK Ultra mind control. Income. John F. Kennedy or JFK CIA FBI international bankers Rothschild David Rockefeller. Chemtrails chemical trails from jets. Air Force United States Army Navy Marines National Guard. NORAD stood down. Fake war in Iraq and Afghanistan but the human deaths are real. Corporations own a market for every physical item on this Earth. Immortal Technique is trying to push the revolution into the streets. I don't know if I can agree with that. People go to work all day Jedi Mind Tricks are alright. Vinnie Paz in shit. Paris is OK. Sick Since and Ill Bill all good. 911 or September 11, 2001 was the greatest world scam to take place in a very long time, no matter what your take on the conspiracy theorist or theories America American Turn off the TV and the news. Project Paper Clip Operation Northwoods George W H Bush Bill Skull and Bones Bohemia Grove secrete societies Freemasons mason Masonic Temple Mormon. Government in schools. Mercury Vaccines. Nazi Hitler Every one is in a rush. Drugs marijuana blunt alcohol tobacco National ID Cards in May 2008. Elections are rigged. Real ID Act congress president. Obama and Mccain are clones. Republicans and Democrats are the same. Council on Foreign Relations. Club of Rome. Trilateral Commission. Federal Reserve illusion money dollar fall. Graph and carts. Round Table. Cocaine Mushrooms Crack Heroin Meth. 666 Mark of the Beast Christian Catholic Muslim Jewish Jew inside job protest fight Last Days Jesus Christ God. The second coming. North American Union. South American Union. APEC. European Union. All Seeing Eye. Devil Lucifer. Traffic cams cameras intersection cops clowns jesters. CFR is weak. NAU One World Government
Views: 31631 AlienHistory
Join C4W3 as he talks about his work with Care 4 Kids, a newly formed EVE based charity that brings EVE Online to children in hospitals across Europe. Learn more about Care 4 Kids here: http://careforkidseve.com/ To try EVE for free, head over to http://www.eveonline.com
Views: 1101 EVE Online
Darkness Titan undocked. He died. https://zkillboard.com/kill/71977924/ Music: https://soundcloud.com/liquidritual/ofdream-perception Try EVE Online for free and get a 250.000 skillpoint bonus! http://secure.eveonline.com/signup/?invc=a399877d-08ac-4319-803c-c48e92f3d69d&action=buddy
Views: 4525 Ultra Cow
Want an entry on the Live Show Giveaway while the show is live? Get your entry here. https://store.markeedragon.com/index.php?cat=18 We will draw near the end of the live show and the winner will be notified by email. If you are viewing the giveaways while the show is offline only monthly giveaways will appear. http://store.markeedragon.com/affiliate.php?id=4&redirect=index.php?cat=4 Special Viewer Discount or Bonus. YOUR CHOICE! Want a bonus on your EVE new account or Plex? Use the discount code of "discount" and get 3% off your order. Or want 3.3% cash back for even more savings? Use bonus code "bonus" and get 3.3% credit in your account for future purchases This is for a limited time and the discount/bonus codes may be changed or removed at any time. The discount / bonus is provided by Markee Dragon Game Codes and we are an authorized CCP reseller. Codes delivered in 20 minutes or less. Twitter: http://twitter.com/markeedragon Want to Try EVE for free? Get it here: http://secure.eveonline.com/signup/?invc=d6baec26-231d-4ced-9cd2-1a8b3713d72d&action=buddy [!nojob] Want to get rid of your day job and be your own boss? Markee Dragon is sharing how he does it with a step by step guide to independence. Get it here: http://jedimarketingtricks.com/ultimate/ Join me and your favorite streamers! Put my 10+ years of experience to work for YOU. Learn how to start generating income while playing your favorite games! I include everything you need to know to get started PLUS plenty of support for when you get stuck! Join us for chat in Discord https://discord.gg/markeedragon Discord is what we use for in game chat and voice comms. This is a simulcast of http://twitch.tv/markeedragon . You can watch here live on YouTube and talk in chat. but for the giveaways mentioned on the show those currently only work in Twitch chat. You do not have to watch on Twitch. You only need to be in the Twitch chat to get in on the giveaways. WTFast is what I use to improve my connection to EVE. I get at least a 20% improvement at all times. Try it here: http://www.wtfast.com/markeedragon Videos How to convert Loyalty Points This video shows how we decided what items to use. Items Sold. https://www.youtube.com/watch?v=rnv4eW9hwP0 What worked Successful conversion of 1m LP to 1.5b ISK in 13 days. https://www.youtube.com/watch?v=eiGEj4XhKt0 Hauling Introduction https://www.youtube.com/watch?v=7NjY9aU-uBQ Hauling is a great secondary income. Market Blue Line Hauling is a great secondary income. EVE Sites Mentioned on the Show EVE Guides and Ship Fits: http://news.markeedragon.com/category/game-guides-how-to/eve-online-guides/ Moose Army Corp - My Null Corp I am a member of. http://moose.army Airhogs - The best all around corp and great for new players. I am also a member http://docs.google.com/document/d/1cCPjgTfOxMN7JpagSs5iUCyES2OalT5j6O4zaP5qVNw/edit?usp=sharing LP Store Conversion See what LP items are currently worth on the market. https://www.fuzzwork.co.uk/lpstore/ Daopa's LP Stores Database LP store items information http://www.ellatha.com/eve/LP-Stores EVE Assets Manager Find your stuff. Know where your money is sitting! http://eve.nikr.net/jeveasset EVE Markets Market history data. http://eve-markets.net/ EVEPraisal Quick values for your loot and other market actions. http://evepraisal.com/ EVE Maps All kinds of map related information. http://evemaps.dotlan.net/ Deepsafe https://deepsafe.xyz Excellent crowed sourced information on cosmic signatures. All explorers should use this. EVE University EVE Wiki http://wiki.eveuniversity.org/Main_Page Live shows Schedule: https://docs.google.com/spreadsheets/d/1zQZoKQnzGRgWXBefzGKlyfDppGQWzJy6PafWm-4c4sQ/pubhtml Music by Monstercat http://www.monstercat.com
Views: 1150 Markee Dragon Gameplay
Views: 11497 Max Keiser TV
This video demonstrates a brief overview of the stealth bomber ships (more specifically, in this case, the Nemesis) and will hopefully help someone who is just starting out in their bombing career know a bit more about the ship and what it is capable of. In the future, we hope to make similar videos that are more in depth in each specific point brought up during this lesson. Feel free to post any correction to errors we may have made in the comments below and thanks for watching.
Views: 2896 3rdEraGuild
The Wii U had a good run but now the Nintendo Switch is dominating. Let's take a look at my Top 10 Wii U Games that has some classics on this console. Check out the new merch! https://theyetee.com/collections/the-completionist Subscribe: http://bit.ly/SubscribeThatOneVideoGamer The Wii U is met with praise and criticism, but no matter what it was innovative and that is what Nintendo does best. From this console we had some amazing hits, with games from franchises we have not seen in years to even a new IP that carried over to the Nintendo Switch. Let me know what are your top 10 Wii U games below! Support Our Patreon: https://www.patreon.com/thecompletionist Watch Us On Twitch: https://www.twitch.tv/thecompletionist Find Us On Reddit: http://bit.ly/TheCompletionist_RD Follow Us On Twitter: http://bit.ly/TheCompletionist_TW Like Us On Facebook: http://bit.ly/TheCompletionist_FB Follow Us On Instagram: http://bit.ly/TheCompletionist_IG Completionist Merchandise: http://bit.ly/BuyOurMerch The Completionist Theme By Elite Ferrex - http://eliteferrex.bandcamp.com Watch more Top 10 and video game reviews like my Top 10 Wii U Games on my channel below | The Completionist https://www.youtube.com/c/ThatOneVideoGamer
Views: 214116 The Completionist
Catch Critical Role live Thursdays at 7PM PT on Twitch: https://goo.gl/D9fsrS Thanks to @CRTranscript and all the #critters for closed captions! Listen to the Critical Role podcast: https://goo.gl/jVwPBr Tary's past catches up with him, as Vox Machina find themselves racing towards the city of Deastok. Thanks Backblaze! https://bitly.com/BackblazeCriticalRole Thanks to our friends at Wyrmwood Gaming for sponsoring Critical Role! Check out their handcrafted goods at http://www.wyrmwoodgaming.com For more RPGs we love, go to http://bit.ly/GS_RPG Music and Sound by Syrinscape. https://store.syrinscape.com/what-is-syrinscape/?critatt Visit us on http://geekandsundry.com Subscribe to Geek and Sundry: http://goo.gl/B62jl Join our community at: http://geekandsundry.com/community Twitter: http://twitter.com/geekandsundry Facebook: http://facebook.com/geekandsundry Instagram: http://instagram.com/geekandsundry Google+: https://plus.google.com/+GeekandSundry/
Views: 729096 Geek & Sundry
http://CppCon.org — Presentation Slides, PDFs, Source Code and other presenter materials are available at: https://github.com/CppCon/CppCon2018 — Many people say that simple code is better code, but fewer put it into practice. In this talk I’ll spend a little time on why simpler is better, and why we resist simplicity. Then I’ll provide some specific approaches that are likely to make your code simpler, and discuss what you need to know and do in order to consistently write simpler code and reap the benefits of that simplicity. — Kate Gregory Gregory Consulting, Partner Kate Gregory has been using C++ since before Microsoft had a C++ compiler. She writes, mentors, codes, and leads projects, in both C++ and .NET, especially for Windows. Kate is a Microsoft Regional Director, a Visual C++ MVP, has written over a dozen books, and speaks at conferences and user groups around the world. Kate develops courses on C++, Visual Studio, and Windows programming for Pluralsight. — Videos Filmed & Edited by Bash Films: http://www.BashFilms.com
Views: 29027 CppCon
THE SUPERHERO IN YOU part 2 My video cut off before I could mention your animal oracle cards... these are the cards I got. Your card: KIWI - Do a walking meditation each day for a week. Your opposite energy card: EMU - This is a good time to go on an adventure. The environmental energy card: CAMEL - Trust that you have the resources to get through the challenges before you. Ultra Violet Dove For the highest, greatest good of all. .. Please listen to your own inner guidance. Love & joy We are all brothers and sisters sharing this beautiful earth. This is meant to help bring clarity and broaden your perspective on the question you are wondering about. Always use your own intuition and common sense when dealing with important issues.. I hope to show that we are all psychic and intuitive. We all have guidance and love. Maybe you will start to feel a little extra spark in your daily life just by beginning to notice the amazing things that surround you. Mystery and miracles hidden in plain sight. Let's all wake up together. Love is key. Thank you for joining me. Blessings to you all. Please check out your sun, moon, and rising sign to find which resonates the best with you this month.
Views: 125 Ultra Violet Dove
00:00:00 - Muppet Teaser 00:03:02 - eprint 00:05:07 - Facebook Login Walkthrough 00:14:34 - Flask Sessions 00:28:56 - SQL 00:29:44 - Databases 00:36:55 - SQLite 00:39:01 - Database Operations 00:45:32 - SQL Data Types 00:54:33 - Optimizing the Database 01:06:13 - phpLiteAdmin 01:12:42 - Constraints 01:18:01 - Creating a Database 01:21:58 - sqlite3 01:25:14 - SQL in Python 01:33:15 - SQL Injection Attacks 01:38:50 - Adding SQL to Flask 01:43:31 - C$50 Finance
Views: 37129 CS50
While at the CG I was interdicted and attacked by players I have never heard of before.
Views: 342 PaulAtWar
New Video: https://www.youtube.com/watch?v=7gkqTLfndsc
Views: 17334 BigSakos Playground
"comments and tips in well-mannered statement, otherwise it will result in removal and user ban." -------------------------------------- Faction: Angel / Blood Raider / Gurista / Serpentis Mission type: Encounter Space type: Normal Space - Can warp to member of fleet in any pocket directly, but cannot warp to any previous pockets directly. Damage Dealt: All kinds Recommended damage dealing: Explosive or Kinetic (based on random spawn) for the first pocket, Kinetic for the rest. Thermal EM do minimal damage. Web/scramble: none Pocket 1 (warp in) Acceleration gate is locked and 20 KM away from warp-in. Note: Warping out may cause a new Angel or Serpentis spawn with the same number of cruisers/battleships. Group (Auto-aggro): (55 KM) 4 x Cruiser (Angel: Liquidator/Marauder) / (Serpentis) 5 x Battleship (Angel: Malakim/Nephilim/Warlord/) (Target Painter) / (Serpentis) Nephiliim orbit at 31k, Malakim/warlord orbit at 7k-8k Last battleship killed drops the key to unlock the gate. Key will not be consumed on use. The key is labeled "Gate Key". OR 5 x Battlecruser (Serpentis: Corelatis Squad Leader/ Corelum Cheif Guard) (Damp) 4 x Battleship (Serpentis: Core Admiral/Core High Admiral) Pocket 2 Acceleration gate is not locked and 29 KM away from warp-in. Group (Auto-aggro): (45-60 KM) 1 x Named Battlecruiser (Anire Scarlet) Heavy EM/Thermal She warps out almost immediately 5 x Battlecruiser (Blood Raider: Arch Sage) / (Gurista: Executor) 4 x Battleship (Blood Raider: Monsignor)/ (Gurista: Exterminator) (Heavy Jamming) Jam range 100km The Gurista battleships will do a heavy amount of jamming. Anire Scarlet is flying an Absolution and does heavy EM/Thermal damage. She will run into the next pocket if attacked or ignored for 10 minutes. This room will clear and respawn a new group upon exiting (does not respawn every time). With better SPs/tier, makes bounty-farming lucrative. (Read more below.) + Salvage possible. Pocket 3 Acceleration gate is not locked and 19 KM away from warp-in. Group 1 (Auto-aggro): (27 KM) 1 x Named Battlecruiser (Anire Scarlet) Heavy EM/Thermal Again, Anire Scarlet does high EM/Thermal damage and runs away to the next pocket. Group 2 (Auto-aggro): (31-33 KM) 3 x Frigate (Serpentis) 4 x Battleship (Gurista- Pith Conquistador) OR 5 x Cruiser (Gurista: Pithum Silencer) 6 x Battleship (Serpentis: Core Port Admiral/Core Rear Admiral) Last ship or battleship killed spawns final group. Note: Spawn group may aggro drones. Pull your drones in before triggering it. Spawn 1 (Auto-aggro): (35 KM) 4 x Battleship (Gurista: Pith Eliminator/Pith Extinguisher) (Eliminator: Heavy Sensor Dampening) OR 3 Battleship (Serpentis: Core Flotilla Admiral/Core Vice Admiral) (Heavy Sensor Dampening) There's a chance that if you have a friend warp into the room after the spawn appears, the spawn will disappear and a new spawn of 6 BS and 6 cruisers will appear. There's also a chance that this spawn Group 2 will appear if you warp out and back after killing Spawn 1, AND that it will be followed by a second Spawn 1. If you can kill Scarlet before she warps off to the next gate and before reaching the final room, she will drop an implant. Pocket 4 Group 1 (Auto-aggro): (55 KM) 2 x Elite Frigate (Gurista: /Dire Pithi Imputor/) (Web) 3 x Elite Cruiser (Gurista: /Dire Pithum Abolisher/Dire Pithum Annihilator) (Jamming) 4 x Battlecruiser (Gurista: Enforcer/Executor) or there's a chance to spawn angel counterparts. Group 2 (Auto-aggro): (70-80 KM) 1 x Named Battlecruiser (Anire Scarlet) Heavy EM/Thermal 1 x Angel Heavy Missile Battery 1 x Blood Heavy Missile Battery 1 x Guristas Cruise Missile Batteries [sic] Heavy Kinetic 1 x Serpentis Cruise Missile Battery Heavy Thermal Group 3 (Auto-aggro): (100 KM) 4 x Battlecruiser (Serpentis: Corelatis Squad Leader/Corelatis Wing Leader) 4 x Battleship (Serpentis: Core Baron/Core Commodore) Despite Anire Scarlet's 5 million ISK bounty and being mission completion trigger, she is no better tanked than any battlecruiser and is very easy to kill. 0-2 T1 modules in her wreck, nothing special. Last ship killed spawns next group. Again, spawns may target drones. Keep close watch on them; they trend to go after the sentry turrets if left on auto. Spawn 1 4 x Battleship (Serpentis: Core Port Admiral/Core Rear Admiral) OR 4 x Battleship (Blood Raiders: Corpus Oracle/Apostle) Last ship killed spawns next group. They spawn above Scarlet's Station, so if you're in a slow boat, keep the station in range. There's a chance that if you have a friend warp into the room after the spawn appears, the spawn will disappear and a new spawn of multiple BS and BC will appear. If you warp off after Spawn 1 has appeared but before Spawn 2, there's a chance that the Group 1 (Angels or Guristas) you did NOT just kill will spawn in addition to Spawn 1. ..youtube being gay, i cant list remaining strategy notes http://eve-survival.org/wikka.php?wakka=DreadPirateScarlet4
Views: 5174 Krostik K
We are here to show unconditional love! Jesus replied: “‘Love the Lord your God with all your heart and with all your soul and with all your mind'.This is the first and greatest commandment. And the second is like it: ‘Love your neighbor as yourself'. All the Law and the Prophets hang on these two commandments.” Matthew 22:37-40
Views: 19 Chocolate Healer
EVE Online Small Gang PvP Space Men Voi Lutois Ships: Gila Slicer Firetail Garmur Praxis Jaguar Confessor Gnosis Brutix Omen Navy Music: https://www.youtube.com/user/TheHipHopFix syndrome - sesh syndrome - islands syndrome - clouds syndrome - my love syndrome - skylight syndrome - liberty syndrome - boogie syndrome - came true syndrome - grimey
Views: 670 Voi Lutois