dbOS Talks
dbOS Talks
  • Видео 162
  • Просмотров 100 274
SQL rownum vs. rowid | rownum and rowid
This is the 1st video in a playlist called "SQL concepts clarified", and here we'll learn the difference of rownum & rowid in Oracle SQL.
// Windows Tips & Tricks
ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I
// Microsoft Excel Tutorial
ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA
// Excel for Data Analysis
ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso
// SQL Tutorial
ruclips.net/p/PL0fAqYdWDpmhT0tCalNs1wlw4DWltoSOL
// Serious Fun with SQL
ruclips.net/p/PL0fAqYdWDpmhSI_qWpZnKWjE0c-W7zWiO
// Notepad++ Tips & Tricks
ruclips.net/p/PL0fAqYdWDpmjTXtT01-JZ7JujlnJgnukp
// Channel URL
ruclips.net/user/dbostalks
Просмотров: 4

Видео

FLOOR function in SQL | SQL FLOOR function7:30FLOOR function in SQL | SQL FLOOR function
FLOOR function in SQL | SQL FLOOR function
Просмотров 19День назад
This video is in the playlist called "Math using SQL", and here we'll learn about the FLOOR function. In a previous video, we talked about the CEIL function. In this one, we'll talk about its counterpart. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/...
CEIL function in SQL | SQL CEIL function8:51CEIL function in SQL | SQL CEIL function
CEIL function in SQL | SQL CEIL function
Просмотров 1914 дней назад
This video is in the playlist called "Math using SQL", and here we'll learn about the CEIL function in SQL. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYdWDpmhT0tCalNs1wlw4DWltoS...
MIN & MAX in SQL | MIN, MAX functions in SQL8:01MIN & MAX in SQL | MIN, MAX functions in SQL
MIN & MAX in SQL | MIN, MAX functions in SQL
Просмотров 3321 день назад
This video is in the playlist called "Serious fun with SQL", and here we'll learn about the aggregate functions MIN & MAX in SQL. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYdWD...
Division Techniques in Excel formulas | Division in Excel9:30Division Techniques in Excel formulas | Division in Excel
Division Techniques in Excel formulas | Division in Excel
Просмотров 11Месяц назад
We are in the the playlist Excel Formulas, and here we will learn how to do division in Excel formulas. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYdWDpmhT0tCalNs1wlw4DWltoSOL /...
Multiplication Techniques in Excel formulas | Multiplication in Excel8:05Multiplication Techniques in Excel formulas | Multiplication in Excel
Multiplication Techniques in Excel formulas | Multiplication in Excel
Просмотров 25Месяц назад
We are in the the playlist Excel Formulas, and here we will learn how to do Multiplication in Excel formulas. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYdWDpmhT0tCalNs1wlw4DWlt...
Concatenate in Excel | Concatenation in Excel9:17Concatenate in Excel | Concatenation in Excel
Concatenate in Excel | Concatenation in Excel
Просмотров 16Месяц назад
We are in the the playlist Excel Formulas, and here we will learn how to concatenate in Excel. Concatenation is the process of joining strings. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.ne...
Addition and Subtraction of dates | Addition and subtraction in Excel7:31Addition and Subtraction of dates | Addition and subtraction in Excel
Addition and Subtraction of dates | Addition and subtraction in Excel
Просмотров 13Месяц назад
We are in the the playlist Excel Formulas, and here we will learn how to do addition and subtraction of dates in Excel formulas. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYdWDp...
subtraction in Excel9:02subtraction in Excel
subtraction in Excel
Просмотров 14Месяц назад
This is the second video of the playlist Excel Formulas, and here we will learn how to do subtraction in Excel formulas. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYdWDpmhT0tCal...
Addition Techniques in Excel formulas | Addition in Excel10:08Addition Techniques in Excel formulas | Addition in Excel
Addition Techniques in Excel formulas | Addition in Excel
Просмотров 132 месяца назад
This is the first video of the playlist Excel Formulas, and here we will learn how to do addition in Excel formulas. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYdWDpmhT0tCalNs1w...
using reserved words in SQL8:07using reserved words in SQL
using reserved words in SQL
Просмотров 282 месяца назад
This video is part of the playlist called "SQL mistakes to avoid", and here we will learn to avoid using a reserved word for other purposes. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p...
Using TRUNC on dates in SQL | TRUNC in SQL9:15Using TRUNC on dates in SQL | TRUNC in SQL
Using TRUNC on dates in SQL | TRUNC in SQL
Просмотров 552 месяца назад
This video is in the playlist called "Handling Dates in SQL", and in this video, we will learn the different uses of the TRUNC function in dates. TRUNC is short for truncate. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDis...
Wildcard in SQL | Wildcard characters in SQL6:41Wildcard in SQL | Wildcard characters in SQL
Wildcard in SQL | Wildcard characters in SQL
Просмотров 322 месяца назад
This video is in the playlist called "Serious fun with SQL", and here we'll learn about the wildcard characters used in Oracle SQL. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso // SQL Tutorial ruclips.net/p/PL0fAqYd...
Knowing the day in SQL | calendar day in SQL8:03Knowing the day in SQL | calendar day in SQL
Knowing the day in SQL | calendar day in SQL
Просмотров 453 месяца назад
This video is in the playlist called "Handling Dates in SQL", and in this video, we will learn how to know the day of a date. This can be used to the current date, as well as dates in the past or future. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/P...
Opposite of greater than in SQL | danger of using greater than7:32Opposite of greater than in SQL | danger of using greater than
Opposite of greater than in SQL | danger of using greater than
Просмотров 163 месяца назад
This video is part of the playlist called "SQL mistakes to avoid", and here we'll learn about another mistake that will not be easily detected if we are relatively new to SQL. // Windows Tips & Tricks ruclips.net/p/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I // Microsoft Excel Tutorial ruclips.net/p/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA // Excel for Data Analysis ruclips.net/p/PL0fAqYdWDpmjP2hRBitkfWOIvNDi...
months_between in SQL | Subtract months in SQL5:55months_between in SQL | Subtract months in SQL
months_between in SQL | Subtract months in SQL
Просмотров 203 месяца назад
months_between in SQL | Subtract months in SQL
Convert year to words | Year to words in SQL6:32Convert year to words | Year to words in SQL
Convert year to words | Year to words in SQL
Просмотров 73 месяца назад
Convert year to words | Year to words in SQL
Add months in SQL | ADD_MONTHS in SQL7:25Add months in SQL | ADD_MONTHS in SQL
Add months in SQL | ADD_MONTHS in SQL
Просмотров 364 месяца назад
Add months in SQL | ADD_MONTHS in SQL
Using dates in an equation11:16Using dates in an equation
Using dates in an equation
Просмотров 54 месяца назад
Using dates in an equation
DO's and DON'Ts for dates15:42DO's and DON'Ts for dates
DO's and DON'Ts for dates
Просмотров 124 месяца назад
DO's and DON'Ts for dates
Today's Date in SQL | System Date in SQL8:53Today's Date in SQL | System Date in SQL
Today's Date in SQL | System Date in SQL
Просмотров 374 месяца назад
Today's Date in SQL | System Date in SQL
Ampersand in SQL | using Ampersand in SQL6:44Ampersand in SQL | using Ampersand in SQL
Ampersand in SQL | using Ampersand in SQL
Просмотров 1354 месяца назад
Ampersand in SQL | using Ampersand in SQL
accidental alias in SQL8:02accidental alias in SQL
accidental alias in SQL
Просмотров 105 месяцев назад
accidental alias in SQL
Divisor is zero in SQL | Divisor equals zero9:31Divisor is zero in SQL | Divisor equals zero
Divisor is zero in SQL | Divisor equals zero
Просмотров 285 месяцев назад
Divisor is zero in SQL | Divisor equals zero
SUM function in SQL | SQL SUM function15:04SUM function in SQL | SQL SUM function
SUM function in SQL | SQL SUM function
Просмотров 295 месяцев назад
SUM function in SQL | SQL SUM function
Use of DD in SQL | DD not DDD in SQL8:48Use of DD in SQL | DD not DDD in SQL
Use of DD in SQL | DD not DDD in SQL
Просмотров 175 месяцев назад
Use of DD in SQL | DD not DDD in SQL
Find special characters in Excel | Search special characters in Excel7:51Find special characters in Excel | Search special characters in Excel
Find special characters in Excel | Search special characters in Excel
Просмотров 2646 месяцев назад
Find special characters in Excel | Search special characters in Excel
Excel Sparklines5:30Excel Sparklines
Excel Sparklines
Просмотров 436 месяцев назад
Excel Sparklines
Use DECODE in SQL | SELECT DECODE in SQL10:39Use DECODE in SQL | SELECT DECODE in SQL
Use DECODE in SQL | SELECT DECODE in SQL
Просмотров 556 месяцев назад
Use DECODE in SQL | SELECT DECODE in SQL
Generate random number in SQL | Generate random value in SQL10:56Generate random number in SQL | Generate random value in SQL
Generate random number in SQL | Generate random value in SQL
Просмотров 316 месяцев назад
Generate random number in SQL | Generate random value in SQL

