Пікірлер
@vru5696
@vru5696 23 сағат бұрын
Can you create course with sql and DBT
@milesmoralis4361
@milesmoralis4361 Күн бұрын
Bro i have tried everything still I won't be able to connect with mysql database.a
@ahsanbadhon5471
@ahsanbadhon5471 Күн бұрын
Where can i get the roadmap
@aniruddhaparida6310
@aniruddhaparida6310 Күн бұрын
SQL roadmap
@Siva-s6y
@Siva-s6y Күн бұрын
sql
@adityapratap7058
@adityapratap7058 Күн бұрын
ACCEPT var_age NUMBER PROMPT 'KYA AGE HAI LAUNDE?'; DECLARE age NUMBER := &var_age; ex_var EXCEPTION; PRAGMA EXCEPTION_INIT(ex_var, -20008); BEGIN IF age < 18 THEN RAISE_APPLICATION_ERROR(-20008, 'UNDERAGE HAI LAUNDA'); END IF; DBMS_OUTPUT.PUT_LINE('OVERAGE HAI LAUNDA. you can drink and die'); EXCEPTION WHEN ex_var THEN DBMS_OUTPUT.PUT_LINE(SQLERRM); END;
@nalinikarthikeyan8960
@nalinikarthikeyan8960 2 күн бұрын
Thanks for this series... Pls show o/p screen also example for more understanding sir...
@codingwithankit7619
@codingwithankit7619 4 күн бұрын
Continue this series
@Dennis_Wahengbam
@Dennis_Wahengbam 5 күн бұрын
So when do we use Union All. Anyone? I know the answer btw 😊
@TrendingsShortx
@TrendingsShortx 5 күн бұрын
is there a mistake in your roadmap ? because I searched it in Gemini and it gave me the following answer: *DML (Data Manipulation Language) Statements: INSERT: Adds new rows to a table. UPDATE: Modifies existing rows in a table. DELETE: Removes rows from a table. SELECT: Retrieves data from a database (while not strictly a DML, it's often categorized with DML as it's used to manipulate data). Other SQL Statement Categories: DDL (Data Definition Language): CREATE: Creates database objects like tables, indexes, views, etc. ALTER: Modifies the structure of database objects. DROP: Deletes database objects. TRUNCATE: Removes all rows from a table. DCL (Data Control Language): GRANT: Grants privileges to users. REVOKE: Revokes privileges from users. Other SQL Concepts: Stored Procedures (CALL): Precompiled SQL statements that can be executed multiple times. They can contain DML statements, but they are not DML statements themselves. EXPLAIN PLAN: A tool used to analyze the execution plan of a SQL query. It helps identify performance bottlenecks and optimize queries. Locking: A mechanism to control access to data, preventing conflicts and ensuring data integrity. It's not a specific statement but a database concept that can be used with DML statements. So, while CALL, EXPLAIN PLAN, and LOCK are important concepts in database management, they are not categorized as DML statements.
@bean2934-w1q
@bean2934-w1q 5 күн бұрын
looking forward
@JudeYamoah
@JudeYamoah 6 күн бұрын
Link gives a 404 error
@Dariuz82
@Dariuz82 7 күн бұрын
Hi Manish, I have to create about 7-8 data file with size 20 G, my database is very big (about 120 GB) how can I have to do?
@greeshmababu4751
@greeshmababu4751 7 күн бұрын
looking forward to
@Wealthybuddy6
@Wealthybuddy6 7 күн бұрын
Yes
@satyajyotisatapathy8078
@satyajyotisatapathy8078 8 күн бұрын
When I install package it shows error failed to add instll user group %2% group can you please suggest how to proceed
@ASMahaboob
@ASMahaboob 8 күн бұрын
SQL
@deservings01
@deservings01 8 күн бұрын
Ai with sql is really good i use many time its confidential and safe it depend on how we put prompt to generate data i just love it
@richareddy8092
@richareddy8092 9 күн бұрын
Excited
@asheralexander8
@asheralexander8 10 күн бұрын
Nice
@supriyamedhekar9538
@supriyamedhekar9538 10 күн бұрын
Excited