Oracle PL SQL interview question | Oracle NOT NULL Constraint | Oracle Constraints

Oracle PL SQL interview question | Oracle NOT NULL Constraint | Oracle Constraints
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
/ sivaacademy
Home page: sivakacademy.b...
Telegram Channel : t.me/SivaAcademy
--------------------------------------------------------------
Home page: sivakacademy.b...
List of all oracle SQL/PLSQL Interview questions sivakacademy.b...
List of all PLSQL Scenario based Interview Questions sivakacademy.b...
List of all Subscriber questions and answers sivakacademy.b...
--------------------------------------------------------------
Oracle Interview questions playlist • oracle interview quest...
Oracle 18C New features playlist • Oracle 18C New Feature
Oracle 12C New features playlist • Oracle 12C New Feature...
Oracle PLSQL records and collections playlist • oracle plsql records a...
--------------------------------------------------------------
My video courses at UDEMY www.udemy.com/...
--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos
For any questions, please drop me a mail at [e-mail]
--------------------------------------------------------------

[@raghavendranramachari488]

Thank you very much Siva. I was looking for how to name a not null constraint on "create table" and found it in this video. This is very very helpful. Thank you very very much....

[@SivaAcademy]

Welcome bro

[@dasubabuch1596]

Hi Sir, Can you please tell me how can we copy the table structure with constraints and without data in oracle ?

[@manojkumarrajaka5204]

Waiting for this topic.. Love u bro 😘

[@SivaAcademy]

Thank you bro

[@divyeshchowdhury8143]

Hi, Can you please tell me if I need to have certain set of column as null and certain set of column as not null then what should be the order of creating the column in the table? Do the ordering of null or not null columns have any impact in the table creation or it can be put in any order as per user choice?

[@sanjayvirat3656]

Hi Sir, The video is excellent. How can we add the constraint using the alter table concept after we just dropped the constraint

[@SivaAcademy]

Thank you, you can just reexecute the alter statement again to add the constraint, you can check this video for more details kzbin.info/www/bejne/ol7NqoGeiNeHpaMsi=BKossoVrAntVVXJM

[@chaitumunna6406]

hi sir ... i have question joins and interview questions in joins for beginneers and also expert also can you record the video post the question

[@srinivasuchamakuri999]

Hi, Could you please provide the explanations for the below questions 1. Could you please explain how Dynamic SQL(execute immediate) will execute and what are the processes included in executing dynamic SQL? 2. How to give Limit value in bulk collect? 3. How to read explain plan? 4. what happens when we compile procedure? 5.what is SQL Injection?

[@SivaAcademy]

Sure, please stay tuned bro

[@srinivasuchamakuri999]

@@SivaAcademy Thank you Brother.

[@bhushanramani4475]

Thankyou sir , just finished watching this whole series .. really helpful , keep up the good work

[@SivaAcademy]

Welcome, 👍👍🙏

[@TheKetan4500]

Can you post video on subversion software with plsql development for version controlling

[@sakshinaik05]

Love this constraint series

[@SivaAcademy]

My pleasure

[@hardshad]

Thank you sir. Could you please post a video on DEFERABLE and NON DEFERRABLE values/types shown in User_Constraints table?

[@SivaAcademy]

Please look into this video kzbin.info/www/bejne/iXfPnoihbq6InZo

[@md.selimhossain4181]

Thank a lot for your nice video

[@SivaAcademy]

You are most welcome

[@amitlondhe3651]

Very informative content for me👍

[@SivaAcademy]

My pleasure

[@hemnathc5399]

Nice content Siva. Kindly do videos on query tuning.

[@SivaAcademy]

sure bro, pls stay tuned

[@shashank2004]

Nice video bro..... Pls make a video on sys_context, explain plan and index methods

[@SivaAcademy]

sure bro

[@bhushanpalse516]

Sir, how to use date function for real time scenario ,to display last two years sales from multiple means more than 3 tables

[@SivaAcademy]

Can you please send me sample data and expected output to [e-mail]

[@ijazbalouch6415]

Salam sir am beginner in orcale dbms and I want to start from your channel but I don't know which Playlist I use first please suggest me your Playlist name

[@SivaAcademy]

Thank you, there is no specific order, you can start from any series, each video is focused on specific topic, though it would be better to start from first video of Playlist of any series

[@gomathinama5876]

Thank you🙏.. Nice 👍

[@SivaAcademy]

😊🙏👍💐

[@கதையின்கரு]

Thanks for this series on Constraints. I have a doubt, could you please explain me the biggest size data type other than CLOB. I need to handle exceptions with a message where I need to concatenate multiple strings. Its not a limited size. how can this be handled?

[@SivaAcademy]

why cant you put into some collection?

[@கதையின்கரு]

@@SivaAcademy thanks bro, but if I store it in collection, how can I display it in a exception message as I need to loop it

[@SivaAcademy]

You can iterate through the collection and display all the elements of the collection

[@கதையின்கரு]

@@SivaAcademy yes bro, if I iterate it will be like multiple line item but I want entire collection (the exceptions) as a single message

[@SivaAcademy]

Is your intention to display all the message from exception handling section? Or to concatenate as single value? Can you please tell what you would like to do with such large message? It would be better to insert into log tables if you are ok to display also

[@athiraprabhakaran7281]

Hi Sir, Could you please explain about auth id

[@SivaAcademy]

Sure, please stay tuned

[@kanaiyasindhavad5605]

How to Disable all constraint in all table in one go

[@parinitha630]

Please sir not null notes video