Oracle PL SQL interview question | SQL to Delete duplicate records

Oracle PL SQL interview question | SQL to Delete duplicate records
sivakacademy.blogspot.com/202...
correlated subquery : • Oracle PL SQL intervie...
List of all Interview questions @ sivakacademy.blogspot.com/p/s...
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...
Oracle PLSQL records and collections at • oracle plsql records a...

[@jay.shah96]

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.

[@SivaAcademy]

Its my pleasure, thank you 🙏

[@vigneshkrish4742]

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 ?

[@VinayKumar-ij4eu]

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?

[@sujaa1000]

Very clear explanation, and it was very helpful. Thank you very much Siva, Sujaa

[@SivaAcademy]

You are welcome 😊. Thanks Again

[@bharatbagul9292]

Thanks Siva.. much clearly you explain the things..

[@SivaAcademy]

You are welcome 😊

[@joseronald111]

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

[@SivaAcademy]

Welcome 🙏💐 thank you

[@ramanaatchala]

Hi Shiva, Very good training.Nice explanation.Thank you so much

[@SivaAcademy]

Thank you

[@sandipjadhao1990]

Really it was nice vedio on deleting duplicate rows by different approaches thanks Siva..

[@SivaAcademy]

Welcome bro 💐

[@yadagirishankar]

Sir, Which is the best way to delete duplicate records if the table is having millions of records?

[@muralisethi]

Thank you sir for such detailed explanation!!!

[@SivaAcademy]

Welcome bro 🙏 thank you

[@deepakjagdale6215]

Hi Siva sir, Is any online training course your providing for expert level or corporates. If yes then pls let me know.

[@KaranChaudhary-zt4no]

can i have two databases in my sql developer that is 11g and 19c at the same time?

[@alimsheikh1029]

Thank you so much Siva sir for your dedicated video

[@SivaAcademy]

My pleasure bro, thank you

[@abinashmandal7925]

hii shiva , you are doing great , my question is why equi join returned matching rows , could be please answer this ?

[@naveenp1843]

very well explained siva sir thanks for the video :)

[@SivaAcademy]

Welcome bro 🙏 thank you 💐

[@avijitnagare]

Nice information. Can we write function in pl/sql block? And call from same block?

[@abhisheknittala7181]

awesome content !!! very very very handy!!

[@SivaAcademy]

Glad it was helpful!

[@madhumitakumari2082]

Hi Sir, from is missing after delete. But still how it worked?

[@vickypatekar9532]

Doubts Cleared Thank you, Sir Please Make Vedios on Analytical Functions

[@SivaAcademy]

Its my pleasure 🙏 thank you, please stay tuned for more videos

[@nareshchoudhary9774]

sir which of these method is cte method ?

[@iswaryarajendran2022]

Is it possible to delete duplicate records using having clause sir?

[@venkatapathiuppalapati9673]

Thanks Siva garu we are expecting more videos like this

[@SivaAcademy]

Welcome bro, absolutely, please stay tuned for more videos

[@vishalsaxena5081]

@@SivaAcademy If i enter any number like 100 but output will be display as hundred

[@daljeetsingh5192]

@@vishalsaxena5081 select 100, to_char(to_date(100, 'j') , 'jsp') from dual

[@srinivasreddy186]

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

[@SivaAcademy]

Welcome Srinivas, Thank you so much

[@devanaidu9406]

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

[@SivaAcademy]

sure, please stay tuned, will post it soon

[@devanaidu9406]

@@SivaAcademy I am waiting sir please post asap.. thank you 😊

[@tusharsonwane8468]

Thank you so much sir

[@SivaAcademy]

Welcome bro

[@tejan8804]

can't we do with Ran function?

[@sudha2732]

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

[@SivaAcademy]

May I know your question? Can you post a sample example data and expected output

[@manochoco23]

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.

[@SivaAcademy]

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

[@anilk3233]

Hi Siva, which method out of 5 will be mostly used in real time?

[@SivaAcademy]

I need to test with large volume of data, i will post a video after my analysis with numbers

[@gomathinama5876]

Thank you🙏

[@SivaAcademy]

Welcome 🙏

[@vsr1727]

Thank you 👍

[@SivaAcademy]

Welcome bro

[@kirthikamurugesan1514]

Well explained. Can you explain about performance tuning and explain plan?

[@SivaAcademy]

Thank you 🙏, sure please stay tuned

[@user-jz2pz5pi6i]

Very good

[@SivaAcademy]

Thank you bro

[@vijayarajan2599]

@Siva, Can you please do a demo on Oracle Concurrency Control, Serilaizationa and Isolation levels with proper expample.

[@SivaAcademy]

sure, please stay tuned

[@shashank2004]

Nice explanation bro👍

[@SivaAcademy]

Thank you, next video is on NOCOPY bro, I will try to cover remaining you asked later

[@shashank2004]

@@SivaAcademy thanks bro... I am eagerly waiting

[@nntrainingandplacementsolu9734]

thanks sir, what a great teaching skill you have. Please start SQL, PL/SQL course from scratch

[@SivaAcademy]

Welcome, sure, please stay tuned

[@girishpatil5351]

Delete from emp where rowid>(select emp.*, Min(rowid) as rr from emp) where rr>1;

[@ananthaselvi9019]

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

[@SivaAcademy]

not sure, whether this is what you are looking for substr(c,instr(c,'Type3:')+length('Type3:')+1)

[@manjutharak]

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?

[@SivaAcademy]

Index only on physical data is allowed, since view relay on underlying table data, no indexes are allowed now on views

[@kumarbrajesh5051]

Without using rowid. Is it possible to delete duplicate data Please answer me.

[@SivaAcademy]

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

[@ssskkk9079]

Sir , can u pls upload vedio on joins and which join yield more records than other joins interview question?please

[@SivaAcademy]

Sure, will add soon, please stay tuned

[@prashantsisodiya1391]

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?

[@SivaAcademy]

Sample query Select* from table where column_name = lower(column_name)

[@prashantsisodiya1391]

@@SivaAcademy thanks team

[@SivaAcademy]

🙏💐

[@prashantsisodiya1391]

@@SivaAcademy if possible to make video pls try because question asked me 2,3 times in interview

[@SivaAcademy]

Sure, please stay tuned

[@ravipatisrikanth8331]

sir,how to findout the dupliate values without using distinct keyword

[@SivaAcademy]

Please look into this video kzbin.info/www/bejne/aHibq6h7aq-oi6M

[@prashantmate8340]

Hi siva, can u please make a video on "alter table emp_test enable constraint emp_pk exceptions into exceptions;".

[@prashantmate8340]

Exceptions is a table here

[@SivaAcademy]

Yes Prasanth, will post it couple of days, please stay tuned

[@prashantmate8340]

@@SivaAcademy thank you so much!!

[@rajanayak8093]

A table has number as well as alphabets in a single column, how to separate this?

[@karthickm8042]

Update Table_name set column1=reqexp_replace(column1,^[0_9]); Update Table_name set column2=reqexp_replace(column1,^[a-z_A-Z]);

[@SivaAcademy]

Please look into this video kzbin.info/www/bejne/kKayaYSjo9-jmrs

[@Ramesh-rp6jq]

Can you please make a video to download database and connect to sql developer

[@SivaAcademy]

Do you mean, download and install, and connect to database through SQL developer?

[@Ramesh-rp6jq]

@@SivaAcademy yes I want to install

[@SivaAcademy]

Sure Ramesh, I will post a seperate video on how to download, install and connect and start with soon, please stay tuned

[@vaniganapathi830]

Thank you so much sir

[@SivaAcademy]

Welcome 🙏💐

[@Ronaldo-yl7zv]

Thank you Sir

[@SivaAcademy]

Welcome