This is how I practice, I read the question in thumbnail and try to solve on my own.. this helps a lot! Today my solution was correct!! Thank you Sir, your videos are great.
It's Amazing!!! You are sharing your knowledge with others so dedicatedly. It proves you are a man with a big heart and a beautiful mind. People like me will benefit from your video.
Hii Mr. shiva, how r u. whn I see ur new video always , I used to feel like if I dnt watch, I could miss some imp tip frm tht video and I liked the last method... Thank u so much
Hi Siva, there is 3different column and 3different table,like one table have dept id,ename, another table have prod I'd &ename column, another table has dept id, ename - there is different column in3 different table but return a result department wise name----- one table has dept id another table table doesn't have dept id column---ename is common column for entire 3tables
Thank you sir for another good video:) thank you so much all your videos and for the efforts you are putting for them...thanks much again...keep up the good work
Hi Sir thank you so much we got another great video...well explained...pls make an Oracle architecture..and perfoance tuning video like . explain plan and auto trace..tk proof..and analysis
Hi siva, thank you for the wonderful videos and I have a doubt here in the second method (core related sub query) is that mandatory to use min / max keyword in inner query ?
Hi Siva, Thanks for this video, just one question when I am deleting the duplicate records and then run select * command and then rollback, so it is deleting entire data of my table...any solution for this?
Hi is it that , rowid is assigned to records based on time stamp? if selecting max(rowid) throws the recently inserted record and min(row) throws the original record.
No, don't rely upon on rowid to get Last inserted record, if few records are deleted, then the empty space would be utilised by subsequent insertion, hence don't depend on rowid to identify latest inserted row
I Brother I have a Question related to INDEX , My Question is 1.Is it possible to create an index on views? And 2.Is it possible to create an index on updatable view?
Hi sir could you please help me in below scenario There is a clob column . I want to extract particular line after match pattern Type1: None Typr2: None Type3: Services,re Type4: None My output should be whatever under type 3
Sir I have question that ,suppose we 10 records (first name), 5 records in small letters(abc) and 5 records in upper letters (ABC) so I want those records who are in small letters so what will be quary?
This is how I practice, I read the question in thumbnail and try to solve on my own.. this helps a lot! Today my solution was correct!! Thank you Sir, your videos are great.
Its my pleasure, thank you 🙏
It's Amazing!!! You are sharing your knowledge with others so dedicatedly. It proves you are a man with a big heart and a beautiful mind. People like me will benefit from your video.
Thank you 🙏🙏🙏
Really it was nice vedio on deleting duplicate rows by different approaches thanks Siva..
Welcome bro 💐
Hi Shiva,
Very good training.Nice explanation.Thank you so much
Thank you
Very clear explanation, and it was very helpful.
Thank you very much Siva,
Sujaa
You are welcome 😊. Thanks Again
Thank you so much Siva sir for your dedicated video
My pleasure bro, thank you
Thanks Siva.. much clearly you explain the things..
You are welcome 😊
Delete from emp where rowid>(select emp.*, Min(rowid) as rr from emp) where rr>1;
Doubts Cleared Thank you, Sir Please Make Vedios on Analytical Functions
Its my pleasure 🙏 thank you, please stay tuned for more videos
Thanks Siva garu we are expecting more videos like this
Welcome bro, absolutely, please stay tuned for more videos
@@SivaAcademy If i enter any number like 100 but output will be display as hundred
@@vishalsaxena5081 select 100, to_char(to_date(100, 'j') , 'jsp') from dual
Hii Mr. shiva, how r u. whn I see ur new video always , I used to feel like if I dnt watch, I could miss some imp tip frm tht video and I liked the last method... Thank u so much
Welcome Srinivas, Thank you so much
We can use group by and having to identify the duplicate or distinct records
Sir, Which is the best way to delete duplicate records if the table is having millions of records?
Hi Siva, there is 3different column and 3different table,like one table have dept id,ename, another table have prod I'd &ename column, another table has dept id, ename - there is different column in3 different table but return a result department wise name----- one table has dept id another table table doesn't have dept id column---ename is common column for entire 3tables
May I know your question? Can you post a sample example data and expected output
Thank you sir for another good video:) thank you so much all your videos and for the efforts you are putting for them...thanks much again...keep up the good work
Welcome 🙏💐 thank you
Thank you sir for such detailed explanation!!!
Welcome bro 🙏 thank you
Nice information.
Can we write function in pl/sql block? And call from same block?
hii shiva , you are doing great , my question is why equi join returned matching rows , could be please answer this ?
awesome content !!! very very very handy!!
Glad it was helpful!
Hi Sir thank you so much we got another great video...well explained...pls make an Oracle architecture..and perfoance tuning video like . explain plan and auto trace..tk proof..and analysis
sure, please stay tuned, will post it soon
@@SivaAcademy I am waiting sir please post asap.. thank you 😊
very well explained siva sir thanks for the video :)
Welcome bro 🙏 thank you 💐
Hi Siva, which method out of 5 will be mostly used in real time?
I need to test with large volume of data, i will post a video after my analysis with numbers
thanks sir, what a great teaching skill you have. Please start SQL, PL/SQL course from scratch
Welcome, sure, please stay tuned
Hi siva, thank you for the wonderful videos and I have a doubt here in the second method (core related sub query) is that mandatory to use min / max keyword in inner query ?
Hi Siva, Thanks for this video, just one question when I am deleting the duplicate records and then run select * command and then rollback, so it is deleting entire data of my table...any solution for this?
Hi Sir, from is missing after delete. But still how it worked?
Thank you so much sir
Welcome 🙏💐
Hi Siva sir, Is any online training course your providing for expert level or corporates. If yes then pls let me know.
Is it possible to delete duplicate records using having clause sir?
Nice explanation bro👍
Thank you, next video is on NOCOPY bro, I will try to cover remaining you asked later
@@SivaAcademy thanks bro... I am eagerly waiting
Hi is it that , rowid is assigned to records based on time stamp? if selecting max(rowid) throws the recently inserted record and min(row) throws the original record.
No, don't rely upon on rowid to get Last inserted record, if few records are deleted, then the empty space would be utilised by subsequent insertion, hence don't depend on rowid to identify latest inserted row
Well explained. Can you explain about performance tuning and explain plan?
Thank you 🙏, sure please stay tuned
can i have two databases in my sql developer that is 11g and 19c at the same time?
sir which of these method is cte method ?
@Siva, Can you please do a demo on Oracle Concurrency Control, Serilaizationa and Isolation levels with proper expample.
sure, please stay tuned
I Brother I have a Question related to INDEX , My Question is
1.Is it possible to create an index on views? And
2.Is it possible to create an index on updatable view?
Index only on physical data is allowed, since view relay on underlying table data, no indexes are allowed now on views
Hi sir could you please help me in below scenario
There is a clob column . I want to extract particular line after match pattern
Type1:
None
Typr2:
None
Type3:
Services,re
Type4:
None
My output should be whatever under type 3
not sure, whether this is what you are looking for
substr(c,instr(c,'Type3:')+length('Type3:')+1)
Very good
Thank you bro
Sir I have question that ,suppose we 10 records (first name), 5 records in small letters(abc) and 5 records in upper letters (ABC) so I want those records who are in small letters so what will be quary?
Sample query
Select* from table where column_name = lower(column_name)
@@SivaAcademy thanks team
🙏💐
@@SivaAcademy if possible to make video pls try because question asked me 2,3 times in interview
Sure, please stay tuned
sir,how to findout the dupliate values without using distinct keyword
Please look into this video ruclips.net/video/2G8zuE5JuUA/видео.html
Thank you🙏
Welcome 🙏
Without using rowid.
Is it possible to delete duplicate data
Please answer me.
Not by using single statement, but using set of SQL statements you can do, method 4 and method 5 will show you how to do it in the same video
Sir , can u pls upload vedio on joins and which join yield more records than other joins interview question?please
Sure, will add soon, please stay tuned
Thank you Sir
Welcome
can't we do with Ran function?
Hi siva, can u please make a video on "alter table emp_test enable constraint emp_pk exceptions into exceptions;".
Exceptions is a table here
Yes Prasanth, will post it couple of days, please stay tuned
@@SivaAcademy thank you so much!!
A table has number as well as alphabets in a single column, how to separate this?
Update Table_name set column1=reqexp_replace(column1,^[0_9]);
Update Table_name set column2=reqexp_replace(column1,^[a-z_A-Z]);
Please look into this video
ruclips.net/video/ZuO8QmnzpdY/видео.html
Can you please make a video to download database and connect to sql developer
Do you mean, download and install, and connect to database through SQL developer?
@@SivaAcademy yes I want to install
Sure Ramesh, I will post a seperate video on how to download, install and connect and start with soon, please stay tuned
00:23, 07:23
Thank you so much sir
Welcome bro
Thank you 👍
Welcome bro