MySQL Forums
Forum List  »  Oracle

Re: Regarding print function
Posted by: Dejan Topalovic
Date: February 28, 2007 02:26PM

mysql> DELIMITER $$
mysql>
mysql> DROP PROCEDURE IF EXISTS `dejan`.`print_message` $$
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> CREATE PROCEDURE `dejan`.`print_message`()
-> BEGIN
-> BEGIN
-> SELECT 'this is just a dummy message' AS 'Message';
-> END;
-> END $$
Query OK, 0 rows affected (0.02 sec)

mysql> DELIMITER ;
mysql> call dejan.print_message();
+------------------------------+
| Message |
+------------------------------+
| this is just a dummy message |
+------------------------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql>

http://www.baze-podataka.net/
- Database Consultant & DBA -
Certified MySQL 5.0 DBA
Oracle 9i OCP DBA
Oracle 10g OCP DBA

Options: ReplyQuote


Subject
Views
Written By
Posted
8289
February 17, 2007 12:46AM
Re: Regarding print function
3589
February 28, 2007 02:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.