Nice explanation... Tq

Thank you sir

Well explained 🎉

Sir pls send me any kind of material this topic pls send me help us pls sir

Nice

,

Thanks Sridhar :)

How to replace a word in case sensitive way. So UNIX will be replaced as LINUX and unix will become linux

Nice way to present, Thanks

Think you soo much 😊😊

Thanks a ton. God bless you. I just found what I was looking for.

Thanks!

Thanks!

Thanks!

Good EduVideo. Do you know how to extract .docx file from BLOB/Long Raw column of Oracle to a Windows folder? If so please share the video or link containing end to end steps.

Thanks for the video.. will it delete the other rows which are not duplicate at all.?

Thank you for this great informative video. By the way, could you please show me how to use this Regexp substr function to pull "TB" values in a column from the below example? Output TB as: 1300 150 2000 Data input example: [STORAGE][02-026-41][1300 TB] requires xyz info-publish\/00m [IMF-2-01-02-6][150 TB] trouble bravo-webcat-/\c00x [INFO][WEBHOOK][4950-606][zmf-com][2000 TB] host-\in publish-i/mox

Superb Bossssssssssssssssssssssss amazing please cont...........

Thank you very much, it was exactly what I needed to finalize an indicator.

please share the word document... i like your videos and learning a lot of new concepts...plz share the docs

It's very helpful.. but how to read Excel file into database.. can you show this also

Please share scripts

Your explanation is very clear and you are best, please teach us more...on the subject which makes us clear understanding where starting with zero knowledge also can understand....that damn clear

U r a god for the person who's looking for oracle developer

Great explanation. please help me how can I write a query if i want to delete specific duplicates not all duplicates

I love you :D

Thank you so much sir

Thanks! really helpful, can u upload new video , which has validations like no duplicate values allowed, and name starting with s.. would be really helpful

Thanks you for explaining in very easy manner.. Please make more videos on complex topic like regexp with example. It help a lot people like us....thanks again

Screen does not have clarity

in real scanio nobody will use that solution - can you show how to use plsql code to import xml file into otacle table...regards

hi, how to insert the result regexp_substr ?, im can't insert data :( , please could you explain us? i'm from chile

Great work.

finaly i got best channel about sql plsql ..super hero

does this functionality work in 19C db?

Hi Sridhar one question how long the entries will be stored in log table for refresh on commit option because u said as soon as refresh the log entries will remove

Very well explained Sridhar.

invalid directory object

Hi i just have a doubt if i am having 9 numbers in any 4 numbers are repetitive like 654777754 how to get numbers like that

thanks

Well explained thanks

Hi Mr. Sridhar , I need some assistance in creating the folder while using UTL_FILE. Can I have your email id pls.

Hi Mr.Sridhar

Hi is it possible for you to explain " How to count words in string using Regexp count function

thank you so much, it works!!

Thank you!

Error starting at line : 1 in command - declare L_FILE UTL_FILE.FILE_TYPE; L_LOCATION varchar2(100):='MYDIR'; L_FILENAME varchar2(100):='EMPLOYEES.txt'; L_TEXT varchar2(32767); begin L_FILE:=UTL_FILE.FOPEN(L_LOCATION,L_FILENAME,'r'); UTL_FILE.get_line(L_FILE,L_TEXT); dbms_output.put_line('first_line:' || L_TEXT); UTL_FILE.get_line(L_FILE,L_TEXT); dbms_output.put_line('second_line:' || L_TEXT); UTL_FILE.FCLOSE(L_FILE); end; Error report - ORA-29283: invalid file operation: nonexistent file or path [29434] ORA-06512: at "SYS.UTL_FILE", line 536 ORA-06512: at "SYS.UTL_FILE", line 41 ORA-06512: at "SYS.UTL_FILE", line 478 ORA-06512: at line 7 29283. 00000 - "invalid file operation%s" *Cause: An attempt was made to read from a file or directory that does not exist, or file or directory access was denied by the operating system. *Action: Verify file and directory access privileges on the file system, and if reading, verify that the file exists.

hi merge into releasefilemasterdataloads target table in sap hana database

I am unable to insert data in table due to trigger error how can I insert

not clear sridhar