Комментарии

  • @TTLIFEBD
    @TTLIFEBD Месяц назад

    🌷

  • @sowmiyap7190
    @sowmiyap7190 4 месяца назад

    Hi sir Im sowmiya from tamilnadu Im having one assignment about er diagram Can you send me your mail id so that I can send you my questions

    • @dbOSTalks
      @dbOSTalks 4 месяца назад

      Hi Sowmiya, Thanks for dropping by. Sorry 'cause I currently have no bandwidth to answer your questions via email due to my other personal/work commitments. You can post a question in this comment, and I will try to answer it. Otherwise, I do believe a web search can help you, too.

    • @sowmiyap7190
      @sowmiyap7190 4 месяца назад

      ok sir ,i finished all the question.now i want to confirm whether my er diagram correct or not -verification only@@dbOSTalks

    • @sowmiyap7190
      @sowmiyap7190 4 месяца назад

      i cant attach output here@dbOSTalks

  • @j.k6580
    @j.k6580 6 месяцев назад

    thank you

    • @dbOSTalks
      @dbOSTalks 6 месяцев назад

      You're welcome. Please consider subscribing.

  • @Yalla_Balaji
    @Yalla_Balaji 6 месяцев назад

    it helped

    • @dbOSTalks
      @dbOSTalks 6 месяцев назад

      Thanks. Pls consider subscribing to the channel.

  • @Tranquil.pathshala.withRitesh
    @Tranquil.pathshala.withRitesh 8 месяцев назад

    Good👍

  • @tejasdongare9468
    @tejasdongare9468 9 месяцев назад

    How to on sir

    • @dbOSTalks
      @dbOSTalks 9 месяцев назад

      You can press Ctrl+Space

  • @lafamilia5353
    @lafamilia5353 10 месяцев назад

    Thanks

  • @MyStudio-io3so
    @MyStudio-io3so 10 месяцев назад

    Good video. When I export my animations as a GIF it dose not play when I open it. GIFs I have downloaded from online play when I open it in windows photo viewers. GIFs don't require any special app to open. Any photo viewer should play it. Something is wrong with LibreOffice

    • @dbOSTalks
      @dbOSTalks 10 месяцев назад

      Hi, Maybe you're right. My LibreOffice knowledge is quite basic. I'm sure there are blogs/vlogs that could help you on that

  • @lafamilia5353
    @lafamilia5353 10 месяцев назад

    Love it! ❤️

    • @dbOSTalks
      @dbOSTalks 10 месяцев назад

      Thank you!!

  • @user-up2gz4lv2k
    @user-up2gz4lv2k 11 месяцев назад

    How do you record vocals on here? I know how to on the mobile app but not on windows 10

    • @dbOSTalks
      @dbOSTalks 11 месяцев назад

      Hi I haven't tried doing that on this app. Sorry about that.

  • @uzmafarazfaraz222
    @uzmafarazfaraz222 Год назад

    How to unmerge the document

    • @dbOSTalks
      @dbOSTalks Год назад

      Hi, Sorry, I don't quite understand the question. The video is about what to do when: 1) you have no keyboard 2) you have no mouse

  • @AmbikaSah-vo1ho
    @AmbikaSah-vo1ho Год назад

    Thanks man

    • @dbOSTalks
      @dbOSTalks Год назад

      Thanks Ambika. Shukriya/Nandri.

  • @jamesjennings8574
    @jamesjennings8574 Год назад

    That worked for me -- Thanks!

    • @dbOSTalks
      @dbOSTalks Год назад

      Hi James Glad to be able to help

  • @Mickard
    @Mickard Год назад

    WOW! Great tip

  • @sujathakandavara9752
    @sujathakandavara9752 2 года назад

    How can we convert declimal number like 9876.56 using select '9876',(to_char(to_date('9876','j'),'jsp')) from dual ?

    • @dbOSTalks
      @dbOSTalks 2 года назад

      Hi Sujatha, You can try this workaround...although others might have a better way: with qry as ( select 9876.56 num from dual) select upper(to_char(to_date(trunc(num),'j'),'jsp')) || ' point '|| upper(to_char(to_date((num-trunc(num))*100,'j'),'jsp')) num_in_words from qry;

  • @gani3326
    @gani3326 2 года назад

    How can we apply '9867 'code to the Entire Column?

    • @dbOSTalks
      @dbOSTalks 2 года назад

      Hi Yogesh, You can use INSTR function to find a digit's location/position in the string. However, INSTR returns the position from the left. The below can be one workaround approach. Example: 87654 If we want to know the position of '7' from the right, we can use this: pos_r = <length_of_string> - <INSTR value> + 1 = 5-2+1 = 4 And then, we can have logic like this, where pos_r is the variable for the position from the right... IF pos_r = 4, append with 'THOUSAND' for that digit/character. IF pos_r = 7, append with 'MILLION' for that digit/character.

  • @ramoncervantes4328
    @ramoncervantes4328 2 года назад

    It might be my phone but is there a way to make the sound louder. I see other videos with louder/clearer sounds. I do not know how they make that. Might with the mike/sound equipment/voice. Thanks brod.

    • @dbOSTalks
      @dbOSTalks 2 года назад

      Duly noted, brod Thanks

  • @merryberriestagala7643
    @merryberriestagala7643 2 года назад

    thanks kuya,ingat po

  • @dbOSTalks
    @dbOSTalks 2 года назад

    This is the 1st video in a playlist called "Beginner Office Skills". This series is aimed at equipping a beginner with useful skills involving short but important office tasks. Please feel free to subscribe. Thanks.

  • @olutunbi
    @olutunbi 2 года назад

    Thanks bro. Great job

    • @dbOSTalks
      @dbOSTalks 2 года назад

      You're welcome, bro.

    • @dbOSTalks
      @dbOSTalks Год назад

      You're welcome, Dotman.

  • @alisha_singapore2180
    @alisha_singapore2180 2 года назад

    Ate,dq po mhnap

    • @dbOSTalks
      @dbOSTalks 2 года назад

      Maraming salamat!

  • @dbOSTalks
    @dbOSTalks 2 года назад

    SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, DB2, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ruclips.net/video/7zkGZj1Pylo/видео.html?sub_confirmation=1

  • @dbOSTalks
    @dbOSTalks 3 года назад

    SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, DB2, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ruclips.net/video/7zkGZj1Pylo/видео.html?sub_confirmation=1

  • @boygahitv614
    @boygahitv614 3 года назад

    Here sir sending my support good sharing very informative content..

    • @dbOSTalks
      @dbOSTalks 3 года назад

      Hi boygahi tv, thanks for your support.

  • @RatedB
    @RatedB 3 года назад

    Thank you the information sending full support Ana Liza

    • @dbOSTalks
      @dbOSTalks 3 года назад

      Thanks Ana Liza (Rated B) for your support.

  • @lesliefashionista4876
    @lesliefashionista4876 3 года назад

    Sending support.... Tnx for sharing this video.

    • @dbOSTalks
      @dbOSTalks 3 года назад

      Thanks Leslie Fashionista girl.

  • @MiNDIDOL
    @MiNDIDOL 3 года назад

    Sending fullsupport from Ana Liza

    • @dbOSTalks
      @dbOSTalks 3 года назад

      Thanks MIND Gaming TV

  • @preciouslifehk
    @preciouslifehk 3 года назад

    I think I should start watching the first video so that I can can fully understand how or what to do.Your video itself will help me learn .

    • @dbOSTalks
      @dbOSTalks 3 года назад

      Thanks a lot. Much appreciated.

  • @dbOSTalks
    @dbOSTalks 3 года назад

    Hi friends, please note that the video you should watch after this intro is this: m.ruclips.net/video/dr242wq7M88/видео.html

  • @dbOSTalks
    @dbOSTalks 3 года назад

    SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is the first one in my SQL tutorial series.

  • @dbOSTalks
    @dbOSTalks 3 года назад

    SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ruclips.net/video/7zkGZj1Pylo/видео.html?sub_confirmation=1

  • @dbOSTalks
    @dbOSTalks 3 года назад

    SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ruclips.net/video/7zkGZj1Pylo/видео.html?sub_confirmation=1

  • @dbOSTalks
    @dbOSTalks 3 года назад

    SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ruclips.net/video/7zkGZj1Pylo/видео.html?sub_confirmation=1

  • @jonangilawabi649
    @jonangilawabi649 3 года назад

    Congratulations for your great channel!

    • @dbOSTalks
      @dbOSTalks 3 года назад

      Thanks much Jona !