SQL & PL/SQL :: How To Retrieve First Letter Of Every Word From String
Oct 4, 2013
I want to retrieve first letter of every word from the string.
For ex. if string is "Computer Science Engineering (New)" then I want "CSE" or if string is "Mechanical Engineering" then "ME".
how to do this..
View 18 Replies
ADVERTISEMENT
Jul 2, 2012
i need to write to word doc from pl/sql . these are letters which needs to printed . Can i use the same UTL_FILE and will i be able to control the font etc from pl/sql
View 6 Replies
View Related
Aug 22, 2013
how to get first word from string.example i have string like:-
Jack Bore American
Mark D'suz Australian
Raj
Deniel indian
Some
i am expecting first word as out put like :-
jack
mark
Raj
Deniel
Some
in the same maner if i want should get two words also.
View 36 Replies
View Related
Jul 17, 2012
Have a query to find the occurence of a particular word in a string using a query.
ex: str := 'a,b,a,c,d'
search_str := 'a'
=> need to get the number of times 'a' is getting repeated in the string str.
output: 2
View 9 Replies
View Related
Oct 22, 2013
I have some strings like
'Net Amount Payable by an Individual',
'Net Amount Payable by an Individual+Tax',
'Total Amount Payable towards Service',
'Total Amount Payable towards Service.+Tax'
I need to extract the first three letters from each word and separate them using an underscore. The output should be as follows for the above strings -
Net_Amo_Pay_by_an_Ind
Net_Amo_Pay_by_an_Ind_Tax
Tot_Amo_Pay_tow_Ser
Tot_Amo_Pay_tow_Ser_Tax
I request to let me know the way to get the ouput as mentioned.
View 4 Replies
View Related
Feb 5, 2013
Objective: I need to compile a final string by concatinating the unique values from different strings.
Here is the script to create tables and data.
Create table temp_acronyms(id number, acronym varchar2(30);
insert into temp_acronyms values(1, 'ABC');
insert into temp_acronyms values(2, 'DEC//NOFO');
insert into temp_acronyms values(3, 'CBK//FO TO USA');
insert into temp_acronyms values(4, 'DEC//NO ENTRY');
insert into temp_acronyms values(5, 'ABC//NOFO');
COMMIT;
select * from temp_acronyms;
ID ACRONYM
--- --------
1 ABC
2 DEC//NOFO
3 CBK//FO TO USA
4 DEC//NO ENTRY
5 ABC//NOFO
I need to store all the unique strings from the acronyms for id's 1,2, 3, 4 and 5 into a variable. doesn't matter even if it is through database procedure.
my final string should have the values as below
ABC//DEC//NOFO//CBK//FO TO USA//NO ENTRY
View 6 Replies
View Related
Jul 8, 2012
I have a table
select * from testing
Quote:
ID NAME REDATA
-------------------- -------------------- --------------------
1 ABC,DEF,GHI,LKJ 000001
2 MNC,GHI,CTF 000002
2 rows selected
select * from testing where name like ('GHI,TCF');
now my output should be as above because GHI is common in both the names.if any of the where condition string matches the Name field then I need that record to be retrieved.
View 9 Replies
View Related
Nov 25, 2010
My own created software is running since last 4 years but now when I am trying to run a report then I got a message "REP-0002 unable to retrieve a string from the report builder" and as a result my report don't run. Please note that some other reports are working properly, this problem is happens only with some of them reports.
View 3 Replies
View Related
Jul 30, 2010
how to select the name that starts with first letter caps.
Eg:
Emp_Name Emp_id
Raga 101
Purnima 102
Vicky 103
ragu 104
raman 105
Santhosh 106
output should like as following:
Emp_Name
Raga
Purnima
Vicky
Santhosh
4 row(s) affected.
View 39 Replies
View Related
Jun 22, 2010
I need a sql/function that formats employee names in Initcap including names with internal capital letters.For example:
Mark VanTassel should be Mark VanTassel and not Mark Vantassel
McGowen should be McGowen
O'Neil should be O'Neil.
found this on the web but didn't quiet understand and didn't work for me.
CREATE OR REPLACE FUNCTION cul_initcap(input_val text) RETURNS text AS
BEGIN
SELECT
REPLACE(
REPLACE(
REPLACE(
REPLACE(
[code]....
View 11 Replies
View Related
Jul 6, 2013
I know I can add a check constraint for m,t,w,r,f,s,u How can I add a constraint that will allow any combination of the above. For example it would allow m or mf, or mwf Someone said it could be done with trim but I can not figure it out.
View 1 Replies
View Related
Apr 13, 2012
function to duplicate the word
example member
result will be meber
View 11 Replies
View Related
Jan 24, 2011
Can we do a specfic word count in sql. Requirement is there is a string "I am very very poor in sql" the word "very" occurs two times, so the result should be 2.
View 16 Replies
View Related
Jun 12, 2013
.I am actually collecting data from Oracle and create bookmarks on a word document which correspond to these data and auto-complete it.
I had not any important problem until that I had a case where I do not know the number of data I am going to get in the end. Do not know how much bookmarks I should create as I don't know the number of rows I am going to get after executing my query.
View 33 Replies
View Related
Aug 9, 2010
i want to upload a word file to database.I wrote the following code
create or replace directory MY_FILES as 'C:Uploadfolder';
Create table emp1(
EMPNO number(30),
EMPNAMe varchar2(10),
RESUME BLOB);
[Code]....
ERROR at line 1: ORA-22288: file or LOB operation FILEOPEN failed No such file or directory ORA-06512: at "SYS.DBMS_LOB", line 523 ORA-06512: at line 10
View 32 Replies
View Related
Jun 19, 2012
I have this error (and solution):
ORA-02085: database link string connects to string
Cause: a database link connected to a database with a different name. The connection is rejected.
Action: create a database link with the same name as the database it connects to, or set global_names=false.
Where should I set global_names=false ?
View 7 Replies
View Related
Sep 20, 2011
I have a long file in WORD as I try to load it in ORACLE quotes become periods, ex:
insert into mytab values ('myname, 26);
when i copy this and paste it in oRACLE (UNIX environment), it translates as insert into mytab values (.myname.,26)..does not recognize the quotes.
I tried copying from word to notepad to ORACLE same problem..
View 5 Replies
View Related
May 26, 2012
I download a pdf file,but I want to use it in the office word,who knows how to convert it?
View 11 Replies
View Related
Feb 9, 2011
I have This Code working on the local form builder after starting the oc4j and run the form. but using OLE2.
but when using the Cleint_ole2 on the application to invoke an object on the client machine.
but nothing happend, while i have tested the webutil configaration and its working fine.
i use this code to print any word document without openning it. and here is the code in when_button_pressed
DECLARE
application CLIENT_OLE2.OBJ_TYPE;-- Declare a object OLE
args CLIENT_OLE2.LIST_TYPE; -- Declare List of Parameters to obj. OLE
begin
application := CLIENT_OLE2.CREATE_OBJ('WORD.Basic'); -- Start a process WordBasic
args:= CLIENT_OLE2.CREATE_ARGLIST;-- Create a list of Parameters
-- Add param. file_name with path(x. c: empmy.doc) :blk01 is my block
[Code]...
View 1 Replies
View Related
Jan 7, 2011
E1 Table Data
Job_id
Sa_Clerk
Sa_Manager
Sahil
select job_id from E1 where instr(job_id,'_')>0;
returns output
Sa_Clerk
Sa_Manager
same as
select job_id from E1 where job_id like 'Sa_\%' escape '';
resturns
Sa_Clerk
Sa_Manager
Same Result , Then What is exact need of Escape
View 4 Replies
View Related
Mar 14, 2013
I'm facing some problem even after using INSTR function in Oracle.The problem is I have written the logic in the PL/SQL block which appends all the values fetched in a loop on the basis of whether the string is present or not.
For ex:
The first value fetched from the select query first is ABCDEFG which gets appended to a variable
The next value fetched is AB even this has to be appended to the variable since this exactly doesn't match with ABCDEFG.
The next value fetched is BCDEF even this has to be appended to the variable since this exactly doesn't match with ABCDEFG.
The third Value fetched is ABCDEFG this will not get appended presently according to the logic which is correct.
writing that piece of code to append the value fetched which doesn't exactly match with the existing string
View 3 Replies
View Related
Mar 26, 2013
i have one word doc file name is sample.doc
i have 3 buttons in my canvas. 1st button is to open a word document.
codings:
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('D:Program FilesMicrosoft OfficeOffice12winword.exe F:DevSuiteHome_1formssamples.doc',DDE.APP_MODE_NORMAL);
end;
2nd button:
i want to delete the existing sample.doc file via forms
i dont know the codings.
View 2 Replies
View Related
May 21, 2013
I just want to know whether we can mask salary column of number datatype into text ,like we used to_char(to_date(<column_name>,'j'),'jsp') in sql? for example
Name Salary
SMITH 800
to
Name Salary
SMITH EIGHT HUNDRED
View 5 Replies
View Related
Jun 30, 2011
I need to create a doc file using Microsoft Word where I can get data from an Oracle DB.
I search on MS Word, for something like ODBC (like in Excel and Access) but in vain.
I need to do this so I can format the data on the doc file in any way I want. Not like in Oracle Reports, where formatting is a little bit restrictive.
View 9 Replies
View Related
May 25, 2011
I would like to generate oracle report and to MS word format? new xml format of MS office?
View 2 Replies
View Related
Oct 6, 2011
I need to generate quotation from Forms 6i. A copy fo the quotation is being uploaded. All information in the word document that are highlighted in yellow are taken from a database.
I need to create the document in the format of the uploaded file. There will be some tables also in the document.
View 1 Replies
View Related
Jun 15, 2010
I want to use superscript / subscript just like in word in rdf (oracle 8i / reports 6) for creating a footnote. for e.g. reserch1 . 1 should appear on top . is it possible to in reports to do that.
View 1 Replies
View Related
Jan 24, 2012
I want to implement word wrap feature in code.
Requirement is format given multi line text in the specified lines and each line be of specified character. Here words should not be broken, instead they must come to new line if lines are available.
Function could of the sort:
CREATE OR REPLACE FUNCTION wrap_text(p_text VARCHAR2
,p_len NUMBER-- no of lines
,p_chr NUMBER--no of chr/line
)
RETURN VARCHAR2;
View 4 Replies
View Related
Apr 18, 2012
I have had a request to add the word "continued" if a field has to print on more than one page. For example, if there are values associated with a city, and these values and city must print on another page, the user would like the word "continued" on the second, third, etc iteration of the city.
example:
page 1
Fort Worth value
value
value
THEN next page, continuing the rest of Fort Worth's values:
page 2
Fort Worth continued <--the word "continued" added for next pg
value
value
value
View 1 Replies
View Related
Mar 25, 2008
I would like to open a word document /excel sheet /pdf from oracle forms.
View 20 Replies
View Related