Oracle SQL Practical question with answer extract names from mail id using SQL function

  Рет қаралды 31,161

Siva Academy

Siva Academy

Күн бұрын

Пікірлер: 35
@_sourav_
@_sourav_ 5 жыл бұрын
Sir your videos are excellent.After watching Every video I get to learn a new concept.Pls upload more and more videos
@SivaAcademy
@SivaAcademy 5 жыл бұрын
@Sourav, 🙏🙏🙏 I'm glad it helped, It's my pleasure. Thanks for your comment :-)..... Sure will be uploading more videos, Please stay tuned................Siva
@DileepKumar-ms1nz
@DileepKumar-ms1nz Жыл бұрын
Hi Shiva, Your videos are wonderful help us .Please you make a video for below one Source Target ID Col ID Col 1 A 1 A 2 B 2 BB 3 C 3 CCC
@yogeshzore5766
@yogeshzore5766 Жыл бұрын
Very useful sir👍
@SivaAcademy
@SivaAcademy Жыл бұрын
My pleasure
@vipul1177
@vipul1177 6 жыл бұрын
Hi Siva, Your videos are the best videos to understand any topics. Have a request, can you provide the script(queries) in any separate sheet in the description or any other place?
@SivaAcademy
@SivaAcademy 6 жыл бұрын
Thanks for your comment Vipul, From next video onward, i will share the script. Thanks, Siva
@vipul1177
@vipul1177 6 жыл бұрын
@@SivaAcademy Thank you....
@amongUs-du6oi
@amongUs-du6oi 3 жыл бұрын
Thanks for such a wonderful video! Really appreciate
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Welcome bro
@nimmikcherian3242
@nimmikcherian3242 3 жыл бұрын
Ur awesome sir👌👌😍😍
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Thank you
@mayamillaimanthiramillai3231
@mayamillaimanthiramillai3231 3 жыл бұрын
Hi bro, please post brief explanation for regular expressions. Why do we use and types
@krishnareddy2885
@krishnareddy2885 6 жыл бұрын
Pls Do one Video on RegExp concept sir....
@SivaAcademy
@SivaAcademy 6 жыл бұрын
Sure Krishna, I will do soon, We cannot cover full concept of regexp in single video, but i will try to post in a series on videos soon.
@shashank2004
@shashank2004 6 жыл бұрын
Awsome video sir, please make a video on explain plan.
@SivaAcademy
@SivaAcademy 6 жыл бұрын
Sure Shashank, I am planning to do performance tuning related videos, will cover in detail about explain plan as part of tuning video series. Thanks, Siva
@premgona5587
@premgona5587 6 жыл бұрын
Siva... When you are going to make videos on performance tuning... I would suggest to add in interview perspective... I was asked by an interviewer... Question is.. What are the things that you check in execution plan? What are tuning techniques you follow?
@SivaAcademy
@SivaAcademy 6 жыл бұрын
Sure Prem, I will add, Since this is very vast topic, i am listing down the points to make it as meaningful videos for easier understanding. Otherwise, it wont be interesting topic to learn, and to watch, however i will try my level best to add videos easy to understand with respect to sql/plsql performance tuning and related concepts.
@siprabehera4680
@siprabehera4680 4 жыл бұрын
Hi ..i want to insert same record in next row of a table wherever in one colum value ll be there more than one with $ dearator
@SivaAcademy
@SivaAcademy 4 жыл бұрын
Replied via email, please check
@kalpeshpatil4321
@kalpeshpatil4321 4 жыл бұрын
Hi Shiva, as usual this video was also new learning for me. But I've one request, can you please make video on regular expression with simple example and simple explanation. It will be very helpful for me to understand. thanks in advance.
@SivaAcademy
@SivaAcademy 4 жыл бұрын
sure bro, please stay tuned
@sumeetpalit6362
@sumeetpalit6362 3 жыл бұрын
Sir can you please make videos on regular expressions
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Yeah, please stay tuned
@kranthikumar6043
@kranthikumar6043 2 жыл бұрын
How did u get middle name im confused ...7-4=3,the. Then the Length will be three
@ramojireddy2548
@ramojireddy2548 2 жыл бұрын
How to print only k?? in siva.k.academy
@malliarjun5250
@malliarjun5250 3 жыл бұрын
Sir you are not posting videos from last 3 weeks
@SivaAcademy
@SivaAcademy 3 жыл бұрын
Yes bro,due to some urget project deliverables, I was not able to record, I will be restarting from this week, please stay tuned
@premgona5587
@premgona5587 6 жыл бұрын
I don't talk anything about this video as I know that we have regular expressions for such type of requirements... I believe WITH clause in function has been introduced in 12c release1
@SivaAcademy
@SivaAcademy 6 жыл бұрын
Yes, you are right, functions in with clause are allowed from 12c only kzbin.info?o=U&video_id=rJuRWv7k-zo
@azharsha3476
@azharsha3476 3 жыл бұрын
Hi bro please send the regular expression videos link
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН
How Strong Is Tape?
00:24
Stokes Twins
Рет қаралды 96 МЛН
It works #beatbox #tiktok
00:34
BeatboxJCOP
Рет қаралды 41 МЛН
How to Read an Execution Plan: Databases for Developers: Performance #1
9:34
Difference between Case and Decode
10:14
Kishan Mashru
Рет қаралды 22 М.
Querying 100 Billion Rows using SQL, 7 TB in a single table
9:07
Arpit Agrawal (Elastiq.AI)
Рет қаралды 60 М.
Substr and Instr in Oracle|Extracting data from String
15:28
Tech Coach
Рет қаралды 24 М.
Ecolab SQL Interview Question - SUBSTRING() and CHARINDEX() Functions
9:57
Cloud Challengers
Рет қаралды 4,3 М.
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН