- 65
- 487 260
Sridhar Raghavan
เข้าร่วมเมื่อ 31 มี.ค. 2012
Oracle PLSQL
Oracle Row level trigger to check valid email id Session 6
Oracle SQL PLSQL and Unix Shell Scripting
มุมมอง: 3 635
วีดีโอ
Oracle Row Level Triggers follows clause Session 8
มุมมอง 1.6K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle Row Level Triggers when condition clause Session 7
มุมมอง 2.6K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle Row level Triggers Example Programs Session 5
มุมมอง 2.4K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle Difference between Statement level and Row Level Trigger Session 3
มุมมอง 2.9K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle Statement level Triggers Creating Audit Triggers Session 2
มุมมอง 2K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle Statement Level Triggers Session 1
มุมมอง 4.1K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle execute immediate dynamic sql update returning into with and without using bind argument Part
มุมมอง 3.2K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle execute immediate dynamic sql select with and without using bind argument Part 5
มุมมอง 2.6K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle execute immediate dynamic sql procedure in parameter Part 6
มุมมอง 2.3K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle execute immediate dynamic sql procedure in and out parameters Part 7
มุมมอง 3.6K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle execute immediate dynamic sql insert with and without using bind argument Part 2
มุมมอง 6K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle execute immediate dynamic sql delete with and without using bind argument Part 4
มุมมอง 1.4K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle execute immediate dynamic sql passing null value to bind argument Part 9
มุมมอง 1.1K7 ปีที่แล้ว
Oracle SQL PLSQL and Unix Shell Scripting
Oracle dynamic sql select while opening ref cursor sys ref cursor Part 8
มุมมอง 4.7K7 ปีที่แล้ว
Oracle dynamic sql select while opening ref cursor sys ref cursor Part 8
Oracle execute immediate dynamic sql DDL commands Part 1
มุมมอง 9K7 ปีที่แล้ว
Oracle execute immediate dynamic sql DDL commands Part 1
Unix shell script to read a file line by line and read word by word from each line
มุมมอง 25K7 ปีที่แล้ว
Unix shell script to read a file line by line and read word by word from each line
Nth highest salary of an employee and Top 3 salaried employees
มุมมอง 4.4K7 ปีที่แล้ว
Nth highest salary of an employee and Top 3 salaried employees
Unix shell script to read password but password is not displayed on the screen
มุมมอง 5K7 ปีที่แล้ว
Unix shell script to read password but password is not displayed on the screen
Oracle Find duplicate records and delete the duplicated records retaining one of duplicated value
มุมมอง 28K7 ปีที่แล้ว
Oracle Find duplicate records and delete the duplicated records retaining one of duplicated value
Oracle Decode and case statement inside insert and insert all statement
มุมมอง 2.8K7 ปีที่แล้ว
Oracle Decode and case statement inside insert and insert all statement
Advanced unix String handling Shortest longest substring match from front or back ## %%
มุมมอง 8247 ปีที่แล้ว
Advanced unix String handling Shortest longest substring match from front or back %%
Oracle regular expression part 3 replace a substring regexp replace
มุมมอง 17K7 ปีที่แล้ว
Oracle regular expression part 3 replace a substring regexp replace
Oracle regular expression part 1 regexp like
มุมมอง 53K7 ปีที่แล้ว
Oracle regular expression part 1 regexp like
Oracle regular expression part 2 extracting substring regexp substr
มุมมอง 31K7 ปีที่แล้ว
Oracle regular expression part 2 extracting substring regexp substr
Advanced unix String handling substr extraction find length of string array
มุมมอง 2.3K7 ปีที่แล้ว
Advanced unix String handling substr extraction find length of string array
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
finally I understand regex patterns, thanks!
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
Using where condition we write
Ex:delete from empire where id=2
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