Oracle Help
in [SQL]
|
CLOB > 32k We're trying to insert a value that is like 50,000 characters long into a CLOB column from PL/SQL. It is passed in as a parameter to a CLOB type. Now, from what I am reading 32k is the limit for any variable in PL/ SQL. First, what is the best way to get around this. Second, if 32k is the largest, the how ... 3 Jun 2010 15:37
xaingmei chen bangs Bally Bags On May 28, 11:58 pm, xaingmei chen <chenxain...(a)gmail.com> wrote: sorry, couldn't resist. ... 31 May 2010 16:22
Oraqcle RAC configuration question. Nodes on Unix, ASM on Windows? I have a question about configuring Oracle RAC. I have never done any RAC or ASM installation before. Might be a stupid question for some of you. Is it possible to install Oracle RAC using following options? 2 node RAC ( 2 unix machines running two oracle instances) using Sun Solaris. Shared Storage using ASM... 27 May 2010 10:20
Privileges Database Link We have 2 database which have DB links between. The user in both database have the same name. We cannot figure out how to grant the privileges. SQL> grant select on status to john(a)comm.zacks.com; grant select on status to john(a)comm.zacks.com * ERROR at line 1: ORA-00933:... 26 May 2010 11:19
Any book on Oracle DBMS's internals? Are there any book on Oracle DBMS's internal? Like Microsoft Press's _Inside Microsoft SQL Server 2005_ ... 26 May 2010 11:19
Complex Select I've modified this select statement so that it will take a column from multiple rows and concatenate them and delimit them. The value returned is this: 2:Media","1:Pages","5:Trading","3:Links However, using the query below, I cannot find a way to get the beginning and ending quotes. Help? v_select := ... 20 May 2010 13:52
Oracle Data-Files Binary Format On May 19, 7:51 am, Gerald Breuer <Gerald.Bre...(a)googlemail.com> wrote: One simple question: Is there any documentation on the tablespaces' files binary format? Not as such, but google on oracle tablespace blockdump. You can also use unix od on a static copy of the data files to try to figure things out. ... 19 May 2010 14:52
Developing Query select INQMSIS.mine_tbl.sic_desc, COUNT (INQPROD.ACC_INJ_TBL.AI_DOC_NUM), COUNT (INQPROD.ACC_INJ_TBL.AI_DOC_NUM) * 200000 from INQPROD.ACC_INJ_TBL, INQMSIS.mine_tbl where ((INQMSIS.mine_tbl.c_m_ind = 'M') and (INQPROD.ACC_INJ_TBL.INJ_DEGR_CD IN ('01', '02', '03', '04', '05', '06')) and ((to_number(to_char(INQPROD.... 21 May 2010 12:47
COUNT Function Hi, I'm tryng to use the Analytical function COUNT(*): SELECT tag_id, tag_name, tag_count FROM (SELECT t.tag_id, tag_name, COUNT(*) OVER (PARTITION BY t.tag_id) tag_count, ROW_NUMBER() OVER (PARTITION BY t.tag_id ORDER BY t.tag_id) rnum FROM commentary.article_tags a, commenta... 18 May 2010 07:03
Recommendation needed on Oracle Security Training Has anyone used either of the following? Any thoughts? MIS Training Institue Auditing and Securing Oracle Databases - ASE351 http://www.misti.com/default.asp?Page=10&Type=3&pcID=3468 SANS Securing Oracle http://www.sans.org/network-security-2010/description.php?tid=3882 Anyone have a different course they... 20 May 2010 16:05 |