What is the difference between SQL table and the PLSQL
table?
Answer Posted / saisravanthi
sql tables are used to store data permanently.pl/sql tables
are used to hold data just like other variables during the
execution of programs.
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is an escape character in sql?
How do I view stored procedures?
How can the performance of a trigger be improved?
What is the clause we need to add in function body to return variable?
What is application trigger?
What is a procedure in pl sql?
What is set serveroutput on?
What are the triggers associated with image items?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is the use of prepared statement?
what are the advantages and disadvantages of views in a database? : Sql dba
What is bulk collect in pl sql?
What is the difference between partition and index?
What is the most restrictive isolation level? : Transact sql
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this