learning plsql in sqldeveloper

I just started to learn PLSQL. I had only SQLDEVELOPER to access Oracle Database.

When I run following code:

DECLARE 
  title VARCHAR(8);
  salary NUMBER;
BEGIN
  title := 'DBA';
  salary := 50000;
  DBMS_OUTPUT.PUT_LINE('Job Title: '|| title);
  DBMS_OUTPUT.PUT_LINE('Expected Salary'|| TO_CHAR(salary));
END;
/

I get the output "anonymous block completed".

Also, On running the command "set serveroutput on", I get a blank output.

I had other option is to download oracle database express edition and install on the local system.

Answers


In SQL Developer there is a menu option View -> Dbms output which you need to follow to set the serveroutput on for your database connection.

Once done, you will see the DBMS Output window pane, you then need to click the green plus "+" icon to enable serveroutput for your connection.

Other than that, you haven't asked a specific question....


Need Your Help

Search control on WP7/WP7.5

wpf windows-phone-7 xaml windows-phone-7.1 windows-phone

Could anyone tell me which controls are used in WP7 / WP7.5 where we go on e-mails reading, and when we click on the "search" button?

ASP.NET SlideShowExtender retrieving images from web service, but doing nothing when executed

c# asp.net sql-server ajax database

So on my ASP.NET solution's default page, I have a SlideShowExtender object, linked to a WebMethod which retrieves slides from an MSSQL database. Through debugging I can confirm that Slide objects ...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.