• RELEVANCY SCORE 3.27

    DB:3.27:Columns Within Table Cells jf





    Is it possible to have more than one column within a table cell?

    DB:3.27:Columns Within Table Cells jf


    Table Split Cell Vertically. This will turn the cell into two cells, each half as wide as before, so the rest of the tables layout is unaffected.

  • RELEVANCY SCORE 3.27

    DB:3.27:Retrieve Identity Columns With Rexx Api (Address Ncdb) d1





    I have a user-defined sybase table with an identity column 'id'. If I use isql I can use "select id from table" and receive a list of all id values. If I use within a REXX script "address NCDB 'select id from table'" and then loop with "address NCDB 'fetch'" over all entries, the 'id' values are all NULL.Any ideas?

    DB:3.27:Retrieve Identity Columns With Rexx Api (Address Ncdb) d1


    Here is an example of how to select all the values in a column
    br /#!/usr/nc/bin/ncrx -sbr /br /sql = 'select attribute from configuration'br /br /address NCDB sqlbr /do foreverbr / address ncdb 'fetch'br / if sqlcode ^= 0 then leavebr / say attributebr /endbr /

  • RELEVANCY SCORE 3.27

    DB:3.27:Retrieve Table Constraint pp




    I have made a few table with check constraint
     
    is there anyway that i could retrieve the constraint (Check) conditions for the particular table or columns?
     
    Like in a Query

    DB:3.27:Retrieve Table Constraint pp

    I also found that scripting the table by right clicking on it in the management studio's object explorer is very helpful.  It will dump out all the details of the table to a new query window, the clip board, or to a file.

  • RELEVANCY SCORE 3.23

    DB:3.23:Is There Any Way To Retrieve All Columns Ecxept One In Single Select Statement In Sql? 9f


    I have 15 columns in a table and I want to retrieve all except one.
    Can I make this in a single SQL statement?

    DB:3.23:Is There Any Way To Retrieve All Columns Ecxept One In Single Select Statement In Sql? 9f


    I have 15 columns in a table and I want to retrieve all except one.
    Can I make this in a single SQL statement?

    Hi Ahilan Carpenter,
    I think we have to use dynamic SQL to build the SELECT statement.
    For example,

    USE Northwind
    GO

    DECLARE @cols NVARCHAR(2000)
    DECLARE @sql NVARCHAR(4000)

    SET @cols = STUFF((
    SELECT ,+name FROM sys.columns WHERE object_id = OBJECT_ID(Ndbo.Products)
    AND name UnitPrice FOR XML PATH()),1,1,)

    SET @sql = SELECT + @cols + FROM dbo.Products
    EXEC sp_executesql @sql

  • RELEVANCY SCORE 3.20

    DB:3.20:Attempt To Open A Table Failed - There Were No Columns To Retrieve Were Specified dp


    Hi Guys,
    Please suggest same application is running in my system perfectly. We delivered the patches to the client, there they got a error
    Attempt to open a table failed - there were no columns to retrieve were specified.
    In particular place only.

    Please guys if you know the answer kindly share with me what could be the problem.

    Regards,
    Lakshmi

    DB:3.20:Attempt To Open A Table Failed - There Were No Columns To Retrieve Were Specified dp

    Hi Lakshmi,
    Thank you for posting in the MSDN forum.
    According to your error message, I suggest you could try
    jdweng’s suggestion to check your application.
    In addition, could you please tell me which kind of application you want to create? Is it related to the SQL?To further help you make sure the issue,
    please provide us more detail information about your issue.
    Best Regards,

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HEREto participate the survey.

  • RELEVANCY SCORE 3.17

    DB:3.17:Table Name Lists From Db 13


    How to retrieve all user tables name and relative columns name from DB?

    PoCat...

    DB:3.17:Table Name Lists From Db 13

    Please see the data dictionary tables.
    Among others, there are: user_tables, all_tables, all_objects, all_tab_columns (in the SYS schema).
    RTM first!

  • RELEVANCY SCORE 3.13

    DB:3.13:Aspnet_Profile Accessing (Property Names Propertyvaluesstring) z8


    I have been trying to access the PropertyNames and the data contained with in the PropertyNames and PropertyValuesString (aspnet_Profile Table). I have data contained in those Rows but can't seem to retrieve the data via SqlDataSource.
     
    When i use a SqlDataSource with a  FormView and configure the SqlDataSource the PropertyNames and PropertyValuesString isn't listed. In Specify columns from a Table or View
     
    The only Columns that are showing up for the aspnet_Profile Table in (ASPNETDB)...
     
    *
    UserId
    LastUpdatedDate
    DataSize
     
    So how can i retrieve the information contained in the PropertyNames PropertyValuesString??

    DB:3.13:Aspnet_Profile Accessing (Property Names Propertyvaluesstring) z8

    I solved this ith a little ingenuity and math using SUBSTRING AND CHARINDEX commands keep in mind how this works; SUBSTRING command will pull characters from any string SUBSTRING ([name of table], [start point], [amount of characters to pull out]) -- the start point could be a word or a number--
     
    CHARINDEX is the charcter count at a point CHARINDEX ([place to start],[table name]) -- place to start could be a word or a number
     
    LEN will count the total amount of characters in a column (except ntext or text) since aspnet_profile is ntext we need to cast it
    THIs SCRIPT WILL BREAK THE Popertynames column
    select propertynames, propertyvaluesstring, substring(propertynames, charindex('Firstname:',propertynames)+12,charindex('Lastname:',propertynames)-14) as firstnamechar,
    substring(propertynames, charindex('Lastname:',propertynames)+11,
    LEN (cast(propertynames as varchar(200)))-(charindex('Lastname:',propertynames)+11 )) as lastnamechar
    from aspnet_profile
    SCRIPT BELOW will create the temporary tables and display the information I need
    /*drop table #tempprofiledrop table #tempprofilefinal*/select UserID,PropertyNames,PropertyValuesString,substring(propertynames, charindex('Firstname:',propertynames)+12,charindex('Lastname:',propertynames)-14) as firstnamechar,substring(propertynames, charindex('Lastname:',propertynames)+11, LEN (cast(propertynames as varchar(200)))-(charindex('Lastname:',propertynames)+11 )) as lastnamecharinto #tempprofilefrom aspnet_profile
    select *, substring (propertyvaluesstring,1, cast(substring(firstnamechar,3,2) as int)) as firstname,substring (propertyvaluesstring, cast(substring(lastnamechar,1,charindex(':',lastnamechar)-1) as int)+1, cast(substring(lastnamechar,charindex(':',lastnamechar)+1,2) as int)) as lastnameinto #tempprofilefinalfrom #tempprofile
    select UserID, firstname,lastname from #tempprofilefinal
    This worked for me having Firstname and Lastname profiles.
     
    Good Luck!!!

  • RELEVANCY SCORE 3.12

    DB:3.12:Retrieve Primary Key Information za


    Hi,
    How can i retrieve which tables have composite primary keys, and only one of the primary key columns is a foreign key to another table?

    Like:
    CREATE TABLE club (
    clubId NUMBER,
    name VARCHAR(20) NOT NULL,
    PRIMARY KEY (ClubId)
    );

    CREATE TABLE team (
    teamid NUMBER(10),
    clubid NUMBER(10),
    teamname VARCHAR(10) NOT NULL,
    PRIMARY KEY (teamid, clubid),
    FOREIGN KEY (clubid) REFERENCES club (clubid));So in this case, the team table

    DB:3.12:Retrieve Primary Key Information za

    Hi,

    Here's one way:
    WITHgot_column_cntAS
    (
    SELECT cl.owner
    , cl.constraint_name
    , cl.table_name
    , cl.column_name
    , cn.constraint_type
    , COUNT (*) OVER ( PARTITION BY cl.owner
    , cl.constraint_name
    )AS column_cnt
    FROM all_constraints cn
    JOIN all_cons_columns cl ON cl.owner = cn.owner
    AND cl.constraint_name = cn.constraint_name
    WHERE cn.constraint_type IN ('P', 'R')
    AND cl.constraint_nameNOT LIKE 'BIN$%==%'-- exclude purged constraints
    )
    SELECT DISTINCT
    r.owner
    , r.table_name
    FROM got_column_cnt r
    JOIN got_column_cnt p ON p.owner= r.owner
    AND p.table_name= r.table_name
    AND p.column_name= r.column_name
    WHERE p.constraint_type = 'P'
    AND r.constraint_type = 'R'
    AND p.column_cnt 1
    AND r.column_cnt = 1
    ;It's a little unclear what you want.
    This query shows tables where the same column is part of a multi-column primary key, and is also a single-column foreign key. I does not check how many such columns there are in the primary key. That is, it would still return TEAM if team.team_id (by itself) were a foreign key.

    The data dictionary views ball_/bconstraints and ball_/bcons_columns includes information about all tables that you have privileges to use.
    You could also use buser_/bconstraints and buser_/bcons_columns, which only include tables in your own schema.
    If you have priovileges to use them, you could also use bdba_/bconstraints and bdba_/bcons_columns, that include all tables in the database.

  • RELEVANCY SCORE 3.12

    DB:3.12:Olap Drill Through Maximum Number Of Records To Retrieve Property For Excel 2003 j1


    By default, an OLAP drill into details drill through will retrieve the first 1000 records.

    We arelookingthe option to change this limitationwithin Excel 2003.
    It is available in Excel 2007 as:
    Drill Through This action queries the cube based on a condition specified in an MDX statement and returns data from the fact table that is the source of the measure's aggregated values. The data is displayed in a
    worksheet as an Excel table. The MDX statement specifies which columns should be returned from the fact table and the maximum number of records to return, specified in the
    Maximum number of records to retrieve property under the
    OLAP Drill Through section on the Usage tab of the
    Connection Properties dialog box. For more information, see
    Connection properties.
    What is the equivalent method within Excel 2003 ?
    Can this be controlled within a VBA callfor either version ? (to inplement a similar solution for both).
    Thank you,

    John Mathieu
    eRAP Enterprise Admin
    IDS-Business Intelligence Svcs(BIS)
    John.Mathieu@thehartford.com

    DB:3.12:Olap Drill Through Maximum Number Of Records To Retrieve Property For Excel 2003 j1

    Jaynet,
    We are not using the PerformancePoint server so we do not have access to this add-in. Is there another add-in available that provide us access to these sample capabilities since they are not available within Excel 2003 natively ?
    Specify the maximum number of rows that are returned by drill-through in Excel 2003 or Excel 2007

    On the PerformancePoint menu, click Advanced, and then select
    Options.In the Limit the rows returned by drill through to box, either select or type the number of rows.

  • RELEVANCY SCORE 3.10

    DB:3.10:Create Index With Included Columns 1s



    How do you create a covering index within tran se11 to "include" columns. Do you create the index within SAP ABAP dictionary and then use SQL Server/database tools to then add the included columns? And if you do this will it removed during an upgrade or patch that alters that table?

    DB:3.10:Create Index With Included Columns 1s


    Link is dead, Matt Peters is offline since 2010 ...

    But there is a solution

    Note 1775008 - Definition of index include columns for MSSQL server

    Kind regards, Rudi

  • RELEVANCY SCORE 3.09

    DB:3.09:Query Problem sj



    hello.
    i have a table and also more than 50 columns.
    i wanna retrieve datas which values are 0 only.not 1. with combobox

  • RELEVANCY SCORE 3.08

    DB:3.08:Linq Query To Retrieve Most Recent Price Per Product 3j


    image a table

    Id

    Product

    Year

    Price

    1
    A
    2011
    10

    2
    A
    2010
    9

    3
    B
    2011
    6

    4
    B
    2010
    5

    5
    B
    2099
    4

    How can i write linq query to retrieve the record with themost recent price per product.
    So in this example retrieve record 1 and 3?
    king regards
    voilbak
    PS : i want to select all columns for therecord

    DB:3.08:Linq Query To Retrieve Most Recent Price Per Product 3j

    Hi,
    you are looking for order by year and then by key?

    var result = products.OrderByDescendingProduct, long(p = p.Year).ThenByDescendingProduct, int(p = p.Id).ToList().FirstOrDefault();

  • RELEVANCY SCORE 3.08

    DB:3.08:What Is The Maximum Number Of Columns Allowed On A Table? 1k


    What is the maximum number of columns that a table can have? I have a research team that wants to have 140,000 columns on one table and 2000 rows.

    What would be the best way to input (SQL*Loader?) that data on this table and retrieve data from this table? The highest number of columns that I have implemented on a table was 500.

    Any feedback would be greatly appreciated.
    Thanks. ;-)

    DB:3.08:What Is The Maximum Number Of Columns Allowed On A Table? 1k

    Thanks.

    I know it sounds quite a bit off track for a relational database.
    But, this is a very unique project having to do with number crunching. I tried to explain that it could not be done that way - but they insisted I investigate further.

    Thank you for the good info.

    Judy ;-)

  • RELEVANCY SCORE 3.07

    DB:3.07:Retrieving Table Name For A Specific Columns z7


    When you retreive column attribute with OCI, you can retrieve things like:

    OCIAttrGet((dvoid*) mypard, (ub4) OCI_DTYPE_PARAM,
    (dvoid*) dtype,(ub4 *) 0, (ub4) OCI_ATTR_DATA_TYPE,
    (OCIError *) oci - errhp )

    DATA_SIZE, etc.

    Is there any way to retrieve the table name for this column.

    This could be very usefull in a join sql statement

    DB:3.07:Retrieving Table Name For A Specific Columns z7

    No. The best yoiu can do is to look it up in all_tab_cols (using the schema name and column name as keys) but that might not help if there are duplicates. I guess it is assumed that you pulled the column describe handle from a describe of a table (for which you knew the name).

  • RELEVANCY SCORE 3.07

    DB:3.07:Populate Column Names Within Drop Down xx


    guys,

    i am trying to retrieve all column names from a table and displaying it to the user. but instead of displaying something like user_username, user_password etc as column names, I would like to retrieve this data and display something more user friendly like Username, Password etc.

    So I have managed to obtain the relevant data from the db tables as follows,
    ResultSet rsColumns = getColumns (null, null, getTable(), null);
    List columns = new ArrayList();
    while (rsColumns.next()) {
    columns.add(rsColumns.getString("COLUMN_NAME"));
    }
    String s = columns.toString();
    );
    setColumnList(columns);
    rsColumns.close();

    now s contains my list of all columns, I want to take this list, break it up and associate each column name with a friendlier name. so essentially when this information info is displayed on a drop down menu, it should display Username and not user_username (which is the liternal column name). but at the same time, when the user selects the option, i want to pass on the actual column name to my java code. so only the front end info should be user friendly.

    i hope i have been able to explain myself. please help me out.
    thanks.

    DB:3.07:Populate Column Names Within Drop Down xx

    hi,
    map the column names to their respective user-friendly names using hash map or any collection interface thats fits in best..

  • RELEVANCY SCORE 3.07

    DB:3.07:Delete Timeouts - Varbinary(Max) Column x7


    I have a similar problem to the following thread http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/65e8066c-9dc7-41b7-a25b-59f483d88dcb/ I am using SQL Server 2008 and have a table with 3 columns, one primary key identity column, one the file name and the other varbinary(max) column to store the uploaded files.I am able to retrieve and insert data within few seconds. But if i wanna delete one record using my primary key. It takes more than 10 mins and timesout.Any possible reason and a solution??Regards,Ganesh

  • RELEVANCY SCORE 3.07

    DB:3.07:Order Of The Columns In A Htmlextendeddatatable jc



    Does anyone know how can I retrieve the order of the columns from an HtmlExtendedDataTable object after changing the places by drag and drop?

    I want to export the table to XLS and when I call getChildColumns() it returns the columns always in the default order.

    DB:3.07:Order Of The Columns In A Htmlextendeddatatable jc


    moving to RichFaces space from RichFaces Development.

  • RELEVANCY SCORE 3.04

    DB:3.04:Is It Possible To Retrieve The Value Entry For A Specific String Id In A String Table? mx


    Hi,
    I'm new to using the String Table in a Resource File(.rc). I can see that the String Table contains three columns: ID, Value and Caption. I know that I use CString.LoadString() to retrieve the Caption given the ID. However, is a way to retrieve the Value
    when you have the ID?
    If so, can I also then retrieve the Caption using a Value?

    Thanks!

  • RELEVANCY SCORE 3.03

    DB:3.03:Retrieve New Value Rather Than Old Value When Firepartialaction Even Called 87


    Hi OAF Gurus,

    I have an advanced table where I enter a value. This table is populated using a vo.

    (1) Now, i have a firepartialaction with a parameter with one of the columns in the table.
    (2) I notice that when I change a value and hover out of that column, the parameter is picking up the OLD value from the table.
    (3) Question is, how should I pick up the new value?!!?! If creating a parameter against the firepartialaction event will NOT retrieve the NEW value, what is the best why to retrieve it?!?!!?!??!

    THANKS!

    DB:3.03:Retrieve New Value Rather Than Old Value When Firepartialaction Even Called 87

    In the parameters of the firePartialAction, you must be passing some parameters to get the resultant values in the CO.
    In general the format is ${oa.ViewInstance.AttributeName}

    For your case try using ${oa.*current*.AttributeName}
    This will give you the new value.

  • RELEVANCY SCORE 3.02

    DB:3.02:Select Statement 3j


    Hi,

    I am trying to do this:

    SELECT cust_id , (*) from customer

    How do i retrieve my first column with the column I want and retrieve the rest of the columns of my table?

    DB:3.02:Select Statement 3j

    SELECT cust_id , c.* from customer cbut this also select the cust_id again.

    If you don't want that, you have to name each column in the order you want.

  • RELEVANCY SCORE 3.02

    DB:3.02:Tableview Sort Events kz


    How does one register to a TableView sort event. I want to respond to a user sorting the table through the UI columns click, and retrieve the new sort order list of objects in the table? Should I register a TableColumn event handler, and if so what is the event type?

    Thx - Joe

  • RELEVANCY SCORE 3.02

    DB:3.02:How To Retrieve Data In Adjacent Columns? 3x


    Hi all,
    I am working a report where I need to retrieve data based on a condition into adjacent columns varying on the condition.
    Suppose if I have numbers in a column in a table, I want to put 1-100 into coln A and 100-200 into coln B.
    Is there any possibility I can do that?
    How?
    Ayone Please help me in this regard!!

    Thanks in Advance,
    G

    DB:3.02:How To Retrieve Data In Adjacent Columns? 3x

    SQL select * from dept;

    DEPTNO DNAME LOC
    ---------- -------------- -------------
    50 TEST REDWOOD
    10 ACCOUNTING NEW YORK
    20 RESEARCH DALLAS
    30 SALES CHICAGO
    40 OPERATIONS BOSTON

    SQL select (case when deptno between 10 and 30 then deptno else null end) cola,
    2 (case when deptno between 31 and 99 then deptno else null end) colb
    3 from dept
    4 ;

    COLA COLB
    ---------- ----------
    10
    20
    30
    40
    50

    SQL

  • RELEVANCY SCORE 3.01

    DB:3.01:Indesign ks



    Hello. Could someone please tell me how I can add columns of text within a table in InDesign?

    DB:3.01:Indesign ks


    A cell which appears to contain two columns may actually be two cells with the color/weight of the border between them set to none. In that case, the header cell is merged.

    OR, you could get that by nesting a 2-column, single-row table (with no visible borders) in the cell.

    OR, you could get it by nesting a 2-column text frame in the cell.

  • RELEVANCY SCORE 3.01

    DB:3.01:Reorder Columns In Pl/Sql cc


    Hello, is it possible "reorder columns" in a table?

    I mean move columns to anothe position in the table!

    DB:3.01:Reorder Columns In Pl/Sql cc

    Xavi wrote:
    Hello, is it possible "reorder columns" in a table?

    I mean move columns to anothe position in the table!Why don't you recreate the table?

    1. Rename the existing table.
    2. Drop the primary key constraint.
    3. Re-create the table with the correct column order.
    4.List item
    5.Run INSERT INTO .. SELECT to move the data from temp to the table in step #3.
    6. Drop the temp table.

  • RELEVANCY SCORE 3.01

    DB:3.01:Get Table Columns Inside A Trigger cs


    I am currently working on triggers. Is there a way to retrieve all the columns of the table where the trigger is associated to? I got a way to get columns a table using the query below.

    select column_name from all_tab_columns
    where table_name = 'tablename'
    and owner = 'ownername'

    But is there other way?

    DB:3.01:Get Table Columns Inside A Trigger cs

    I'm not sure that I really understand your "dynamically requirement" (but no worry for me, APC will provide fast corrections ...)

    Anyway what is forbidden in trigger code is not forbidden in procedures and functions.

    Calling a procedure in a trigger open few possibilities what in trigger code is not possible.

    Cheers!

  • RELEVANCY SCORE 3.01

    DB:3.01:Retrieve A Selected Column And Then The Rest Of The Columns From The Table s7


    In Oracle's SQL, i want to retrieve the salary column first and rest of the columns in the table.

    SQL select sal, * from emp;
    select sal, * from emp
    *
    ERROR at line 1:
    ORA-00936: missing expressionHow can i do that?

    DB:3.01:Retrieve A Selected Column And Then The Rest Of The Columns From The Table s7

    How can i do that?See Re: How to re-arrange columns when outputting a SELECT statement?

  • RELEVANCY SCORE 3.01

    DB:3.01:Table Of Data s7


    I need a suggestion for creating a table (10 rows 7 columns). I need to be able to access specific cells within this table. As well, columns would not contain the same data types.

    I am new to java, so as you can imagine working with a multidimensional array is causing me to go prematurely grey. If somebody was willing to show me a code sample to create the array, assign values and retrieve values, I would be an extremely happy person.

    Or, if there is a better way to store the data in memory then I would be equally happy if I could be pointed in that direction as well.

    Thank you in advance,
    Mike

    DB:3.01:Table Of Data s7

    That's fine. I thought you meant that a single column could hold Strings, ints, dates etc. Different data types in the one column.

  • RELEVANCY SCORE 3.00

    DB:3.00:Space Delimited Or On Multiple Lines Input Values zs


    I have a table with 10 columns,
    the table name is like "test"
    I need to retrieve values based on input values in the where condition
    the columns are like aa,bb,cc,dd, ................,JJ all are varchar2 fields
    i want to write a query with space delimited or on multiple lines input values.

    How to write the query

    Thanks,
    Mahesh

    DB:3.00:Space Delimited Or On Multiple Lines Input Values zs

    Here the steps that u should do:
    1. use execute immediate because it has a string parameter that u can construct. So it it very dynamic.. u can write what ever query using that.
    2. For the input, try to parse the input... keywords: stringtokenizer.

  • RELEVANCY SCORE 3.00

    DB:3.00:How To Get Table Size fz


    I am using JPA.

    1) I want to know how can I retrieve the size of the table rather than doing a "Select *"

    2) I have a table with 10 columns. I am interested in only two columns. So I am doing this query as
    "Select a.id, a.name from Person a" I am not getting the object a as return. When I cast it to Person. I get class cast exception.

    thanks

    DB:3.00:How To Get Table Size fz

    1) Use count from ejb ql, for example: "select count(a) from Address a".
    2) Create your own class for these columns and: "select new com.foo.YourClass( a.id, a.name) from Person a". You will get list of YourClass instances. Remember about appropriate constructor in your class.

    Regards,
    S#322;awomir Wojtasiak

  • RELEVANCY SCORE 2.99

    DB:2.99:Retrieving Columns Information For Sql Server Table 8f


     
    In my app, i need to get columns information from a sql table.
    Im using
     
    DataTableReader^ reader = gcnew DataTableReader( DataTable );
    schemaTable = reader-GetSchemaTable();
     
    This give me most of infos i need, but i cannot retrieve the Expression field. Its allways DBNull.
     
    Do you know a way to retrieve Expression information?
    ( Computed Column Specification-Formula in SQL Management Studio )
     
    Im using Visual C++ 2005 Express.

    DB:2.99:Retrieving Columns Information For Sql Server Table 8f

    The Expression property of the DataColumn object doesn't come from the database; it's purely part of the ADO in-memory representation of your data set.  It has its own syntax and its own capabilities that are distinct from SQL Server's (or any other database that ADO might interoperate with).  It's always going to be DBNull unless you set it yourself when you create the DataColumn object, e.g.:
     

    Code Snippet

  • RELEVANCY SCORE 2.99

    DB:2.99:Sql Report (Updateable - Mru) Limitation - Ora-06502 kz


    Hi,

    I am using ApEx v3.0.1.00.07 and was wondering if there is a limitation on a MRU based on a Master-Detail relationship?

    My underlying table (let's call is Table B) has approx 30 columns (not all used) and just over 700 rows of data and growing.

    Lately, when my users select a application from a master table (Table A), to retrieve detail records from Table B, which is a SQL Updateable Report and based on selection from Table A, only two records will be returned from Table B, but instead, they receive the error:

    report error:
    ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    I find that when I turn off columns, within the report attributes, this tends to correct the issue until again, the same error occurs.

    Would really appreciate some assistance with correcting this problem as Table B data rows will be increasing on a regular basis.

    Thanks.
    Tony.

    DB:2.99:Sql Report (Updateable - Mru) Limitation - Ora-06502 kz

    Hi Scott,

    Unfortunately this thread didn't really assist with a replacement/alternative for a Tabular form - would really appreciate other alternatives from yourself or the ApEx Community.

    Thanks.
    Tony.

  • RELEVANCY SCORE 2.99

    DB:2.99:Maximum Number Of Columns A Resultset Can Support ss


    Hi,

    Can someone tell me what the maximum number of columns a result set can support? I'm using a cachedrowset to retrieve about 50 columns from a table and it seems to stop collecting columns after 33.

    Is there a way to work around this?

    Thanks

    DB:2.99:Maximum Number Of Columns A Resultset Can Support ss

    Can someone tell me what the maximum number of
    columns a result set can support? I'm using a
    cachedrowset to retrieve about 50 columns from a
    table and it seems to stop collecting columns after
    33.33 is a suspiciously low number.

    Why do you think it 'stopped'? Explain exactly how you determined this.
    What are the data types of fields 30-34?

    Why do you think that the java program is actually getting 50 columns?

    Finally in general everything in a computer is limited. However 33/50 would be significantly below normal limits for most resources.

  • RELEVANCY SCORE 2.99

    DB:2.99:Data Retrieval From A Table Which Contains A Column Of Long Raw Data Type cz


    we have a table in which one of the columns is of datatype log raw. we would like to know how do we retrieve the information and display it in a form / report. The problem we are facing is when we retrieve the information using select statement we get binary data !

    DB:2.99:Data Retrieval From A Table Which Contains A Column Of Long Raw Data Type cz

    we have a table in which one of the columns is of datatype log raw. we would like to know how do we retrieve the information and display it in a form / report. The problem we are facing is when we retrieve the information using select statement we get binary data !

  • RELEVANCY SCORE 2.99

    DB:2.99:Eis Drill-Through To Transactional Data 9s


    Hi!Is there a quick way to retrieve transactional fact data(non-summarized)from the fact table when drilling through in the Essbase Spreadsheet Add-in ? Have set up a drill through report through EIS, but it doesn't retrieve fact table columns even though the Template SQL was modified. Thanks in advance

    DB:2.99:Eis Drill-Through To Transactional Data 9s

    We have two SQL tables, Detail and Summary. In EIS, our Model has both tabels joined as the fact table. When you create the Drill Thru report you select the fields from the Detail table but the SQL logic still looks at the summary table. Note for excel, when you drill thru make sure each record in detail is unique or excel will suppress. we had to add a field to get all record to display in excel.

  • RELEVANCY SCORE 2.98

    DB:2.98:Is There Any Limit For Adding Multiple Columns In Pivot Table Within Bi Publisher? 3a


    Hi All,Unable to add more than 5 columns in pivot table within BI Publisher.Thanks

    DB:2.98:Is There Any Limit For Adding Multiple Columns In Pivot Table Within Bi Publisher? 3a

    Hi All,Unable to add more than 5 columns in pivot table within BI Publisher.Thanks

  • RELEVANCY SCORE 2.96

    DB:2.96:Any Way To Find The Selected Columns Of A Html Table Present Within System.Windows.Forms.Webbrowser Control? 7j


    Iam having a html table with some say 4 rows and 5 columns. Iam looking for a way to fetch the selected columns of that html table present within my custom System.Windows.Forms.Webbrowser control.Thanks,

    Satish.J

    DB:2.96:Any Way To Find The Selected Columns Of A Html Table Present Within System.Windows.Forms.Webbrowser Control? 7j

    See http://www.codeproject.com/KB/IP/parse_html.aspx Please only use this forum to ask questions related to IE extension development. For WebBrowser control questions, post to IE SDK newsgroups.
    Please mark the post answered your question as the answer, and mark other helpful posts as helpful.

    Visual C++ MVP

  • RELEVANCY SCORE 2.96

    DB:2.96:Get Column List 3d


    Hi Team,

    Can we retrieve the column list of a table dynamically, using any of the substitution methods.

    something like this.

    In a procedure just should mention the table name and ODI should retrieve the columns w.r.t that table during run time.

    Kumar.

    DB:2.96:Get Column List 3d

    I think this is still on topic....

    I want to get the column names in a procedure for a table that is supplied as an option - accessed through odiRef.getOption("Table Name").

    As I understand it odiRef.getColList can only be used in KMs. Is this correct?

    If so.....

    therefore column names etc can be retrieved from the repository.

    Would this approach be a workaround? If so how could you go about it? Jython, APIs etc?

    Suggestions welcome!

    Thanks,
    S.

  • RELEVANCY SCORE 2.95

    DB:2.95:Ms Crm 4.0 Plug-In- How To Retrieve The Properties Of Dynamic Entity sp


     
    Hi,
     
    I have written a plugin  to retrieve a dynamic entity.
    I am using the  namespaces given below
     
    using Microsoft.Crm.Sdk;
    using Microsoft.Crm.SdkTypeProxy;
    using Microsoft.Crm.Sdk.Query;
     
     
     But I have some difficulty in retieving the properties of dynamic entity.It is a propertycollection and not property.How can I retrieve the properties.How to retrieve a particular attribute 
     
    My code is
     
    ICrmService service =
    (ICrmService)context.CreateCrmService(true);
     
    //CreateResponse created = (CreateResponse)service.Execute(create);
    TargetRetrieveDynamic target = new TargetRetrieveDynamic();
    target.EntityId = new Guid(446AF4B0-EBD9-DC11-9A99-00123F38D584);
    target.EntityName = EntityName.account.ToString();
    // Define the entity attributes (database table columns) that are

    // Create a retrieve request object.
    RetrieveRequest retrieve = new RetrieveRequest();
    retrieve.Target = target;
    retrieve.ColumnSet = new AllColumns();
    retrieve.ReturnDynamicEntities = true;
    // Create a response reference and execute the retrieve request.
    RetrieveResponse response = (RetrieveResponse)service.Execute(retrieve);
    DynamicEntity retrievedEntity = (DynamicEntity)response.BusinessEntity;
     

    Regards
    Raji

    DB:2.95:Ms Crm 4.0 Plug-In- How To Retrieve The Properties Of Dynamic Entity sp

    You would get the property by doing: retrievedEntity.properties[attributename]Depending on the property, you may need to cast it to the correct type.

  • RELEVANCY SCORE 2.95

    DB:2.95:How To Compare Two Tables Data Without Using Join. c9


    Hi friends,
    There are two tables which are having 40 columns each(tables
    structure is same except one table is having char columns
    other is varchar2),some corresponding columns data is same, i
    want to retrieve the data when there is a match for the columns
    without using join conditions( Since 40 columns, a big join will
    be there). Any Oracle function which will take Table names as
    arguments and compares the data..?. Please give your suggestions
    or Queries..

    Regards,
    G. Rajakumar.

    DB:2.95:How To Compare Two Tables Data Without Using Join. c9

    Hi Friends, i got the solution,

    select * from t1
    intersect
    select * from t2

    If you have any alterntives, please let me know.

    Regards,
    G. Rajakumar.

  • RELEVANCY SCORE 2.95

    DB:2.95:Database Performance 73


    Hi All,
    I am a newcomer to Oracle database.

    I wanted to know the retrieval performance as compare to scenario below:

    Retrieve 2 columns of data from table A which consists of 5 columns having 100,000 rows.

    And retrieve 2 columns of data from table B which consists of 100 columns having 100,000 rows.

    Take the assumptions that indexes and columns selected (2 columns) are having the similar data type. Is there any difference in the retrieval performance? Which will be faster?

    Thanks

    DB:2.95:Database Performance 73

    It depends.
    If the indexes on both tables contain both the columns that you are selecting then the query will be returned using the index rather than the table. Therefore the response times will be the same for both tables.
    (there is only IO on the index blocks)

    If however both columns aren't in one of the indexes then there will have to be IO on the actual table blocks. Thus... All else being equal.. table A should return quicker, (as only having 5 columns, fewer blocks will have to be read from the table segment).

    Picture that for a given DB Block size of say 40k and if the table of 5 columns has an average size of 2k then you could fit 20 rows per block.
    On the other hand the table with 100 columns could only fit 1 row per block, (20 times as many cols so ave row size = 20 times 2k = 40).
    Thus to return a similar number of rows the 100 col table will have to perform more IO.

    So it all really depends on
    a) how fragmented the table is.
    b) what cols are indexed.
    c) db block size vs average row size

  • RELEVANCY SCORE 2.94

    DB:2.94:Table Columns - Freeze Column? az



    Is there a way to freeze a column in a table (like Excel) that has many columns so that you can scroll out to the right while that one column remains visible?

    I know you can export to Excel and do this but am wondering if there is a way to do this within QV.

    Thanks!

    DB:2.94:Table Columns - Freeze Column? az


    Hi,

    if you use a Straight Table Chart or a Pivot Table Chart, the dimensions will be freezed and the scroll will only wiork with the expressions.

    Hope this helps you.

    Regards,

    Fernando

  • RELEVANCY SCORE 2.94

    DB:2.94:Regarding Retrieving Values From A Table a3


    Hi,

    I have created a table(Say Test with columns c1 varchar2(10));

    I have records like 'abcdefgh','123456','ab123cdef' but i want to retrieve only
    records of 'abcdefgh' and 'ab123cdef'.

    Any advised would be thankful.

    Regards,
    - Sri

    DB:2.94:Regarding Retrieving Values From A Table a3

    WHERE length(trim(TRANSLATE(yourColumn,'1234567890','
    '))) 0TRANSLATE(yourColumn,'a1234567890','a') is not null

  • RELEVANCY SCORE 2.94

    DB:2.94:What Is The Maximum Number Of Columns Allowed On A Table? xc


    What is the maximum number of columns that a table can have? I work with a research team that wants/needs to have 140,000 columns on one table.

    The database where the table would reside would be Oracle 8.1.7.

    How would you best input that data (SQL*Loader?) into this table and best retrieve that data from this table? The maximum number of columns that I have implemented on a table was 500.

    Any feedback would be greatly appreciated.
    Thanks. ;-)

    DB:2.94:What Is The Maximum Number Of Columns Allowed On A Table? xc

    The max in 8.1.x is 1000. And, yes, sql*loader is the best way to load.

    140,000 !!! Whew ! I'd find a way to distribute that nicely into a parent/child(ren) scenario somehow. That many columns seems unwieldy to try to handle (even if it were physically possible to do).

  • RELEVANCY SCORE 2.94

    DB:2.94:Table Within A Table dm


    How can I insert a table within a worksheet where I can adjust the columns and rows without it adjusting the main worksheet where this table resides.

    DB:2.94:Table Within A Table dm

    Not sure about the version used back in 2010 for this question, but with 2013, add an object, Word Document, size it, and add a table to the word document that you sized on the worksheet. Size the table the way you want.

  • RELEVANCY SCORE 2.94

    DB:2.94:How To Retrieve Information From A Database View Name 8d


    For a given database View name, is there any way to retrieve what are the columns (also the corresponding table name) associated with that View?

    I am getting the view names by using DatabaseMetaData APIs.
    Now I want to retrieve the info associated with that view.

    Any help will be highly appreciated.

    DB:2.94:How To Retrieve Information From A Database View Name 8d

    If all else fails then since you have the view name then "select * from viewname where 1=0" should work.

  • RELEVANCY SCORE 2.93

    DB:2.93:Record Creation Date Without A Column For It 1k


    A record has been created in a table. No timestamp has been recorded in any columns on this table. Can you still retrieve when the row was created? If yes how?

    Thanks

    DB:2.93:Record Creation Date Without A Column For It 1k

    Please goback to the basics. Rows are nothing like a record; this is covered in the first 1-2 days of any RDBMS class. The database event of insertion is caught in the log file (file, not table!) This is meta data and has no place in
    the schema. You find it in the log files with a tool.--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking
    in Sets / Trees and Hierarchies in SQL

  • RELEVANCY SCORE 2.93

    DB:2.93:Max No Columns Allowed In A Table mm


    i want to know how many columns are allowed in a table.maximum no of columns in table.

    DB:2.93:Max No Columns Allowed In A Table mm

    user639995 wrote:
    i want to know how many columns are allowed in a table.maximum no of columns in table.Far more than what a properly designed data model will ever need. And no, 2NF is a fail.

  • RELEVANCY SCORE 2.93

    DB:2.93:Sql ca


    How do I retrieve columns in a table which is a not null column and data is only SPACES.

    DB:2.93:Sql ca

    select *
    from mytable
    where trim(mycol) is null;

  • RELEVANCY SCORE 2.93

    DB:2.93:Return A Table Column As A List ps


    Hello there,
    I am currently working on a project using VSLS, I am not facing a problem, and I look around, and can't seem to find a solution.
    I basically need to retrieve some element from an unrelated table and store them as a list. In more details, in table1 I want to be able to store some date ranges, and I have a calculated field (total) which displays the difference between the 2 dates.
    Problem is, there are some dates (Public holidays) which change every year, and if they appear within my date range, they need to be excluded from the total.
    I successfully implemented this in a separate project reading the dates from a text file and adding them to a ListDateTime; but now I want those dates to be stored in a separate table in LS.
    Therefore I can have my public holiday table with two columns (id, day);
    and from the DateRange table, I can have a method to retrieve the days in PublicHoliday table as a list, so that I can easily iterate through them. After some extensive Googling and Binging (trying to start a trend :) ), I still cant find a solution.
    I however have something like this so far:

    var phd = from hd in this.DataWorkspace.ApplicationData.PublicHolidays
    where hd.Day = startDate hd.Day = endDate
    select hd;

    If I write select hd.Day above, I get an error.
    I can only assume now that my table is loaded inside phd, but how can I retrieve the Day Column??? phd is of type IDataServiceQueryable.... Any help or direction towards an answer would be highly aprreciaed.
    Thanks again.
    YanRegards Yanick N.

    DB:2.93:Return A Table Column As A List ps

    You can write code in the Application_Initialize method. In the Solution Explorer, right-click on the application node - View Application Code (Client). Then inside this class implement the partial void Application_Initialize() method (Private
    Sub Application_Initialize() for VB). Inside of that code you can issue your query and load the list into a static/Shared variable.
    Another approach would be to lazy-load the list when you first need it. Instead of loading the list in Application_Initialize, make a static/Shared method that will load the list the first time you call the method.

  • RELEVANCY SCORE 2.93

    DB:2.93:Distinct Data From Different Columns Of A Table-Single Query sj


    I have a table with different columns. Each of these columns have entries. A particular column, say, a column called name can have same entries more than one time. Likewise other columns can also have same entries more than once. My requirement is to have distinct entries from each of these columns using a single query, such that , for eg; the name column will contain the name George only once on retrieval. Place column will have the place Newyork only once...like that...but Newyork and newyork should be treated different(likewise in other columns also ie; case sensitive). I want to retrieve the above said using a single query from a table. Kindly help.
    Regards,
    Anees

    DB:2.93:Distinct Data From Different Columns Of A Table-Single Query sj

    You're asking a SQL question in a JDBC forum. Look for a SQL forum. The website of the database manfactuer may have a SQL forum/mailinglist.

  • RELEVANCY SCORE 2.92

    DB:2.92:How Can I Read A Table From Doc File And Create Html Table In Hta Div With Same Content. s7


    I have huge table in DOC file (12 columns and many many rows). How can i read this table content and create a HTML table in DIV area within HTA window. 

    DB:2.92:How Can I Read A Table From Doc File And Create Html Table In Hta Div With Same Content. s7

    Try these links:
    Working with Tableshttp://msdn.microsoft.com/en-us/library/aa171388(office.11).aspx
    Tables Collection Objecthttp://msdn.microsoft.com/en-us/library/aa212435(office.11).aspx
    Microsoft Word Visual Basic Referencehttp://msdn.microsoft.com/en-us/library/aa272078(office.11).aspx
     

  • RELEVANCY SCORE 2.92

    DB:2.92:How To Retrieve The Number Of Rows In A Table With Over 30 Columns? px


    Hi
    I have a table with almost 35 columns.
    how can i retrieve the number of rows of the table without affecting the performance?
    Thanks
    Eveta

    DB:2.92:How To Retrieve The Number Of Rows In A Table With Over 30 Columns? px

    The number of columns shouldn't make a difference in calculating COUNT(*)... unless they are wide columns making a huge table.
    You can also do this:
    SELECT rows
    FROM sys.partitions
    WHERE OBJECT_NAME(object_id)='YourTableNameHere'
    GROUP BY rows
    --Brad (My Blog)

  • RELEVANCY SCORE 2.92

    DB:2.92:Help Creating Indexes On A Table 1j


    I have a web site that is experiencing very slow performance. I believe it isbeing caused by queries that access atable with about 30,000 records. All of that stored procedures that access this table use a combination of two columns
    to retrieve records(most queries return 15 rows). I have an indentity column set as the table's primary key. Should I create a clustered index on the two columns that are used to retrieve records? Would there be any negative impacts?

    DB:2.92:Help Creating Indexes On A Table 1j

    Hi James,
    In addition to the information you're getting here, I recommend that you look at the product documentation (AKA Books Online) for general information about index types and design/optimization help. The starting point for SQL Server 2008 index documentation
    is here:
    http://msdn.microsoft.com/en-us/library/ms189271(v=sql.100).aspx.
    Regards,
    GailGail Erickson [MSFT] This posting is provided AS IS with no warranties, and confers no rights

  • RELEVANCY SCORE 2.92

    DB:2.92:Create Fixed Length Text File From Sql Data dm


    i need to retrieve records from an SQL 2008 table and create a fixed length text file (first_name columns 1-20, last_name columns 21-40, ssn columns 41-49, etc.). What is the easiest way of doing this?

    DB:2.92:Create Fixed Length Text File From Sql Data dm


    EXEC

    xp_cmdshell

    'bcp SELECT
    CAST(FIRST_NAME AS CHAR(20)),
    CAST(LAST_NAME AS CHAR(20)),
    CAST(SSN AS CHAR(9))

    FROM sysfiles queryout C:\bcptest.txt -T -c -t,'

  • RELEVANCY SCORE 2.92

    DB:2.92:Retrieve Date From Last Insterted Row d1


    Hi all, maybe it's just a bad time for me to think right now :) or maybe i really dont have a clue about that. Anyway could u pls help me to retrieve timestamp of a last inserted record from a very very very, really very huge table. Table is having some few columns, one of which is a timestamp ...
    thanks a lot !!

    DB:2.92:Retrieve Date From Last Insterted Row d1

    Yes. If you need to know this max(timestamp) regularly and can't afford to index the column, and don't have another unique ordered id to use to locate it, then you're going to have to dernormalize the aggregated value somewhere for quick reference.

    Why exactly were you thinking you need this aggregate value?

    There's loads of ways of maintaining the aggregate, the most appropriate one will be identified by your requirement and the methods by which this table is maintained.

    Feel like sharing the details?

  • RELEVANCY SCORE 2.92

    DB:2.92:Omplus Retrieve Table Primary Key Column zf


    I'm trying to retrieve the primary key column associated with a table via OMBPLUS.

    The following command successfully returns the PK name

    OMB+ OMBRETRIEVE TABLE 'ODS_REGION' GET PRIMARY_KEY
    REGN_PKWhen I add the GET COLUMNS clause (as per API documentation), I'm still only getting the pk name.

    OMB+ OMBRETRIEVE TABLE 'ODS_REGION' GET PRIMARY_KEY GET COLUMNS
    REGN_PKAny suggestions on what I might be doing wrong?

    DB:2.92:Omplus Retrieve Table Primary Key Column zf

    Worked it out. Syntaxt needed is:

    OMBRETRIEVE TABLE 'ODS_REGION' PRIMARY_KEY 'REGN_PK' GET COLUMNS

    (no GET between table name and PRIMARY_KEY clause)

  • RELEVANCY SCORE 2.91

    DB:2.91:Accessing Text Fields In A Table, Which Aren't Bound To A Dataprovider 8z


    Hi,

    I have a table bound to a dataprovider, that also has some extra columns I added on through the "table layout" menu. These extra columns have text fields which are NOT bound to anything. How can I retrieve what text is written inside them? it's fine if this requires binding them to something.

    Thanks for any help!
    Tristan

    DB:2.91:Accessing Text Fields In A Table, Which Aren't Bound To A Dataprovider 8z

    Great! With your help, I can now do what I want. Here's how it goes:

    1) user enters passwords into table of connections to make
    2) hits button
    3) JSC calls setter methods associated with text fields (thanks for pointing this out), and new values of those text fields are automagically given as arguments.

    It's an odd way to do it, but it works. That just about sums up everything I've been doing lately.

    Now I just need to get password fields into a table, but I think I have a couple of hacks that will collectively make that possible.

    Message was edited by:
    aperson

  • RELEVANCY SCORE 2.91

    DB:2.91:Olap Drill Through Maximum Number Of Records To Retrieve Property For Excel 2003 xk


    By default, an OLAP drill into details drill through will retrieve the first 1000 records.

    We arelookingthe option to change this limitationwithin Excel 2003.

    It is available in Excel 2007 as:

    Drill Through This action queries the cube based on a condition specified in an MDX statement and returns data from the fact table that is the source of the measure's aggregated values. The data is displayed in a worksheet as an Excel table. The
    MDX statement specifies which columns should be returned from the fact table and the maximum number of records to return, specified in the
    Maximum number of records to retrieve property under the OLAP Drill Through section on the
    Usage tab of the Connection Properties dialog box. For more information, see

    Connection properties.

    What is the equivalent method within Excel 2003 ?
    Can this be controlled within a VBA call in either version ? (to inplement a similar solution for both).

    Thank you,

    John Mathieu

    eRAP Enterprise Admin
    IDS-Business Intelligence Svcs(BIS)
    *** Email address is removed for privacy ***

    DB:2.91:Olap Drill Through Maximum Number Of Records To Retrieve Property For Excel 2003 xk

    For Query related to this issue, you may also post in the below forum for better suggestions:

  • RELEVANCY SCORE 2.91

    DB:2.91:How : Create One Table From 2 Different Data Controls? f8


    Hi All,

    I intend to create an ADF table of which the columns are from 2 different DataControl Iterators (Site(source human task) and Name(source VO)). How do I create a table with columns from these 2 DC's such that the different columns all act as one row within the table. BAsically, how do you create a table from different iterators and make an entry within the columns act as a row?

    JDev : 11.1.1.4

    Regards
    PP.

    DB:2.91:How : Create One Table From 2 Different Data Controls? f8

    You do this in the model layer, not the view controller. In the model layer you can create a vo based on two entity objects (or one SQL which joins the two tables) and expose this to the data control.

    Timo

  • RELEVANCY SCORE 2.91

    DB:2.91:How To Programmatically Retrieve A Single Record From Access? sx


    I need to retrieve a single record from Access. I have two columns, "Sess" and "Subject" in my database. I want to retrieve the Session number ("Sess") for a particular subject and display it on the front panel. I have made up the attached VI based on an example I found. This VIdisplays the Session number for the first record, but I can't figure out how to designate a search for aspecific record in the table. Thanks!






    Solved!
    Go to Solution.

    DB:2.91:How To Programmatically Retrieve A Single Record From Access? sx

    josborne wrote:

    Retrieving all the records and then iterating through them is extremely inefficient. What if you have millions of records?

    Just use this SQL statement:

    SELECT Sess FROM yourtablename WHERE Subject = 'blahblahblah'

    Not sure if this was directed at my comment, but... I didn't say retrieve all records, I said fetch the recordset data. The recordset contains the records that match the query (which, in my snippet,looksmuch like your SQL statement). You have another problem if your query can return millions of records but you only want one.




    JimYou're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice

  • RELEVANCY SCORE 2.91

    DB:2.91:About Adding A Row To Table Via Customization. jz


    hello,

    I have a table with two columns(Name, Weight)
    Within this table i have another nested table for the Name Column.

    I want to add another row for the first table via customization.
    How do i add this summary row for the first table.

    Thanks.

    DB:2.91:About Adding A Row To Table Via Customization. jz

    Hi ,

    as per my opinion one approach would be that ,

    you create a custom table region same as standard one using Jdeveloper and create other required fields also using jeveloper ,and then put this region in extend property of existing standard table region .

    thanks
    Pratap

  • RELEVANCY SCORE 2.91

    DB:2.91:Engine Api - Gettablesandkeys Column Order 77



    Hi,

    The GetTableAndKeys method doesn't return the fields in column order.

    I want to use the data to output table headings (I can then use GetTableData to get the table data.)

    Is this a bug? What's an alternative method to retrieve source table columns in the correct order?

    thanks,

    Shane.

    DB:2.91:Engine Api - Gettablesandkeys Column Order 77


    So, the GetTableAndKeys method call doesn't return columns in the correct order, but...

    if I pass in a -1 for the offset in the GetTableData method call, I get the column names as the first row. At least now I get a match between data and column names (even if the column names aren't strictly in the same order).

  • RELEVANCY SCORE 2.90

    DB:2.90:Udt's And Retrieving Them 9j


    How do we retrieve a specific column within a UDT
    For example we have a table Employees and within that table is a column Address and the address is a UDT with city, country, etc
    How can i retrieve the country only?

    DB:2.90:Udt's And Retrieving Them 9j

    SQL create type Address as Object (
    2 city varchar2(50),
    3 state varchar2(2)) ;
    4 /

    Type created.

    SQL create table Addr_Book (Name Varchar2(20), addr Address) ;

    Table created.

    SQL
    SQL insert into Addr_Book values ('SAMPLE', Address('Any City', 'AA')) ;

    1 row created.

    SQL
    SQL select t.addr.city from addr_book t ;

    ADDR.CITY
    --------------------------------------------------
    Any City

    1 row selected.

    SQL disconnect
    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.3.0 - Production
    SQL

  • RELEVANCY SCORE 2.90

    DB:2.90:Get Primary Key Columns From Table aa


    Hi there

    I need to extract all columns names with primary key from a given table but only columns with primary key. Is there a way to make a query to retrieve them or using jdbc classes but i couldn't find any solution if anyone can help pls. i am using oracle driver.

    thx
    Alex

  • RELEVANCY SCORE 2.90

    DB:2.90:How Can I Copy A Table Within One Database? 73


    I have a table most columns of it (and there are many) are useful for another table in the same database.
    how can I copy the table to a new name table?

    DB:2.90:How Can I Copy A Table Within One Database? 73

    as I understand you can not copy it using copy and paste...
     

  • RELEVANCY SCORE 2.89

    DB:2.89:Windows Form Application That Retrieves Column Data From A Specific Table From Any Sql Server Database j9


    Hello,
    I'm new to c# and I want to create a Windows form application that will retrieve data from a selectable column in any SQL server Server and database. I have created a form that has 3 ComboBoxes titled 'SelectServerCB', 'SelectDatabaseCB', and 'SelectItemCB'. I would like to be able to select any of the SQL Server servers using the 'SelectServerCB' ComboBox, then any of the databases within that server using the 'SelectDatabaseCB' ComboBox. Then I would like the application to retrieve data from a specific table which is always titled Store_Data and that always has just two columns: Item and Percentage. I would like the third ComboBox, 'SelectItemCB' to be able to read into the Item column so I can select any one of the items within the table column. A button titled PopulateValues would then retrieve all the percentage data within the table and place it into a datagrid view.

    Does anyone know how to do this, or know of any good links that could show me how to do this?
    Thanks

    DB:2.89:Windows Form Application That Retrieves Column Data From A Specific Table From Any Sql Server Database j9

    This link provides information on getting the list of SQL Server instances:http://msdn.microsoft.com/en-us/library/a6t1z9x2.aspxThis link shows how to get the sql server database names:http://en.csharp-online.net/List_SQL_Server_databasesYou would then have to connect to the selected database to retrieve the data from the table.Hope this helps.www.insteptech.com ;
    msmvps.com/blogs/deborahk
    We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

  • RELEVANCY SCORE 2.89

    DB:2.89:Several Columns Condition 93


    Hello!
    Can someone please help with a question I have?
    I have a table with several columns (lets say 7 columns). I have to select rows which 3 (of those 7) columns is not the same as the list I have from other table. I.e., I have to select records where all of those 3 columns, in the same row, is not included
    in the second table.
    If I just use
    WHERE tableA.colX not in tableB.colX and tableA.colY not in tableB.colY and tableA.colZ not in tableB.colZ
    it will product wrong results, because it will not compare all three columns for the same row (if just one of the columns in a given row satisfy the condition, it will be retrieved...).
    How can I compare those 3 columns all together and retrieve records where ALL those 3 columns satisfy the condition in each row evaluated?
    Thanks!

    DB:2.89:Several Columns Condition 93

    As you wanted records from TableA which are NOT IN TableB (comparison based on three columns), you need to use TableA LEFT JOIN TableB and filter with TableB.some column IS NULL. Below shown is the sample query:

    SELECT TableA.*
    FROM TableA
    LEFT JOIN TableB
    ON TableA.Col1 = TableB.Col1
    AND TableA.Col2 = TableB.Col2
    AND TableA.Col3 = TableB.Col3
    WHERE TableB.Col1 IS NULL

  • RELEVANCY SCORE 2.89

    DB:2.89:Retrieve Concatenated Result f3


    I have a table with following columns:

    ItemName varchar(60)
    ItemDimension varchar(3)

    Instead of using following query:
    Select ItemName,ItemDimension from ItemMaster;

    I want to retrieve the result in concatenated form, i.e.,

    ItemName + ItemDimension

    so that the result retrieved is in one column. How to do this?

    DB:2.89:Retrieve Concatenated Result f3

    Some info on this:

    http://www.techonthenet.com/oracle/functions/concat2.php

  • RELEVANCY SCORE 2.88

    DB:2.88:Need Sql Help 3a


    consider table a with columns
    column1
    column2
    column3
    column4
    column5
    For each value of column1 there are multiple rows in table a.

    I want to retrieve the first five occurances for each value of column1 and store all the values of the resulting rows in different variables (i.e. if i have 5 columns (5X5rows = 25 variables).
    any help is greatly appreciated.

    DB:2.88:Need Sql Help 3a

    declare
    cursor matrix is
    select distinct(column_1) Column_1
    from columns;

    --Declare all the variable you want

    begin
    --By using cursor now you can obtain the 5
    --occurances for each distinct column_1

    for matrix_rec in matrix loop
    select column_1,column_2,column_3,column_4,column_5
    into (variables)
    from column
    where column_1=matrix_rec.column_1
    and rownum6;

    end loop;
    end;

    null

  • RELEVANCY SCORE 2.88

    DB:2.88:Listview Multicolumns pp


    Hello everyone,
    I tried this before witht the listbox, but that is harder then it looks. So now I have a listview and I would like to retrieve from SQL - dataset - datatable. From the datatable I would like to put the First and Lastname into the listview. So there
    should be 2 columns and the value should have the id of the PersonID within the table (SQL). Does anybody have some examples or some website to get this done?

    Greetings Spacelama

    DB:2.88:Listview Multicolumns pp

    i just copied and pasted your code ... remove the 0: it is for the image index
    item = listViewPerson.Items.Add(row[PersonID].ToString());

    Peter Koueik

  • RELEVANCY SCORE 2.88

    DB:2.88:Get The Inlinestyle Of A Rich Table Column a7


    Hi. I have a table that has row highlighting implemented using the inline style on the columns. If a row satisfies the criteria then each cell is coloured, highlighting the row. This works fine.However, when I try and retrieve the inline style, I can't seem to find the values.In my method, I'm getting the table columns using:
    ListUIComponent columns = _component().getTable().getChildren();
    then looping though the columns. Using
    ((RichColumn)columns.get(i)).getInlineStyle();
    always seems to return null. Is there a way to get the columns inline style dependant on which table row I'm currently processing?The alternative for me is to apply the colour/highlighting logic again for each table row to work out the inline style.Thanks.

    DB:2.88:Get The Inlinestyle Of A Rich Table Column a7

    Hi, the reason is that you don't have the inlineStyle set on the af:column but most likely the component therein. A column doesn't allow per row color coding, so I am sure you search on the wrong end Frank

  • RELEVANCY SCORE 2.88

    DB:2.88:Retrieve Columns Names From The Table f7


    Hi all,

    how to Retrieve columns names from the table

    Thanks.

    DB:2.88:Retrieve Columns Names From The Table f7

    select TABLE_NAME,COLUMN_NAME from dba_tab_cols;

    or

    select TABLE_NAME,COLUMN_NAME from user_tab_cols;

    Regards

    Edited by: skvaish1 on Feb 11, 2010 3:29 PM

  • RELEVANCY SCORE 2.88

    DB:2.88:Help Needed In Retrieving Data a3


    Hi,

    I have a table
    ego_attrs which stores column names of a table ego_mtl_sy_items_ext_b.

    ego_attrs ego_mtl_sy_items_ext_b

    col1 col1 col2 col3
    col2 x1 x2 x3 (Data)
    col3

    I'm supposed to retrieve the column names from ego_attrs and compare with the columns of ego_mtl_sy_items_ext_b table and retrieve the entire row and update another table(cn_comm_lines_api_all) by the data extracted from ego_mtl_sy_items_ext_b table. Can anyone help me on this.

    Thanks,

    DB:2.88:Help Needed In Retrieving Data a3

    This may not be the correct answer. But I think it is possible with the help of functions (which returns the primary key of the table), retrieve the data with that primary key and with the help of execute immediate statements you can update the row.

    store the values in some variables and insert those values in your new table.

  • RELEVANCY SCORE 2.87

    DB:2.87:Retrieving Image dc


    Hi, I have table with 5 columns . One is the primary key , and the rest 4 are used for storing the image. I put the rest 4 columns as BLOB . and when I retrieve, I cant retrieve the image. Is there anyway, I can store and retrieve 4 images per ID ( the primary key ).
    Thanks in advance .

    DB:2.87:Retrieving Image dc

    Sorry, I got busy working on something else. Anyway I recently worked with a form that had a blob column in the database. In the form the field that holds the blob column has a item type of 'Image' and is defined as a database item. When the form is queried the image is retrieved into that field.

    To get the image into the database there was code to upload it:
    Declare
    Image_FileName varchar2(200);

    Begin
    --Retrieve image from the local directory structure
    Image_FileName := Client_Get_File_Name;

    --Read image into the blob
    Read_Image_File(Image_FileName, 'GIF', 'IMAGE_FIELD');

    If Not Form_Success Then
    Error message;
    Else
    Enable transaction menu items
    End If;

    End;

    I hope that helps.

    c

  • RELEVANCY SCORE 2.87

    DB:2.87:Retieve Data From A Table ks


    How do I retrieve data from a table that is not currently open within a Form.
    this does not work: C = [Table]![LastClockID]!CHAR1.
    The table name is LastClockID, the field is CHAR1

    DB:2.87:Retieve Data From A Table ks

    If the table has a field that is related to data in the table currently feeding your form the you can add it in the Record Source using a LEFT JOIN current table to additional table on common data field.
    If you need more then post the SQL of both queries - current record source and new table.Build a little, test a little

  • RELEVANCY SCORE 2.87

    DB:2.87:Preserve All Columns Of Pivot Table 37



    Hello,

    I have a pivot table that I would like to show all columns and rows regardless of filtering. Filtering should change the numbers contained within the columns, though all columns and rows should remain visible, even if a null value is returned.

    Is there a setting for this? Currently if I filter my table loses the relevant rows/columns.

    Thank you

    M

    DB:2.87:Preserve All Columns Of Pivot Table 37


    Thanks Tibor,

    I have two dimensions, both which are segmentations defined in the load script, one of which is a cyclical group:

    My expression is just a sum of volume;

    On the Presentation tab, I have Always Fully Expand selected.

    Thanks again very much for your help. Im afraid I cant post the actual file due to data sensitivity.

    M

    IMPORTANT NOTICE

    This communication is from Deloitte LLP, a limited liability partnership registered in England and Wales with registered number OC303675. Its registered office is 2, New Street Square, London EC4A 3BZ, United Kingdom. Deloitte LLP is the United Kingdom member firm of Deloitte Touche Tohmatsu Limited (DTTL), a UK private company limited by guarantee, whose member firms are legally separate and independent entities. Please see www.deloitte.co.uk/abouthttp://www.deloitte.co.uk/about for a detailed description of the legal structure of DTTL and its member firms.

    This communication contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please (1) notify it.security.uk@deloitte.co.ukmailto:it.security.uk@deloitte.co.uk by forwarding this email and delete all copies from your system and (2) note that disclosure, distribution, copying or use of this communication is strictly prohibited. Email communications cannot be guaranteed to be secure or free from error or viruses. All emails sent to or from a Deloitte UK email account are securely archived and stored by an external supplier within the European Union.

    To the extent permitted by law, Deloitte LLP does not accept any liability for use of or reliance on the contents of this email by any person save by the intended recipient(s) to the extent agreed in a Deloitte LLP engagement contract.

    Opinions, conclusions and other information in this email which have not been delivered by way of the business of Deloitte LLP are neither given nor endorsed by it.

  • RELEVANCY SCORE 2.87

    DB:2.87:Reading And Inserting Value In Long Raw 9f


    Hi guys !!

    I have a table with 15 columns out of which RESUME column has data type long Raw. I want to copy this table to another table with selectd columns and validation. I want to check whether RESUME column is NULL. How to achieve it ?

    Similarly, using VB how to insert and retrieve values in such column ?

    thanx in advance

    Abhi

    DB:2.87:Reading And Inserting Value In Long Raw 9f

    Hi guys !!

    I have a table with 15 columns out of which RESUME column has data type long Raw. I want to copy this table to another table with selectd columns and validation. I want to check whether RESUME column is NULL. How to achieve it ?

    Similarly, using VB how to insert and retrieve values in such column ?

    thanx in advance

    Abhi

  • RELEVANCY SCORE 2.87

    DB:2.87:How To Protect Columns Containing Formula Within A Table ax


    Hello,
    I would like to protect formulas for some columns in a table, but I would like to allow user to add or remove rows without problem, and delete cell values without delete formulas!
    Do you know how to do that?
    Thanks for your support.

    DB:2.87:How To Protect Columns Containing Formula Within A Table ax

    First unlock cells, that will allow user to delete content - Format cells - Protection - uncheck LOCK
    After that Protect sheet (Review-Protect Sheet) and mark all check boxes, that you want your user to be allowed(Insert columns, Delete rows ets.)
    When cells with your formula is locked, then the Protect command is working, when the cells is unlocked the Protect command is not affect that cells.
    Hope I help You :)Boriana Petrova MCT, MCTS, MCITP, MOS- Master

  • RELEVANCY SCORE 2.87

    DB:2.87:Execute-Sql For Table With Multiple Rows xf


    I have a database table which contains information that allows me to determine certain processing information within a proxy service. I want to be able to retrieve data ( more than one row ) from this table.

    When I use execute-sql it returns only one row where more than one are expected.

    Anyone aware of to get multiple rows from a table from within OSB?

    thanks

    DB:2.87:Execute-Sql For Table With Multiple Rows xf

    Thanks Manoj. Wrapping in an XML tag solved the problem.

  • RELEVANCY SCORE 2.87

    DB:2.87:Indexed Columns ax


    How to find the indexed columns for a table?

  • RELEVANCY SCORE 2.87

    DB:2.87:Retrieve Manually Added Column Data From A Data Provider Table pm


    Hi, I have a table these columns:

    | Diploma | Specialisation | Year | Semester | Path | No. of Student |

    Diploma, specilisation, year, semester and path are dropdown lists.
    No. of Student is textfield.

    Of all these columns, only Diploma, Specilisation, and No. of Student are binded to a data provider. The Year, Semester and Path columns are added by myself.

    My question here is how do I retrieve data from those columns (Year, Semester and Path) that I have added by myself?

    I've tried to name the ID as yearDD, semDD and pathDD respectively and retrieve the data using getSelected() inside my data provider loop for retrieving the data. However it can't work. It gave me null value. Help needed urgently. Thanks.

    DB:2.87:Retrieve Manually Added Column Data From A Data Provider Table pm

    Hi, I have a table these columns:

    | Diploma | Specialisation | Year | Semester | Path | No. of Student |

    Diploma, specilisation, year, semester and path are dropdown lists.
    No. of Student is textfield.

    Of all these columns, only Diploma, Specilisation, and No. of Student are binded to a data provider. The Year, Semester and Path columns are added by myself.

    My question here is how do I retrieve data from those columns (Year, Semester and Path) that I have added by myself?

    I've tried to name the ID as yearDD, semDD and pathDD respectively and retrieve the data using getSelected() inside my data provider loop for retrieving the data. However it can't work. It gave me null value. Help needed urgently. Thanks.

  • RELEVANCY SCORE 2.86

    DB:2.86:Is It Possible To Use The Sum Function To Subtract Two Columns? k8



    Within a report from Business Analytics, is it possible to use SUM functions (like in Excel) to subtract, add, multiply columns to retrieve an answer? For example, can you add a new column (Column D) and insert a function where Column B is subtracted from Column A.....so the answer appears in Column D?

    DB:2.86:Is It Possible To Use The Sum Function To Subtract Two Columns? k8


    Just saw that this post had not been answered.

    Short answer: Yes.

    WebIntelligence has an extensive range of Functions, Formulas and Calculations - so much so, that it has a manual all to itself "Using Functions, Formulas and Calculations in SAP BusinessObjects Web Intelligence"

    EDIT:

    Link to the manual:

    http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_webi_ffc_en.pdf

    Message was edited by: Jim Wilson (added link to the manual)

  • RELEVANCY SCORE 2.86

    DB:2.86:Keeping " Character From Table Column??? fa


    Does anyone know of a way in which I can prevent the character " from being in any of the columns within my database table?????

    Please help????

    DB:2.86:Keeping " Character From Table Column??? fa

    It can't be done generally.

    Now in oracle you set a constraint (or maybe a trigger) that would prevent a varchar from having that. But unless almost nothing is done with the database you couldn't do that with a blob, it would simply take too long.

    Now if you want to write java code that prevents a String, that it used as data, from doing that that is easy. However, that has nothing to do with databases nor with JDBC. But if that is what you want then look at String.indexOf().

  • RELEVANCY SCORE 2.86

    DB:2.86:Date Within One Minutes mj


    Hi,
    In my database table, there is field called Time with datatype as Date (it stores the time when the record is inserted), I want to query the table such that the record inserted within a particular minute can be retrieve, can anyone teach me how to write this sql statement?
    Thx

    Marco

    DB:2.86:Date Within One Minutes mj

    Hi:

    select * from MYTABLE
    where to_char(my_column_date, 'mi') = ?

    bye.

  • RELEVANCY SCORE 2.86

    DB:2.86:Help Filling A Datagrid With Data From Various Tables cd



    MHI, this is simple.

    I have 2 tables.

    ORDERS and CLIENTS.

    table ORDERS are columns: order_id, client_id, status

    table CLIENTS are columns: client_id, client_name

    my datagrid would have the columsn: order_id, client_name, status.

    Thats all. I can't simply do it in Flex. HELP PLEASE.

    These are my approaches:

    1 - tried to create a new array collection with mixed data from these 2 tables to use as dataprovider in the datagrid.

    even the ac is [Bindable], the datagrid won't update. Probably Im creating the ac in a wrong way.

    2 - tried to use the ORDERS table call responder lastResult property (that works out to fill the data grid) and add a new colounm (client_name) within each item inside the ORDERS array collection.

    I'm not able to ADD a property/field/column inside the ac. Of course, when I use .addItem, it will create a new "order" not a new "order.property"

    if something like: ac.source[i].push({client_name:clientName}) worked...

    My goals are simple. To fill the datagrid with those data.

    Ah.. i almost forgot...

    supose CLIENTS have 1000 registers.

    I don't have to bring all those registers within flex to look for only one ID to retrieve a name to fill the orders datagrid, right?

    THANKS A LOT

    btp~

    DB:2.86:Help Filling A Datagrid With Data From Various Tables cd


    The truth is that I'm a designer trying to make a "presentation" that merely "works".

    Later a real programmer will take my work as a base.

    I'm very limited in flex and php, however I worked with sql (in vb) where I could deal everything inside vb, and I fairly know AS3.

    For flex, I have to know a server language (php, in my case) to write a query. Flex generates classes in php to help me at this point.

    So I have 2 classes: ClientServer.php and OrderServer.php.

    I tried to include ClientServer into OrderServer so I could build a query like this you are suggesting. But I couldn't even include one class into another.

    if possible, take a look at how flex structures the php class and would you tell me how do I make a connection using 2 tables.

    By the way, I'm afraid I will need to wait for your flex code to cleary understand what you mean by those 2 directions.

    Thanks a lot again!

    Btp~

  • RELEVANCY SCORE 2.86

    DB:2.86:Horizontal Scrollbar In A Straight Table j8



    I have a straight table with a number of columns. By default the table width sizes to the columns added and the width goes beyond the monitor's screen size. I am trying to find a way to enable a horizontal scrollbar from within a straight table. I don't see any option to do this.

    Anyone ?

  • RELEVANCY SCORE 2.85

    DB:2.85:Substring In The Select Statement s3


    Hi,

    Have a table with 5 columns in it...

    Table A
    -----------
    col1
    col2
    col3
    col4
    col5

    Want to retrieve some columns from that table using the select query, in which substring will be used to extract a part of string from each value contained in the col3 on executing select statement.

    How to use the substring in the select statement to perform the above?

    Regards

    DB:2.85:Substring In The Select Statement s3

    What's wrong with ttSUBSTR(col3,4,2)/tt etc? What do the other columns have to do with it?

  • RELEVANCY SCORE 2.85

    DB:2.85:Retrieve Value Based On 3 Criteria. 2 Rows, 1 Column 1f


    In col A, starting at A3 have a list of customer names.
    The columns B1:E1 are labeled 1,2,3,4 respectively, indicating option
    numbers, and repeat across the sheet.
    In Columns B2:E2 is the Product ID (which are identical in this group
    of four). There are over 100 product ID's, each with options
    available of 1,2,3 or 4. Then, the next product ID, with option 1,2,3 or 4 above it in row 1.
    Need to specify on another worksheet the customer located in col. A,
    the option desired from row 1, (1,2,3 or 4) and the product ID from
    row 2. Need to retrieve the value located within the table.
    So, if a certain customer choses the product ID, with an option of 3,
    it would retrieve the proper amount for that product ID.

    Tried retrieving with the numerical data with SUMIFS, but it did not
    work. Perhaps a varient of SUMPRODUCT?
    Something like:
    =SUMPRODUCT(1*(Z1:JJ1="1")*(Z2:JJ2="31-321B")*(A3:A100="Capstone Mfg")*(Z3:JJ100))
    I don't think that the data in column A works its way into this. .. Seems to not like combining rows and column references. Maybe a different approach.

    Thanks for pointing me in the right direction.
    Pete

    DB:2.85:Retrieve Value Based On 3 Criteria. 2 Rows, 1 Column 1f

    Thanks. Glad it worked for you and that you figured out how it worked. :)

    Very slick. Thank you for your valuable time, and assistance.
    Pete

  • RELEVANCY SCORE 2.85

    DB:2.85:How Does The Oracle Database Know A Table Is The Primary Table In A View 39


    If each table has primary keys, and the same number of requested columns within the view and the table is joined on the primary key of each table, how does Oracle determine which table is primary?

    This is in term of updating the primary table since you can only use the update statement on the primary table's columns.

    DB:2.85:How Does The Oracle Database Know A Table Is The Primary Table In A View 39

    Are you asking about updatable views?

    If so, http://stackoverflow.com/questions/1652995/in-oracle-is-it-possible-to-insert-or-update-a-record-through-a-view

  • RELEVANCY SCORE 2.85

    DB:2.85:Retrieve Data From 2 Columns Of 2 Different Tables And Display In 1 Column dc


    Hi,

    Is it possible to retrieve data from 2 different columns of 2 different tables and display it in the same column of a datablock in a form.

    For example:
    Table A
    Col1
    1
    2
    3

    Table B
    Col1
    2
    4
    5

    The column from the datablock in the form should display the following:
    1
    2
    3
    2
    4
    5

  • RELEVANCY SCORE 2.84

    DB:2.84:Return Default Value a9


    Hi,Can you tell me the table name where all the default values and datatype of all columns in a schema is stored.Is there any system table like this where we can c the default value of columns and datatype other then desc tablename
    and also plz tell me the query to retrieve it.

  • RELEVANCY SCORE 2.84

    DB:2.84:Grouping Rows Within Bepl Process 7a


    I have created a bpel database polling process to process a single table and use a logical update (mark a column as processed). The table will contain many unprocessed records at any time. after rows are brought into BEPL process i want to group them based some columns

    Like, I am doing polling on a table from that table fetching following columns
    projectid
    date
    Employeeno
    billable
    sum(work)
    all fetched rows should be grouped based on projectid,date,Employeeno,billable columns within BEPL process(not using custom SQL)

    is there any way to do this?

    DB:2.84:Grouping Rows Within Bepl Process 7a

    to do grouping pls look into below links

    http://www.prshanmu.com/2010/01/grouping-and-aggregation-in-bpel-using-xslt-20.html

    http://www.xml.com/pub/a/2003/11/05/tr.html

  • RELEVANCY SCORE 2.84

    DB:2.84:How To Retrieve The Data Type Of A Column Of A Table? as


    Hi,

    I want to retrieve the data type of a column of a table. At the moment I am querying "OCI_ATTR_DATA_TYPE" attribute but it is returning SQLT_CHR for both varchar2 and nvarchar2 data type columns. I need to distinguish between these two data types columns separately. Is there any API through which I could get the exact data type of a column i.e. "nvarchar2"?

    Thanks in advance.

    Hashim

    DB:2.84:How To Retrieve The Data Type Of A Column Of A Table? as

    Oops, I didn't refresh my browser and duplicate posted what Sumit posted...

    Oh, well, at least our answers agree :)

    - Mark

  • RELEVANCY SCORE 2.84

    DB:2.84:Putting Leaders Within A Table 99


    I have a table with two columns..using as a template for a menu. so have like hamburger 4.00 want to put dots in between when I pull up tabs it doesn't show a value

    DB:2.84:Putting Leaders Within A Table 99

    For reasons known only to Microsoft, tab leaders don't appear inside tables. You can set them in the Tabs dialog, but they won't show up in the page as long as the text is inside a table cell.

    Use the Convert to Text button on the Table Tools | Layout tab to remove the table structure and just leave the text. You'll probably have to reopen the Tabs dialog and reset the tab type and leader afterward. (For prices, it's best to use a decimal tab so
    the numbers will align on the decimal point.)

  • RELEVANCY SCORE 2.84

    DB:2.84:It Is Possible To Alter Multiple Columns Within A Single Alter Table Statement? zx


    It is possible to alter multiple columns within a single alter table statement?
    I tried searchednot getting it.

    Alter table au_de alter column m_user char(9),c_user char(9)

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near ','.

    DB:2.84:It Is Possible To Alter Multiple Columns Within A Single Alter Table Statement? zx

    SQL Server T-SQL doesn't allow multiple columns to be changed in one ALTER TABLE command (unlike some other languages where it's possible). See BOL Link for the ALTER TABLE commandALTER
    TABLE - BOL ReferencePremature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog

  • RELEVANCY SCORE 2.84

    DB:2.84:Stored Procedure For Sending Email Within The Application 11



    i have 2 table let us say customer and queuemail. i have to retrieve all email id of that column from customer table and inserted into queuemail with additional columns as mentioned below. when a user in customer table registered in before today’s date on i.e,[CreatedOnUtc]
    field then i want to send message to all the users.

    Please help me out on this. i dont want gmail pattern answers.
    this is for my application itself not globally.

    Queuemail table
    SELECT TOP 1000 [Id]
    ,[Priority]
    ,[From]
    ,[FromName]
    ,[To]
    ,[ToName]
    ,[CC]
    ,[Bcc]
    ,[Subject]
    ,[Body]
    ,[CreatedOnUtc]
    ,[SentTries]
    ,[SentOnUtc]
    ,[EmailAccountId]
    FROM [QueuedEmail]

    customer table
    SELECT TOP 1000 [Id]
    ,[CustomerGuid]
    ,[Username]
    ,[Email]
    ,[Password]
    ,[PasswordFormatId]
    ,[PasswordSalt]
    ,[AdminComment]
    ,[LanguageId]
    ,[CurrencyId]
    ,[AffiliateId]
    ,[Active]
    ,[Deleted]
    ,[IsSystemAccount]
    ,[SystemName]
    ,[LastIpAddress]
    ,[CreatedOnUtc]
    ,[LastLoginDateUtc]
    FROM [Customer]

    DB:2.84:Stored Procedure For Sending Email Within The Application 11

    Just to make sure, i am assuming that the [ID] field has the relation inbetween the 2 tables , and its a 1 to 1 relation (unless you have other related tables)
    so you should have

    SELECT F1, F2 , F3, ....... FROM Customers C JOIN QueuedEmail Q
    ON C.[Id] = Q.[Id]
    WHERE CreateOnUtc CONVERT ( VarChar(10), GETDATE() , 120 )
    Sincerely Nik -- MCITP , MCTS -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

  • RELEVANCY SCORE 2.84

    DB:2.84:Problem Of Retrieving Blank Field 7j


    i got a table saved as .txt as follows

    "LABEL: 012345","jithin a ","321 WEST 31 tw ","China HOND CA 43212 "," "," "," "," "," "

    i just port this to oracle table using SQLLDR. Here some columns are blank.But when i tried to retrieve that field with
    select * from table_name where coloumn_name is null;
    No column get retrieved.y thiz happens.how can i retrieve column with blanks.please help me.

    DB:2.84:Problem Of Retrieving Blank Field 7j

    Hi,

    Why dont u try to use TRIM function .. I think certain fields can contain spaces ... try that out .. Ya correctly mentioned my Kamal.... those columns arent NULLS ..use either LTRIM or RTRIM or may be both

    Regards

    Message was edited by:
    Seshu

  • RELEVANCY SCORE 2.84

    DB:2.84:Accessing Computed Column Specification xx


    Hi,
    Is there any way to retrieve the formula stored in the table columns Computed Column Specification to the .NET DataTable object?
    I'm using a System.Data.SqlClient.SqlDataAdapter to retrieve the data.
    Thanks in advance.

    DB:2.84:Accessing Computed Column Specification xx

    Hi Ptak Sebastian,
    Which version of SQL Server are you using?
    If its SQL Server 2005 or a later version, we can retrieve the computed column formulas from sys.computed_columns.
    Please see:

    SELECT OBJECT_NAME(object_id) AS TableName,name AS ComputedColumn,definition FROM sys.Computed_columns

  • RELEVANCY SCORE 2.84

    DB:2.84:Split Table Columns Into Tabs dd


    Hi everyone,

    I want to create an application where I retrieve the data from a database table and display it split into tabs.
    So, I want tab1 to display columns 1 to 5, tab2 to display columns 6 to 10 etc.

    How can I do that?

    Thank you!

    DB:2.84:Split Table Columns Into Tabs dd

    Thank you so much, your suggestions led to exactly to what I was trying to achieve!

    PS: My name is Adina, it's nice to meet you!

    Edited by: user12169513 on Aug 12, 2010 8:09 AM

  • RELEVANCY SCORE 2.84

    DB:2.84:How To Retrieve Values From Table Cell 3s


    hi,
    iam having a table with 15 rows and four columns..

    in second column each row consists of combobox..
    if it is normal table cell we can retrieve value

    for(int i=0;i15;i++)
    {
    op = (String) table.getValueAt(i, 1)

    }

    but in table cell i have a combo box named operaterCombo[]

    so which method can i use to retrieve value from that combo which is in that table cell..

    can u plz suggest me..
    regards,
    sam

    DB:2.84:How To Retrieve Values From Table Cell 3s

    Here's one way
    http://forum.java.sun.com/thread.jsp?forum=57thread=446022

    You can also create your own tablecelleditor which returns different comboboxes depending on the value in another column

  • RELEVANCY SCORE 2.84

    DB:2.84:Retrieving Column Metadata For A View 3m


    Hi,

    I can see how it is possible to retrieve details of all columns in a table by querying the sys.tables and sys.columns views. Is there a similar way to retrieve the details of all columns for a view?

    Thanks,
    Ben

    DB:2.84:Retrieving Column Metadata For A View 3m

    I'm afraid not. Currently TimesTen encodes view information in a proprietary internal format in the system catalogs.

    Sorry.

    Chris

  • RELEVANCY SCORE 2.84

    DB:2.84:Generatedvalue Within Embeddedid c1


    My company has a table that has a primary key of 5 columns, one of which is an auto-generated sequence. This was not always an auto-generated sequence, and previously was only unique for any combination of the first 4 columns, not unique for the entire table. Therefore, the primary key of the table cannot be simply changed to this one sequence column. However, the column is part of the primary key, and it is unique for any rows forward.

    My entity based on this table has an embedded id which encompases the five columns, one of which is the sequence column. Is it possible for me to use a sequence generator to generate the value for this column within the embedded id?

    Ive tried putting the necessary sequence annotations in the embedded object, but they are ignored. I dont believe there is any place to put the sequence annotations within the AttributeOverrides of the entity object. Therefore, I'm guessing the only way to populate the column will be for me to manually retrieve the next sequence from the database and set it myself. Is this correct?

    Thanks!

    DB:2.84:Generatedvalue Within Embeddedid c1

    My company has a table that has a primary key of 5 columns, one of which is an auto-generated sequence. This was not always an auto-generated sequence, and previously was only unique for any combination of the first 4 columns, not unique for the entire table. Therefore, the primary key of the table cannot be simply changed to this one sequence column. However, the column is part of the primary key, and it is unique for any rows forward.

    My entity based on this table has an embedded id which encompases the five columns, one of which is the sequence column. Is it possible for me to use a sequence generator to generate the value for this column within the embedded id?

    Ive tried putting the necessary sequence annotations in the embedded object, but they are ignored. I dont believe there is any place to put the sequence annotations within the AttributeOverrides of the entity object. Therefore, I'm guessing the only way to populate the column will be for me to manually retrieve the next sequence from the database and set it myself. Is this correct?

    Thanks!