DevExper: oracle

Showing posts with label oracle. Show all posts

Tuesday, April 28, 2015

You can use the following code to get system time as varchar in Oracle ls_current_timestamp VARCHAR2 (14) := SUBSTR (TO_CHAR (SYSTIMEST...

sql

C.GULDOGAN 8:17 AM

To Alter column size in Oracle you may use the following query. It helps if your size of input doesn't fit your column. ALTER TABLE...

C.GULDOGAN 6:55 AM

You can find oracle package errors by executing the query below. select e.owner,e.type,e.line, e.position,e.text, substr(s.text,1,500) sour...