Technical Notes

We're all on the same page!

Showing posts with label pl-sql. Show all posts

Showing posts with label pl-sql. Show all posts

Friday, 13 January 2017

An example of PL/SQL collection for nested table

DECLARE TYPE employee IS TABLE OF VARCHAR (5); employees employee := employee ('A', 'B', 'C', 'D...

Thursday, 19 February 2015

[ADVICE] Using both of semicolon and slash characters at the same time

Please note that if you use semicolon and slash at the same time in sql queries, there will be executed as twice on the system. e.g. ins...

Monday, 2 February 2015

How to modify "sql page size"?

SQL> SET PAGESIZE 100 Anymore, there will be 100 lines for each page, after executes SQL queries.

Thursday, 18 December 2014

How to use to_date function?

e.g. select to_date('2014-12-18','yyyy-mm-dd') from dual; output: 12/18/2014 select to_date('2014-12-18 12:15',...

Wednesday, 5 November 2014

[CONCAT] How to merge two strings as a single string?

Please run the sql lines in SQL Editor as "hr" user; e.g. select CONCAT('Bilgi havuzu ','at ozsoyler.blogspot.com...

Monday, 3 November 2014

[INITCAP] How to make uppercase the first character of each word in a string?

Please run the sql lines in SQL Editor as "hr" user; e.g. select INITCAP('ozsoyler.blogspot.com') from dual; result ...

View web version

Powered by Blogger.