-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
There can be a scenario where the datatype of the column is VARCHAR or CHAR but values that are suppose… READ MORE
Using the following PL/SQL code one can find average size of a row in a table, the following code samples… READ MORE
|
Table structure in Oracle SQL> desc scott.oracletable; Name Null? Type —————————————– ——– ———- TRANSDATE NOT NULL DATE SEQUENCE_NO NOT NULL… READ MORE
|
Using dbms_lob.getlength(column name) one can find the length of the LOB (CLOB/BLOB/BFILE) data type. Example: SQL> SELECT dbms_lob.getlength(lob_column) FROM scott.lob_table;… READ MORE
|
In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session altered. SQL> SELECT TRUNC(sysdate) FROM DUAL; TRUNC(SYSDATE) ——————– 2009-MAY-10… READ MORE
|
There are few ways to calculate end of day i.e when the time is 23:59:59. In the example below it… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 