Bro i have tried everything still I won't be able to connect with mysql database.a
@ahsanbadhon5471Күн бұрын
Where can i get the roadmap
@aniruddhaparida6310Күн бұрын
SQL roadmap
@Siva-s6yКүн бұрын
sql
@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;
@nalinikarthikeyan89602 күн бұрын
Thanks for this series... Pls show o/p screen also example for more understanding sir...
@codingwithankit76194 күн бұрын
Continue this series
@Dennis_Wahengbam5 күн бұрын
So when do we use Union All. Anyone? I know the answer btw 😊
@TrendingsShortx5 күн бұрын
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-w1q5 күн бұрын
looking forward
@JudeYamoah6 күн бұрын
Link gives a 404 error
@Dariuz827 күн бұрын
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?
@greeshmababu47517 күн бұрын
looking forward to
@Wealthybuddy67 күн бұрын
Yes
@satyajyotisatapathy80788 күн бұрын
When I install package it shows error failed to add instll user group %2% group can you please suggest how to proceed
@ASMahaboob8 күн бұрын
SQL
@deservings018 күн бұрын
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