Elogix is an incredibly powerful & fully responsive WordPress Theme.
Open
X

Archive for the 'Oracle' Category

Hide sqlldr Oracle Password in PS Command

Posted on February 10th, 2012 · Posted in Oracle, PL/SQL, Unix

Our internal audit team has raised an issue on some scripts exposing database user, password and tns. You see, all you need is an access to unix shell and run.. read more

UTF_FILE and Directories

Posted on November 9th, 2011 · Posted in Oracle, PL/SQL

In case you are maintaining a pl/sql program developed by someone else and that program writes into a file, then basically that file is written to a folder/directory. And since.. read more

Oracle Power Function

Posted on November 7th, 2011 · Posted in Blog, Oracle, PL/SQL

There are some pl/sql functions that you rarely use and we always forget the syntax.And here’s another example — the power function. You know, that’s the n to the power.. read more

Rowcount on Oracle Dynamic SQLs

Posted on August 25th, 2011 · Posted in Blog, Oracle, PL/SQL

A good friend asked me on how to capture the number of affected records on his delete statement. The answer would be as simple as below: DELETE FROM my_table WHERE.. read more

Update Oracle Sequence Last Number

Posted on May 31st, 2011 · Posted in Blog, Oracle, PL/SQL

I only realized this last week that direct update of the last number of the sequence. Or maybe I just don’t know so what I did was to create a.. read more

Input truncated to 1 characters

Posted on April 12th, 2011 · Posted in Blog, Oracle, PL/SQL

That pesky though harmless message “Input truncated to 1 characters” keep on appearing on one of my scripts and I can’t figure out what’s the problem. It turned out that.. read more

Oracle MERGE command

Posted on March 2nd, 2011 · Posted in Blog, Oracle, PL/SQL

Oracle MERGE command was added in 9i but I only learned about it lately. This command is sometimes referred to as UPSERT because in one statement, you can both update.. read more

Oracle PL/SQL Continue Statement in Loops

Posted on February 10th, 2011 · Posted in Blog, Oracle, PL/SQL

The CONTINUE statement is very handy feature when programming with loops in Oracle PL/SQL. Basically, it lets you skip to the next iteration of your loop (i.e., next record in.. read more

Run SQL Script via SQL*Plus via Prompt

Posted on February 9th, 2011 · Posted in Blog, Linux, Oracle

If you want to run an SQL script via sqlplus in the shell prompt, the command is as below. sqlplus user/pass@connect @scriptname Don’t forget that there should be an exit.. read more

Drop/Remove Column in Oracle Table

Posted on August 11th, 2010 · Posted in Blog, Oracle

Here’s a quick post on how to drop a column/field in a table. Dropping One Column alter table table_name drop column col_name1; Dropping Multiple Columns alter table table_name drop (col_name1,.. read more