Explain how can you save or place your msg in a table?
- 1 Answers
- 1115 Views
- I also Faced
- E-Mail Answers
Answer Posted / Kaushambi Singh
To save messages in a table, you can use the DBMS_OUTPUT package in PL/SQL to write the message to the OUTPUT buffer. Then, you can redirect this output to a server-side internal table using DBMS_PIPELINE or directly insert it into a database table using an INSERT statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If a cursor is open, how can we find in a pl/sql block?
What is the best sql course?
How do I remove duplicates in two columns?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what are all the common sql function? : Sql dba
Is primary key always clustered index?
what is dbms? : Sql dba
Is primary key clustered index?
define sql insert statement ? : Sql dba
Is inner join faster than left join?
What is the current version of sql?
What is your daily office routine?
Do we need to rebuild index after truncate?
What is the current version of postgresql?
what is schema? : Sql dba
