Finally , completed full playlist till now .Seriously feeling very confident now for interview as lot of concepts are very clear. Subscribed & wait for new bulk of videos . #Thanks #SivaAcademy 🙏❤️
Hi Siva, I'm very grateful to you... thank you so much for making these type of videos....it helps me a lot..only for your tutorial I'm getting selected in jobs. Within 1month I have completed all videos that you shared and after that I get hired on 6companies also in one-time. Once again thank you so much 😊
mindblowing tutorial this is the best in youtube. thanks alot sir... you are welll experienced. your teaching is overwhelming... pls post interview questions for oracle, sql in experienced level basis if possible.
After trigger the query for user_views I unable to see the owner name and constraint name... Etc... Why sir... Could you please tell what is the reason...
Thank you, Sir... One doubt:-- Why we need to create a dynamic sql for create view statement... Instead can't we directly have a create view statement using variable name as view name ... Like -- Create or replace View i.object_name || '_v' as Select * from i.object_name; ... -- this statement can be executed directly without using execute immediate... Please clarify, Sir... Thank you, Sir...
You cannot insert duplicate value in primary key column, however a column containing duplicate values can have a primary key created, you can look into this video ruclips.net/video/SFlmUk9IUg8/видео.html
Hi, Nice Explanation bro. One of the Views related video you have explained about the Materialized view manual Refresh method(dbms_mview(view_name).Could you please make a video about FAST, COMPLETE, FORCE Refresh methods also..
question asked by interviewer to me : suppose you have created an view on whole table which have 4 column. case 1 :what will happen if we alter the table and add a new column. will view generate an error ? case 2 :what will happen if we alter the table and remove a column. will view generate an error? MY ANS : in first case no error . in second case view will generate an error .
Hi ! Does anyone here knows what is meant by bind variable and what is meant by lexical variables? I think I know something about bind variables but lexical variables is a new term for me. Thanks in advance.
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Thanks sir for giving answer to my query.
Welcome Sai Ram
Finally , completed full playlist till now .Seriously feeling very confident now for interview as lot of concepts are very clear.
Subscribed & wait for new bulk of videos . #Thanks #SivaAcademy 🙏❤️
Welcome, wishing you best wishes 👍💐
Hi Siva, I'm very grateful to you... thank you so much for making these type of videos....it helps me a lot..only for your tutorial I'm getting selected in jobs. Within 1month I have completed all videos that you shared and after that I get hired on 6companies also in one-time. Once again thank you so much 😊
Welcome, its my pleasure, Best wishes 💐💐👍👍🙏
How many years of experience?
mindblowing tutorial this is the best in youtube. thanks alot sir... you are welll experienced. your teaching is overwhelming... pls post interview questions for oracle, sql in experienced level basis if possible.
Thank you for your comments bro, please stay tuned for questions, please let me know if you have any specific question to address 🌸🌸🙏
Clean explanations Siva sir..Much appreciated for your extended effort to make such videos.
Welcome Deepak
watching your videos is easier than reading documentation, thanks
Welcome bro
Shiva sir, egarly waiting for your performance tuning videos.please make a videos asap for atleast 2 videos in a week.
Sure Vijaya, I will try my level best to post frequently, please stay tuned 👍
Yes sir, I'm also waiting for those videos.
Excellent explanation!!!
Thank you bro
Nice videos you providing and helping to others thank you sir ...
Welcome Manju
Thank you Sir, you are doing a fantastic job . My many doubts are clear now . Please make videos on performance tuning.
Thank you
Great explaination!!!Thankuu sooo muchhh sir..
Thank you
Thank you Siva for your Explanation ....
Welcome Ragu
Thank you Siva sir…
Great explanation
Welcome 🙏
After trigger the query for user_views I unable to see the owner name and constraint name... Etc... Why sir... Could you please tell what is the reason...
Thank you so much ❤
Welcome
Excellent Video sir.
Thank you
Brother I need some quick info...is there a way to retrieve data back if we truncated data in pl/sql
thank u in prior
can you check flashback query
@@SivaAcademy Tried I didnt have access to flashback
Thank you, Sir...
One doubt:--
Why we need to create a dynamic sql for create view statement... Instead can't we directly have a create view statement using variable name as view name
... Like --
Create or replace View i.object_name || '_v' as Select * from i.object_name;
... -- this statement can be executed directly without using execute immediate... Please clarify, Sir... Thank you, Sir...
Thank you for video Siva sir
Welcome Deepak
Sir, What is the data type of status at the time of table creation
Thank you
Welcome
@@SivaAcademy can you please explain about how to insert duplicated values in primary key column
You cannot insert duplicate value in primary key column, however a column containing duplicate values can have a primary key created, you can look into this video ruclips.net/video/SFlmUk9IUg8/видео.html
Hi,
Nice Explanation bro.
One of the Views related video you have explained about the Materialized view manual Refresh method(dbms_mview(view_name).Could you please make a video about FAST, COMPLETE, FORCE Refresh methods also..
Sure please stay tuned 👍
thank you sir
one question can create an index on view (simple view / complex view )
Welcome
No, vides itself have data of its own, it fetch the data at the time of execution from underlying base tables
Excellent
Welcome bro
Pls upload videos on hints
Nice 👍👍🙏🙏 🙏🙏❤️❤️
Welcome bro 🙏💐💙
AMAZING!!
Thank you
Hello sir please make video on types of refresh on materialized view.
Sure bro, please stay tuned
question asked by interviewer to me :
suppose you have created an view on whole table which have 4 column.
case 1 :what will happen if we alter the table and add a new column. will view generate an error ?
case 2 :what will happen if we alter the table and remove a column. will view generate an error?
MY ANS : in first case no error . in second case view will generate an error .
Your answer is correct 👍
Can you please send the link of types of refresh in materialized view...
Sir please make some videos on Window Function ,Aggregate and Offset Window functions
Sure bro, please stay tuned
Can you please explain what is editionable view
Sure bro
Whr can i found all constraint type description?
user_constraints data dictionary table
What is performance tuning?
If you call view it will automatically try to compile the view.
Hi sir .i have issue in procedure.i created it completed but it doesn’t give me output .if i send you snapshot to you is it ok .thanks
please send to siva.k.academy@gmail.com
@@SivaAcademy thanks i will my procedure
Hi ! Does anyone here knows what is meant by bind variable and what is meant by lexical variables?
I think I know something about bind variables but lexical variables is a new term for me. Thanks in advance.
Please make vedio on Oracle architecture
Sure, please stay tuned 👍
How to find out exact error line please make vedio on that thank you
dbms_output.put_line ( ' [P] Others : ' || dbms_utility.format_error_backtrace ) ;
Yeah, you can use dbms utility package mentioned by mohan, I will post with an example soon, please stay tuned
Also format error back stack s vedio
Sure
@@SivaAcademy Sir did u give training on pl sql ?? I want to learn . Please tell me how to connect with you