Explain how can you save or place your msg in a table?



Explain how can you save or place your msg in a table?..

Answer / 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

More SQL PLSQL Interview Questions

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1 Answers  


How do I run a query in pl sql developer?

1 Answers  


What type of database is sql?

1 Answers  


how to increment dates by 1 in mysql? : Sql dba

1 Answers  


Explain mutating table error.

1 Answers  


What is an index in sql with example?

1 Answers  


How do you optimize a query?

1 Answers  


What are different functions in sql?

1 Answers  


What is insert command in sql?

1 Answers  


What is rowid in sql?

1 Answers  


Does sql use python?

1 Answers  


how to check myisam tables for errors? : Sql dba

1 Answers  


Categories