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


Please Help Members By Posting Answers For Below Questions

What is an escape character in sql?

562


How do I view stored procedures?

539


How can the performance of a trigger be improved?

588


What is the clause we need to add in function body to return variable?

538


What is application trigger?

539






What is a procedure in pl sql?

543


What is set serveroutput on?

642


What are the triggers associated with image items?

617


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

551


What is the use of prepared statement?

536


what are the advantages and disadvantages of views in a database? : Sql dba

529


What is bulk collect in pl sql?

529


What is the difference between partition and index?

482


What is the most restrictive isolation level? : Transact sql

554


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

1063