MTK nullable Oracle primary key columns

In the MTK 1.3, some nullable Oracle primary key columns being translatedinto not null columns, because they're part of the primary key.Is there a way to change this? ...

Granularity of change rules in CDC (using Oracle streams) at columns level.

Is it possible to implement granularity of change rules in CDC (using Oracle streams) at columns level.E.g. table abc with columns a1, b1, c1 where c1 is some kind of auditing column. I want to use CDC on table abc but want to ignore changes on c1.Is it possible? My other option is to split table ab ...

Oracle Creating VARCHAR2 columns in char mode

I have created an oracle9i database with database character set UTF8. I also have set nls_length_semantics=CHAR in init.ora.Then I created a table with this command:CREATE TABLE FND_SETTING_TAB (PARAMETER VARCHAR2(20) NOT NULL,PARAMETER_DESC VARCHAR2(200) NOT NULL,DYNAMIC VARCHAR2(200) NOT NULL,VALU ...

Oracle Exclude unoccupied columns

I would like to be able to issue a select statement in SQL*plus or use an Oracle view to return data from occupied columns only without having to specify every column name in the table.Is there a way of doing this simply? ...

Oracle selceting single columns from Access Database

after some try and error I managed to create a connection to an Access DB from oracle via Generic Conectivity and ODBC. So now i can do something like "select * from tblTest@accessDB" in sqlplus, giving me the contents of tblTest.This table is very simple, consisting of two columns: text and zahl, h ...

Oracle Create 2 columns from one!!

Good Afternoon Everybody,I wonder if anybody can help me on this problem.We use Oracle 9i on Windows 2000.I need to update a table by extracting data from 5 other tables.So the layout of the new table is as follows,(6 columns)Part---Supplier---QtyPur2003---£2003---QtyPur2004---£2004 As you can ...

Oracle selecting varbinary columns in SQL db

I have a working database link (HS) from Oracle 8 to MS SQL2000.This works fine and through this link I am able to select, insert & update tables on SQL2000 server.However I cannot access columns of type varbinary on SQL.Any ideas on how to work around this without modifying table on SQLJames ...

Oracle Missing Condition Columns

I exported an application out of HTMLDB.ORACLE.COM (v1.6). I imported it to our internal HTML DB v1.6. The application runs with no problems. I am trying to add an additional Condition Column to a Structured Query report page in our internal HTML DB. The drop down list to select the column only has ...

Oracle Show/hide columns

Carl:Regarding your show/hide columns example athttp://htmldb.oracle.com/pls/otn/f?p=11933:46Seehttp://htmldb.oracle.com/pls/otn/f?p=24317:129What if I have 2 report regions on the page having some common column headings? HTML DB generates the same ID for the TH tags for both of them, so given a col ...

Oracle SQLServer table columns cannot be SELECTed

I am trying to access a table in SQL server from Oracle 10g.I have created a db link to a SQL server 2000 database. I am able to access a table from that database as:select * from usermaster@uecs ;All columns in the table are displayed.However, if I doselect LanID from usermaster@uecsI get an error ...

Oracle Index on columns that are subtracted

I've a huge partitioned table that has some basic indexes which works for most of my queries.But one of the queries is having a performance problem and only this query has a condition that subtracts one column from another. I dont have indexes on either of these columns. This is how it looks -SELECT ...

Oracle SUM of columns scattered in different tables.

I have a problem in oracle. here is the scenario.consider 26 COLUMNS that have names ending in word "DELTA" e.g. a_DELTA , b_DELTA ..... Z_DELTA.now these 26 columns are scattered (at random) in 10 tables ( which further we do not know names of).what i need is sum of all these 26 columns. is this po ...

Oracle Indexing multiple columns across multiple (unrelated) tables

I'm working on a general site seach which needs to search up to about 20 unrelated tables. I've managed to get a basic version of this working using Oracle Text (10g) with a materialized view, but I'm not sure how this will perform when the table sizes grow (say in the region of 100s of 1000s of rec ...

Oracle encrypt a columns and security

Is it possible to encrypt columns X of a tables such that only application user is able to decrypt and show the original value via application and DBA and developers are not allowed to see decrypt values via SQLPlus or any dev tools.Please provide any Oracle links / docs where I can find out more ab ...

Oracle select all columns and "level" in connect by statement

I am hoping someone can help me here.I have a program that pulls hierarchtical data using Connect By statements. The table it is pulling from has 38 columns. I would like to be able to run a select for all columns and level in the Connect By statement, without having to specify every single column. ...

Oracle Compare the columns of two tables

Hope all of you Oracle masters are fine I want to ask little SQL query to compare the coulumns in two tablesI have two tables students and Students_Reg........the student has columns (Registration,enrollment,program)the student_CMS columns as(registration,enrollment,program,year........I want to com ...

Oracle Adding New Columns to a Partitioned Table

I have a paritioned table Table A. Now i want to add 2 new columns say COL 1 Varchar2 and COL2 Number.Will this alteration affect the data distribution. I want know whether the partition definition will be applicable on these columns or not.I am working on Oracle 10g R2 ...

Oracle Hide/Show columns using AJAX doesnt work in 'Light Blue' theme

I could develop apex report with hide/show columns feature. It does work in all the themes except 'Light Blue' theme. I have tried the code given by Carl Backstrom and Vikas. 'Light Blue' theme doesnt work for both, but works for other themes.Below is the application provided by Vikas:http://apex.or ...

Oracle Sum Dynamic Columns

I have a workspace at http://apex.oracle.com/pls/otn/f?p=4550:1 to demonstrate my problem. The workspace is Madison, the username is dtech, the password is abcdefg. The application is called Dynamic_Parameter_Pg_appl_1.I created a dynamic parameter page based on values in certain tables. When the us ...

Oracle Number of columns in a tabular form

I have a case where the customer wants to have an updatable tabular form with more than 50 columns (don't ask me who can control update of more than this number of columns). I noticed that as soon as I include more than 50 columns, the update process will not work:Page not foundas soon as I try to u ...

Oracle Convert multiple columns to single column & multiple rows

I am working on converting multiple columns in a table to a single column and multiple rows. The number of columns in the table can vary per record. Not all columns have a value for each record. The current table I am working on has a record with 85 columns having a value..but I anticipate that this ...

Oracle Import certain columns by Datapump

Is there possibility to import just a few columns of table (with or without metadata) via Oracle Datapump? I'm talking about filtering data not by rows (it can be done using dbms_datapump.metadata_filter) but by cols? ...

Oracle Dynamic report columns in parameterized report

Just wanted to share some ideas... I was looking for a way to allow users to seect which columns to display in a parameterized report.I came across Denes Kubicek's solution on his APEX demo site (the "Pick Columns" page)... works beautifully.The only problem I had was that some of the report columns ...

Oracle View with columns based on function - problem with query

I'm using Oracle 9i;I've created a view which has columns based on a table columns (multiple columns from 1 table) and funtion (multiple columns based on 1 function).The function takes ID as the first argument and name of the column to determine which value to return as the second one.Here is a samp ...

Oracle Dropping?adding columns to a compressed table

HiOracle 10.2Is there an easy way to drop and add columns to a compressed table?I have tried for dropping by setting the column to unused and then dropping unused columns but i get the following errorORA-12996: cannot drop system-generated virtual columnIs there anyway round this. ...

Oracle reorganizing table columns

working on oracle 10g R2 /Windows, I need to reorganize a table containing at least 50 columns.Original TableSQL> desc EMP Name Null? Type -------- ALL_CUSTOMER_ID NOT NULL NUMBER(9)NAME VARCHAR2(65)ALL_CUSTOMER_TYPE VARCHAR2(1)FIRST_NAME VARCHAR2(65)LAST_NAME VARCHAR2(65)SALUTATION VARCHAR2(5).. ...

Oracle Search all columns in a table

I have an application which deploys the data to Oracle database. It has more than 25 tables and many columns. It does not have any document explaining the deployment, so I an kind of doing reverse engineering here.I need a script which will fetch the column name or at least table names which will ma ...

Oracle Object table columns SYS_NC_OID$, SYS_NC_RWOINFO

Can anybody explain about the columns SYS_NC_OID$, SYS_NC_RWOINFO that are being generated by oracle while creating the object tables. I also read that an Index and a primary key is generated for column SYS_NC_OID$. I need more details about these columns. Do we have any other columns that are being ...

Oracle Indexing multiple columns, and adding new documents to index?

Hi. I'm new to SES and have a few questions.1. I'm trying to index an oracle table that has several columns with content. Is it possible to index more than one column? I see a dropdown that lets you pick one "content column", which suggests that I can't do this. I'm using the "table" source type, wh ...

Oracle Rows to Columns

With Oracle 10g.I have a script for pivoting rows to columns in the case of emails that are in a ‘phone’ table.SELECT phnid,max (CASE WHEN phntype = 'email' THEN phnnumber END) AS email, max (CASE WHEN phntype = 'email1' THEN phnnumber END) AS home_email,max (CASE WHEN phntype = 'email2' THEN ph ...

Oracle Indexing multiple columns in multiple tables

I have a multiple tables in which I want to search. I need to do text search that supports fuzzy logic for which I've currently set up a context index using the user_datastore. I also need to search columns such as numbers/dates/timestamps which from what I understand is not supported with the conte ...

Oracle Dropping 4 columns takes approx 20 minutes

When dropping 4 columns, the database takes approximate 20 minutes to perform the task.Is this okay as regards the timings? Are we missing out on any performace aspect here?We are on 10g Oracle.Many thanks for all the help.Best ...

Oracle Excluding null columns in a custom vertical report template.

I am creating a customer vertical report template and I wish to exclude null columns.the article on custom reportshttp://www.oracle.com/technology/pub/notes/technote_htmldb_format.htmldoes not state how to do this. Any suggestions? ...

Oracle Updating multiple columns of a table

I'm using Oracle 10gI've two tables with the following fields:table1 : OTNAME table2 : SNCODE, description_textI'm trying to add the two columns of table2 to table1 and update the columns. My query is:alter table table1 add sncode integer alter table table1 add description_text varchar2(30)   u ...

Oracle Length of columns in lcr$_row_record type?

How does one determine the maximum length of columns in Oracle types such as sys.lcr$_row_record? Hopefully there's a simple answer to this.I'm trying to insert values from a LCR into a table. I was using an example I found in the Oracle 10gR2 doc which used varchar2(10) for the value of the transac ...

Oracle Report Checkbox Columns in CSV Export File are NULL

Hoping someone can assist. Am using Oracle ApEx 3.0.1.I have a report that consists of a number of checkbox columns where I am using the Apex_Item.checkbox with a disabled attribute. My questions is, when I attempt to export this report to CSV format, the columns referring to the checkboxes are show ...

Oracle Order of columns in select statement

If I have a table t1 with columns created in order c1, c2, c3, what will be the difference (performance wise) in the below two queries:select c1, c2, c3 from t1;select c3,c1,c2 from t1;I know that if I change the order of columns in a table (by dropping, recreating ofcourse), it can break some appli ...

Oracle compare 45 columns and update one table col

I am using Oracle 9i database.I need to compare each record between two tables and update the one of table column (what records are updated) CURSOR cur1 is select t1., t2. from t1, t2 where t1.primarykey = t2.primarykeyFOR rec1 IN cur1 LOOP.....IF rec1.t1_col_1rec1.t2_col_1thenupdate t1set col_t1.re ...

Oracle Sorting on Columns with null values

I have noticed the following behavior in my APEX 3.2.1 application. Sorting on columns that do not have null values works fine. However, when you sort on a column that does have a null value, the sorting is not performed correctly. What happens is that the fields with null values no longer display a ...

Oracle Export CLOB columns?

I need to migrate my oracle application to a mysql database ;-(How may I export clob columns` ...

Oracle Ordering 20 columns

i have requirement of ordering 20 columns.. from the 20 column selection.the only possible way is select ...15 columnsorder by 1,2,3,........15...?i am using oracle 9i.any other clues..?S ...

Oracle number of columns and its effect

We are on oracle 10.2.0.4 on Solaris 10. We have a table with 64 columns most of which are nullable. When I do a simple from this table , it takes 5 seconds for 19 rows...the table has 8 million rows in production.I mean select * from table_name from rownum<20 takes 5.20 seconds.is there a way to ...

Oracle number of columns on a view

I use Windows XP with Oracle 10g 10.2.0.1.0Would anyone please shed a light how to count the number of columns on a views; ...

Oracle Transpose of columns to rows (unpivoting) and not rows to columns

I am right now using oracle 10g. I HAVE the following specification. Here I specified only 5 columns.We have upto 200 columns. TRANS_ID PORTFILIO_NUM TICKER PRICE NUM_SHARES ........................................ 2 100 MO 25.00 100 ........................................3 100 MCD 31.50 100 ...... ...

Oracle Compare two columns

Is there a way to use oracle text to compare two columns and show the difference between those by highlighting it? I tried searching the forum and using google but couldn't find anything (maybe I was just using wrong wording).Denes Kubicek http://deneskubicek.blogspot.com/http://www.opal-consulting. ...

Oracle nonkey index columns

I have a table with about 40 columns. Unfortunately I have to scan one of those columns with a like %string% query, which means I'm always going to have to scan the whole table. Since many of the columns are wide, this takes a long time. What I would like to do is put an index on the column I'm doin ...

Oracle Rows to columns

I have the following (test) table:CREATE TABLE test_table ( field1 INTEGER, field2 VARCHAR2 (10), field3 VARCHAR2 (10), field4 VARCHAR2 (10) );   INSERT INTO test_table (field1,field2,field3,field4) VALUES (1,'random12a','random13a','random14a');   INSERT INTO test_table (field1,field2,fie ...

Oracle LOV Search columns Case

Release .4 adf My question is how to make a input text LOV search column case insensitive. I have mapped 2 columnsPhone Lov BasedBldg When the search popup is displayed the Phone and Bldg columns are used to search. How can I set the Bldg to case insensitive chuck Note: 7/2/2011 -- I have come to th ...

Oracle Dragging the columns to existing logical table source.....

I am just learning OBIEE 11g and I am using a turorial from oracle it is"Creating a Repository Using the Oracle BI 11g Administration Tool" for practice purpose.In this tutorial it is saying that drag that columns from phscial layer to Logica Table Source in BMM Layer to avoid creating a second logi ...

Oracle Cannot modify columns

HiI need to add NOT NULL constraints to some new columns I've added to a table. I get a syntax error when I use the standard syntax. Please suggest another approach.SQL> alter table Fillings modify OrderType varchar2(15) not null;alter table Fillings modify OrderType varchar2(15) not null*ERROR a ...