Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to Make Trace Files Created by Oracle Readable by All Users ? Oracle
  • upload.html PHP/MYSQL/Wordpress
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • find the files that are 1 day old. Linux/Unix
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • Rollback force for distributed transactions Oracle
  • proper cpu stats Linux/Unix
  • Roles and Stored Object behaviour Oracle
  • tab.sql Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • sql_plan9i.sql Oracle
  • OEM-Commnds Oracle
  • Absolute file number and relative file number Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle

CTAS with LONG Column for 9i and higher

Posted on 28-Nov-2005 By Admin No Comments on CTAS with LONG Column for 9i and higher

Executing CTAS statement having TO_LOB(LONG COLUMN).

For example:

create table blah as

select GNT_ID.nextval, 1060 as gnt_ref_id, org.gnt_id, org.gnt_group_note, org.gnt_language,

to_lob(org.gnt_text_string) as gnt_text_string, org.gnt_text_emphasize

from asra_002.gnt_groupnote_txt org

where org.gnt_group_note in (select gnr_note from asra_002.gnr_groupnote_ref)

Oracle, SQL scripts

Post navigation

Previous Post: CTAS with LONG Column for 7.x and 8 and 8i
Next Post: Optimizer_Index init.ora parameter explaination.

Related Posts

  • How can I tell if ASO is installed ? Oracle
  • fkwoind.sql fkwoindex.sql Oracle
  • oracle Dba site Oracle
  • create database syntax Oracle
  • column level grant syntax Oracle
  • Rman Notes -1 Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • export import with parameter file. Oracle
  • perf_today.sql Oracle
  • To see only files and/or folders using LS command Linux/Unix
  • V$transaction notes for finding XID composition. Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix
  • TRUNCATE table and disabling referential constraints. Oracle
  • Jai Shree Ram Oracle
  • import-export with multiple files Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme