SQL & PL/SQL :: Uploaded Text File Since Format Is Not Fitting
Sep 25, 2013
I have uploaded the text file since format is not fitting here.I have a table called xyz and it has two colums called QU and collectionID..The data is stored in the table is like Scenario 1 but I want to extract the data to look like Scenario 2
Scenario 1
QU CollectionID
Blade: qcusrea11 / NOB1, null
null, SMRE11
null, SMRE21
null, SMRE31
null, SMRE41
[code]....
Scenario 2
QUCollectionID
Blade: qcusrea11 / NOB1 SMRE11
Blade: qcusrea11 / NOB1 SMRE21
Blade: qcusrea11 / NOB1 SMRE31
Blade: qcusrea11 / NOB1 SMRE41
[code]...
View 3 Replies
ADVERTISEMENT
Oct 11, 2010
We uploaded files to application server,using webutil_file_transfer.client_to_as_with_progress Now, we want to delete the file through forms, when user click a button.
we tried this,using HOST command.
DECLARE
CURSOR c_path
IS
SELECT attachpath
FROM PATHTAB
WHERE apid = :parameter.apid;
[code].....
View 10 Replies
View Related
Apr 17, 2012
Can I use rich text item on oracle form10G with some simple features like BOLD, UNDERLINE, ITALIC and if possible one more feature like spell check.
I Google my requirement, but mostly I found win word attachment. Further more if I can save this type of data in field then how can I print in report.
View 3 Replies
View Related
Dec 23, 2009
Is there any way to convert HTML format text to Plain Text ?
View 26 Replies
View Related
May 30, 2011
Is it possible to get the same name of file name from imported text file?
What i've is, I import the text file then I exported it.
can I get the same name of the imported text file?
View 2 Replies
View Related
Dec 30, 2010
I have a requirement in one of my forms screen.I have a text box(large text area) which should display a help text file when i move my cursor on the topics displayed on the screen.know the code and the properties to be changed in the text box to accommodate large external file text.
View 1 Replies
View Related
May 29, 2012
Im trying to insert a number specified by the format for ex. S999.99, but the original text is of the form S99999, is there any way i can insert the data which will store it in the DB with the datatype as Number(5,2), the decimal is not present in the supplied value(through PreparedStatement) but needs to be put while inserting into the DB.
P.S.- 'S' in S999.99 signifies the sign(+/-).
View 1 Replies
View Related
Nov 13, 2013
Apex 4.2 I have an interactive report.I use the sum attribute on the column and break formatting option to create a report total on one columnReport Sum Label Total:Break Columns No BreaksHow to I format the total text and value in to red
View 16 Replies
View Related
Jun 19, 2012
Is there a way to add a water mark on the uploaded images. I searched the web it could be done with PHP, but what about APEX ?
View 2 Replies
View Related
Apr 9, 2011
Oracle10g to Sybase12.5 Migration:- How a Oracle dump file can be converted to any text file/xls file which will be loaded in sybase database later through BCP.
means
1.Exporting objects as dump file from Oracle.
2.Is there any tool/process available that can convert this into csv/txt/xls file.
3.This files can be loaded in sybase.
View 2 Replies
View Related
Jan 27, 2012
I have developed one rdf in Text Output Format.In this some special characters is coming for Text Output format of rdf.Shall i do any adjustments in layout? How to remove these special characters?
View 3 Replies
View Related
Aug 24, 2012
By default number that "starts" with a leading zero with decimals - zero is removed. 0.49 => .49
I'm adding for e.g. the mask "FM990D0999". 0.49 => 0.49
Ok this is fixed.But if I have an integer without decimal. 1 => 1.0
If I change the mask to FM990D9999 1=> 1.
I would like to have a zero leading when it's 0.49 but also no decimal when it's an integer => 1
APEX 4.0 with 11g
View 2 Replies
View Related
Oct 13, 2012
i have text item :P1_ADMISSION_DATE .i want to validate that item if user does not enter valid date forrmat then display me error.
Date Format is 'DD-MON-YYYY'
i have try with PL/SQL Expression in Validation
My validation code
:P1_ADMISSION_DATE=TO_CHAR(SYSDATE,'DD-MON-YYYY');How can i validate :P1_ADMISSION_DATE to enter valid date format by user.
View 2 Replies
View Related
Nov 2, 2010
I have a doubt; can we format a particular word in oracle reports at runtime..?
Ex:-
A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.
We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?
View 10 Replies
View Related
Jan 19, 2011
I received a POS csv file with XML format that contain a multiple customer column and information within a csv file. I need to extract store number and associate ID from a csv column. I had already loaded the csv file to a external table and I am stuck on how to retrieve the data to a stage table along with other csv column.
For example, I need to pull data from col1, col2, col3, and col4 which col4 contain data for store_numner and associate id from a external table to a staging table which my staging table have col1, col2, col3, store_nbr column, and associate id.
View 5 Replies
View Related
Apr 28, 2008
i have be requested to create a .txt file. Its for a program that will read the txt file i create to produce a letter i.e I will be extracting, TITLE, FORENAME, SURNAME etc
MR
JOE
BLOGGS
Here is the my code so far,
SELECT
LPA_INPUT.INPUT_TITLE,
LPA_INPUT.INPUT_SURNAME,
LPA_HISTORY.LPA_AMT,
LPA_HISTORY.ELIG_RATE,
LPA_HISTORY.RATE_REBATE,
LPA_HISTORY.RR_AMT,
LPA_HISTORY.LPA_APPLIC,
LPA_HISTORY.LPA_AMT
FROM LPA_HISTORY, LPA_INPUT
WHERE LPA_HISTORY.CLAIM_NO = LPA_INPUT.CLAIM_NO
----------------------------------------------------
Iv been asked to have these eight fields looping over and over for all the records in the database, So im not sure how to do that and how to generate it in a txt file?! I have to produce it in a script and not by a Export/Import wizard in sql server mangement studio!!!
View 11 Replies
View Related
Feb 11, 2011
is there anyway to convert plb file to sql file or text file
View 20 Replies
View Related
Dec 14, 2006
I want to load data to a table and from a simple file text, using a Vb.net application which will connect to a oracle 10g , or a SqlServer or a MySql database, depending the params.
When i connect to a SqlServer Database i use the sql command "BULK INSERT CODPOSTAL2 FROM file.txt with( DATAFILETYPE = 'char',FIELDTERMINATOR = ';', ROWTERMINATOR = '
')"m" and it works fine.
With a DB Mysql i use "LOAD DATA INFILE file.txt INTO TABLE CODPOSTAL2 FIELDS TERMINATED BY ';''" and also works.
My problem is with Oracle. I tried the same example as MySql, but it gaves the error "wrong" ou "unknown command". I also tried in Sql*Plus but it seems to not recognised the command "LOAD".
Another thing, i can't use the Oracle Loader, it must be like this.
View 5 Replies
View Related
Aug 2, 2010
i want to convert an excel file into text and then into oracle table.
View 6 Replies
View Related
Apr 11, 2013
suppose i have a file named chk.txt and I have write 10 line in that file and i just want to write some text at line 5 or line first then how we can do this ?
View 3 Replies
View Related
Mar 9, 2011
I am trying to get query output into textfile.The following procedure is working fine by creating directory as follows in sys user.The output is getting onto text file and it seen on server machine even.My question is I want to see the text file on local machine also instead of everytime connecting to server machine drive.How can I perform that?
create or replace directory INFO_DIR as 'D:Swapna';
grant read, write on directory INFO_DIR to fairpoint;
CREATE OR REPLACE PROCEDURE FAIRPOINT.utl_file_test_write_xls(filename in VARCHAR2 )
IS
output_fileutl_file.file_type;
v_pathVARCHAR2(500);
v_stringVARCHAR2(4000);
v_sqlstrVARCHAR2(2000);
BEGIN
BEGIN
[code]....
View 5 Replies
View Related
Nov 15, 2011
How to make the multiple lines of character in single line. Below is the example where i am getting the value when we export the data from the database table.
----------------------
Welcome Aboard customer contact based on Account activation.
The current selection criteria for Welcome Aboard is based at the service level. Therefore, each time a customer connects a service, Welcome Aboard material is mailed to the customer. This is causing the following problems;
Customer complaints. If a service or a number of services are connected on a particular day, it will result in (ie except for some minor exclusions) a single Welcome Aboard pack being sent to each individual customer. As you can expect for corporate accounts, they receive a high volume of this material. Other problems occur when, service/s are deactivated and reactivated, each time a Welcome aboard pack will be distributed.
High costs to Telstra. Each MNET service connected may produce a Welcome aboard pack. This volume of material currently costs Telstra over $500,000 per quarter for Welcome Aboard alone.
------------------------------
here is what i want to the above data to export:
----------------------
Welcome Aboard customer contact based on Account activation.The current selection criteria for Welcome Aboard is based at the service level. Therefore, each time a customer connects a service, Welcome Aboard material is mailed to the customer. This is causing the following problems;Customer complaints. If a service or a number of services are connected on a particular day, it will result in (ie except for some minor exclusions) a single Welcome Aboard pack being sent to each individual customer. As you can expect for corporate accounts, they receive a high volume of this material. Other problems occur when, service/s are deactivated and reactivated, each time a Welcome aboard pack will be distributed. High costs to Telstra. Each MNET service connected may produce a Welcome aboard pack. This volume of material currently costs Telstra over $500,000 per quarter for Welcome Aboard alone.
View 3 Replies
View Related
Apr 4, 2013
I create a text file with cobol, and now I need to remove the last character of each line with pl / sql. For example:
12 *
23 *
45 *
I need to remove *
View 7 Replies
View Related
Feb 23, 2013
How to write to text file using oracle? And how do I handle spaces/next line? (i was trying to use spaces(ch(32)), however it is just converted into squares in the text file.)
View 5 Replies
View Related
Jan 20, 2011
I use sqplus in oracle to output the command output to text file .
I use below set environment variable.
SQL> set echo off;
SQL> set linesize 3999;
SQL> set feedback off;
SQL> set feedback off;
SQL> set termout off;
SQL> set pagesize 0;
SQL> spool mapping.txt
select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
In ouput file , it look like
SQL> select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
060010007 10007
:
:
:
SQL> spool off;
any setting or command that allow me to remove the first sql command line" SQL>select XXXX" and the last command "SQL>spool off" after start up the "spool mapping.txt"
View 1 Replies
View Related
Apr 12, 2010
I want to know the file format of .dbf file.I want to open it in hex editor and want to read contents of that file from there.
View 4 Replies
View Related
May 8, 2013
Need to transform a fixed delimited file to an XML format.
A WSDL file is given which is composed from a header and body. We need to map the fixed file to the body node.
Let me know the steps and also a sample xml for the same if possible.
View 6 Replies
View Related
Oct 9, 2013
i want table data exported to txt file, data is around 3200000,
View 14 Replies
View Related
May 3, 2011
I want to import text from text file. How i can import in oracle forms ( oracle 9i)
View 7 Replies
View Related
Aug 8, 2012
I would like to load a text file into an oracle table.
View 10 Replies
View Related
