Answer Posted / hr@tgksolutions.com
• SQL (Structured Query Language):
o Used to interact with databases (e.g., querying, inserting, updating data).
o Declarative in nature.
• PL/SQL (Procedural Language/SQL):
o Procedural extension of SQL in Oracle.
o Supports loops, conditions, and error handling.
o Used for creating functions, triggers, and stored procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between union and union all command?
What are the limitations of sql express?
Is primary key clustered or nonclustered?
What does 0 mean in sql?
What are different types of statements supported by sql?
Explain what is a column in a table?
Does truncate free space?
Is primary key always clustered index?
What are the 3 modes of parameter?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How do I run a sql trace?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
what is a trigger? : Sql dba
What are all the common sql functions?
What is PL/SQL Records?