Day 2 - Oracle SQL for Beginners |Oracle SQL Tutorial | Oracle SQL for Beginners | SQL for beginners

[@NICITACADEMY]

*Complete 48 hours of Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy======================================================================= 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* kzbin.info/www/bejne/eWLdeImIe7JmY6M 📌*Informatica Full Course:* kzbin.info/www/bejne/jGOppY2VfrOgoMk 📌*SQL Full Course:* kzbin.info/www/bejne/n6bZq52cbNOIZ6s 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH kzbin.info/aero/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist kzbin.info/aero/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL kzbin.info/aero/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer kzbin.info/aero/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos kzbin.info/aero/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks

[@ushasriperumalla]

Really very simple and useful vedio

[@thinksoft9]

Thank you Chandra for your educative videos. I learnt Oracle basics from the scratch... as a self-learner.

[@NICITACADEMY]

Wonderful! Keep watching my channel.

[@ramandeepkumar7050]

How to join watsapp group

[@yuvarajk9557]

Hi Thank you for your detailed class on SQL. Really useful and very easy to learn SQL from your video

[@NICITACADEMY]

Glad to hear that

[@kusheetham4090]

Thank you very much sir.. which is really help us so much. Crore thanks to you.

[@NICITACADEMY]

You are most welcome. Keep watching my channel and practice. Like and share my videos.

[@kotamyogeswarreddy5165]

Tq so much it's very helpful sir

[@NICITACADEMY]

Most welcome

[@haamimrashid425]

Hello! Hope you are doing well. I recently started with this playlist and I must say it is really helpful for developing our concepts from scratch even for a newbie. I have a query though as there are so many various statements, what is the possible way to memorize it? Or is there even the need to memorize it or just understanding it is enough?

[@haribabu6363]

good explanation sir

[@NICITACADEMY]

Thanks and welcome

[@EK-ee4gb]

Thank you very much Sir.

[@NICITACADEMY]

You are most welcome

[@satishdandangi5499]

Thank you sir for your clear explanation, please do upload the remaining sessions sir..

[@NICITACADEMY]

Sure I will

[@meghanavelumula9591]

Sir, if I run rollback after creating the table and inserting values still the values are there itself in oracle sql developer :HR and you told that in sql and teradata there is no concept of rollback but Why it is worked for you?

[@NeerajPrince-t2c]

sir which software are u using

[@krishnanselvam786]

Thank you sir......😊

[@NICITACADEMY]

Most welcome

[@chandrakanthmiryala]

hi sir please do full vedios on etl sraging course

[@budhahemalatha6440]

Can we insert multiple rows in a single insert command?

[@shraddhapatange9629]

while doing alter table customer drop column city m getting error as below: Error report - ORA-12988: cannot drop column from table owned by SYS. how do i resolve?

[@NICITACADEMY]

I think you are dropping from system owned meta data tables. don't drop the column. you can drop your own table column only, not with admin tables.

[@pranithkumar9484]

Google drive link not exist. Can you provide the notes Sir

[@nibeditamajhi9025]

If i drop a table can rollback again

[@NICITACADEMY]

No, we can't rollback. Drop is a DDL command. Once dropped, we can't rollback. Only DML statements can be rolled back.

[@kiranratnakara6828]

Why don't you start up a new company...... your videos are very effective and good explanation

[@NICITACADEMY]

Thank you, Your wish will come true soon.

[@kiranratnakara6828]

I am great fan of you sir

[@pavithragovindan237]

Hai where I can get the notes and where to download.? Can anyone help me?

[@divyaparameshwaran2272]

See the description of this video. There is a link. Download it

[@dineshp6999]

Hello sir please upload rest of the sessions like tamil

[@NICITACADEMY]

Sure I will do

[@Karan.v4]

Sql common interview ques. Videos podunga sir.

[@NICITACADEMY]

Will upload soon

[@vaishnavim6625]

Where is the link for day wise notes you show in the video. Because the google drive notes link seems little different

[@NICITACADEMY]

Please check the description

[@vaishnavim6625]

Yes I have but it is not same as the day wise notes you refer in the video could we please get those notes ?

[@garimajain4616]

Explanation is good but it doesn't feel like for the Beginniers

[@NICITACADEMY]

Thanks for your feedback, Please let me know your pain points. I will try to accommodate in the future session. I will try my level best.

[@garimajain4616]

Your way of explaination are good but i am a fresher to sql,so bit difficult to understand like you used modify, set, where, and used alter with dml statments as well no guidence were given before when we should use alter as statment and before which statment like i thought it is only used for altering structure but it is used for altering data as well..

[@9441982827]

Hi sir, Could you please upload SQL scenario based questions and answers

[@NICITACADEMY]

Okay. I ll do. Keep watching my channel

[@m.wwadumulla8413]

Notes are not available sir

[@NICITACADEMY]

Available here: nicitacademy.com/interview-questions/

[@phanikumar4300]

Hello sir, There is no notes pinned in description section. If the notes is provided it would be truely helpful. Thanks

[@NICITACADEMY]

updated, please check now

[@cia3836]

Where I can get notes

[@sandyvoice007]

*Which are common errors for insert into statement Oracle sql?* Some common errors that can occur with an INSERT INTO statement in Oracle SQL: 1. *Syntax errors*: Missing or incorrect keywords, parentheses, or commas. 2. *Data type mismatch*: Trying to insert a value with a data type that doesn't match the column's data type. 3. *Column name errors*: Misspelling or incorrect column names. 4. *Primary key violations*: Trying to insert a duplicate value into a column with a primary key constraint. 5. *Foreign key violations*: Trying to insert a value that doesn't exist in the referenced table. 6. *Check constraint violations*: Trying to insert a value that doesn't meet the condition specified in a check constraint. 7. *Not null constraint violations*: Trying to insert a null value into a column with a not null constraint. 8. *Invalid values*: Trying to insert invalid values, such as a string into a date column. 9. *Inserting too many values*: Trying to insert more values than there are columns. 10. *Inserting too few values*: Trying to insert fewer values than there are columns. 11. *Using incorrect quotes*: Using single quotes instead of double quotes for column names. 12. *Using reserved keywords*: Using Oracle reserved keywords as column names without proper quoting. 13. *Invalid use of subqueries*: Using a subquery that returns more than one row or column. 14. *Trigger errors*: Errors caused by triggers firing during the insert operation. 15. *Privilege errors*: Lack of necessary privileges to perform the insert operation. These are just some of the common errors that can occur with an INSERT INTO statement in Oracle SQL.

[@basuchannal5884]

Hi sir I have tried to download the notes but I can't download.

[@basuchannal5884]

Sorry, the file you have requested does not exist. When I click on link It's showing like this

[@NICITACADEMY]

nicitacademy.com/interview-questions/

[@caffemilano4168]

Thank you very much sir...

[@NICITACADEMY]

Most welcome

[@magnete7009]

Thank you Sir..

[@NICITACADEMY]

Most welcome