Tuesday, August 21, 2012

Oracle PL/SQL


For professional reasons, I was forced to study Oracle PL / SQL.


PL/SQL is an imperative 3GL that was specifically designed for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is compiled and stored in Oracle Database and Oracle runs within the executable. It automatically inherits the robustness, security, and portability of Oracle Database.

To study Oracle PL / SQL, I found a great website and I highly recommend.

Wednesday, August 8, 2012

How to install Samba

Since 1992, Samba is an open-source software that your main goal is to remove the barriers of interoperability between different operating systems.

I need Samba to move files from Windows to Ubuntu and vice-versa for work's issues. Hereafter, you can see the steps how to install Samba:

  1. sudo apt-get install samba samba-tools
  2. sudo smbpasswd -a yourusername
    • Type your password
    • Retype your password
  3. mkdir /srv/samba/share
  4. sudo nano /etc/samba/smb.conf
  5. Press Ctrl+W
    • Search for: #security=user
    • remove '#' (from "#security=user" to "security=user")
  6. On bottom of file write the next statements:
  7. [share]
    path = /srv/samba/share
    comment = some random files
    available = yes
    valid users = yourusername
    read only = no
    
  8. sudo restart smbd
  9. testparm /etc/samba/smb.conf

Note: After you typed the last command and got errors message, you have to fix it. But I am 100% sure, it will not show up a error message unless you mistyped some statements.