I need data from a table hrp1001 and a view V_USR_NAME. What they have in common are the content of the fields SOBID and BNAME .
It will be easier if those fields add a same type but they dont.
Any suggestions for a workaround?
10-11 Source: Network gathering Views:0
hi all, I need data from a table hrp1001 and a view V_USR_NAME. What they have in common are the content of the fields SOBID and BNAME . It will be easier if those fields add a same type but they dont. Any suggestions for a workaround? ThanksHi Rames
Hello all, I am getting the follwing error while selecting data from external table. Any idea why? SQL> CREATE TABLE SE2_EXT (SE_REF_NO VARCHAR2(255), 2 SE_CUST_ID NUMBER(38), 3 SE_TRAN_AMT_LCY FLOAT(126), 4 SE_REVERSAL_MAR
How to select data from a table using a date field in the where condition? For eg: data itab like equk occurs 0 with header line. select * from equk into table itab where werks = 'C001' and bdatu = '3
How to select data from a table by passing document number from another table. for eg:- I want to display name, adres, region from ADRC table by using field delivery document number Kind Regards, Shanbagavalli.SHi Shanbagavalli, There are multiple so
HI Experts...! i m a beginner user and i want to select data from two tables proj and prps.....using joins.....and internal tables i have written a code... SELECT prps~pspnr prps~objnr prps~psphi proj~ernam proj~erdat
I am trying to select data from two tables. The only problem that I am running into, is that i am only seeing results from my 'uploads' table. there is also a record in documents where user = 1 that should show up. here is my sql: $userIDNum = 1;
hi experts, I have a report which picks data from bseg (cluster table ) for a month report it is taking around 4 minutes to process.I feel it is not good when take the report after some months. how to select data from these table???how
Hi there I was wondering if somebody could assist me. When I try to select data from an external table, no data is displayed, and in my log file I receive the following error: KUP-04026: field too long for datatype. Please find attached my external t
hi all, how to select data from different database tables with high performance. im using for all entries instead of inner joins, even though burden on data base tables is going very high ( 90 % in se30) hw to increase the performance. kindly, reply.
Hi Sdners, How select data from four or more tables please give me any suggestion. iam learner please help me Advance wishes sreenu Moderator Message: I've already locked 2 threads of yours. Please read the Rules of Engagement of this forum and abide
hi all, In the table user_views there is a LONG column. Now i want to select rows from that table based on this LONG column. like.... select *from user_views where text like '%account%; but i am getting the error.."ORA-00932: Inconsistent datatypes:E
Hello everyone I'm trying to put in labview an SQL query on joined tables. As example I take a DB for storing the data of 2on2 basketball games, whose tables are matches(matchId,teamA,teamB) teams(teamId,PlayerAname,PlayerBname,Nationality) nationali
Hi I have to develop a report to give the details of Extended Withholding Tax (EWT) for a list of Expenses GL. Each expense GL is linked to another Gl which is the EWT Tax GL Account. This is maintained in a Ztable. I havae wirtten the following c
Hi Gurus, I am selecting 'First name' from oracle table directly using native sql. I am fetching 65000 records but 10+ records having '#' at the end of firstname. For eg: John#. But oracle team couldn't find '#' in their table for those records. What
Hi All, I am facing a problem with external tabels. I have created an external table create table ext_org_table ( id varchar2(10) , name varchar2(100) ,id_parent varchar2(10) ,name_parent varchar2(100)) organization external ( type oracle_loader defa
Hi everybody... I have one table with col1, col2, col3, col4, col5... as columns. I want to select col1, col2, col3 with condition (x=y and a=b and c=d) I want to select col4, col5 with condition (x=y and a=b and m=n ) in single query... Thanx for ur
I have two Tables containing Sales Data. I want to read the Table a sort by date and accumulate dollars by order date. Then I want to read the second table and accumulate these dollar amounts by date and then merge the records together so that I gave
hi, i need some help here as i am new to sql statement I have 3 tables. Table1 :- TeamID, Team_Name, Team_Logo Table2:- TeamID, PlayerID Table3:- PlayerID, Player_Name How do i do a single select statement that select all information from table1 and
Hi! I have to build a Select One table but I'd like to use instead the combination: radio button (to select) command button (to submint), only a command button placed in each row wich make both action with a single click. Is it possible? How? Thanks!
Hi, I was wondering how I would be able to do a SELECT on a table using EXECUTE IMMEDIATE. When I tried it (with the proc below), I got the following below. Can anyone tell me what I am doing wrong? Using Scott/Tiger I tried this: SQL> ed Wrote file