SQL & PL/SQL :: How To Get First Word From String

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


ADVERTISEMENT

PL/SQL :: Counting Particular Word In String?

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

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 View Related

SQL & PL/SQL :: How To Extract First 3 Characters From Each Word In A String / Sentence And Separate With Underscore

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

SQL & PL/SQL :: Function To Duplicate The Word

Apr 13, 2012

function to duplicate the word

example member

result will be meber

View 11 Replies View Related

SQL & PL/SQL :: Possible To Do Specific Word Count

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

SQL & PL/SQL :: Oracle - Word Bookmark?

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

SQL & PL/SQL :: Letter Generation In Word?

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

SQL & PL/SQL :: Upload Word File

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

ORA-02085 - Database Link String Connects To String

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

Data Migration From WORD To ORACLE?

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

How To Convert PDF To Office Word File

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

Forms :: Printing A Word Document

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

SQL & PL/SQL :: Escape Special Character Word

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

SQL & PL/SQL :: How To Find Whether Exact String Is Present / Not In Given String

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

Forms :: Open New Word Document And Delete It?

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

Reports & Discoverer :: Masking Number To Word

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

Windows :: Data From Oracle To Microsoft Word

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

Generate Oracle Report And To MS Word Format?

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

Forms :: Create And Format A Word Document From 6i

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

Reports & Discoverer :: To Use Superscript / Subscript Just Like In Word In Rdf

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

SQL & PL/SQL :: Implement Word Wrap Feature In Code

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

Reports & Discoverer :: Adding Word (continued) To Report Value?

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

Forms :: Open Word Document / Excel / PDF From Oracle?

Mar 25, 2008

I would like to open a word document /excel sheet /pdf from oracle forms.

View 20 Replies View Related

Reports & Discoverer :: How To Make Subscript In Oracle Like In MS Word

Jun 17, 2011

How to make subscript in Oracle like in Msword

View 1 Replies View Related

Forms :: Open Word Document / Excel And PDF From Oracle?

Apr 29, 2010

does the path of office on the server or on the client PC?

View 1 Replies View Related

Forms :: Ole2 Data From Database To Word Document?

Apr 25, 2007

I am porting data from database to word document.Initially i am creating the table using the following

hSelection := OLE2.GET_OBJ_PROPERTY(hApplication, 'Selection');
hTables := OLE2.GET_OBJ_PROPERTY(hDocument , 'Tables' );
hRange := OLE2.GET_OBJ_PROPERTY(hSelection, 'Range');
args := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG_OBJ(args, hRange); --Range
OLE2.ADD_ARG(args, 26); --NumRows
OLE2.ADD_ARG(args, 4); --NumColumns
OLE2.ADD_ARG(args, wdWord9TableBehavior); --DefaultTableBehavior
OLE2.ADD_ARG(args, wdAutoFitContent); --AutoFitBehavior
hTable := OLE2.INVOKE_OBJ(hTables, 'Add', args);

But i want to change the columnwidth. As you see above i have 4 columns, in that first column should be double than other column.

peice of code to change th ewidth of column in word document.

View 6 Replies View Related

SQL & PL/SQL :: Add Word Grand Total Under Tester Column After Roll Up

Sep 17, 2010

Below is the statement I am working with. When I get the result the under the Tester column it is a empty space after the total has been done. How can I add the word "Grand Total" under the tester column after the rollup.

SELECT BG_detected_by Tester, CONCAT(Round(count(bg_target_rcyc) / count(bg_status)* 100), '%') Percentage_Compeleted,count(BG_Target_RCYC) Total_Target_Cycle,count(bg_status) Total_Defects
From Bug
where BG_STATUS = 'Open'
GROUP by Rollup(BG_DETECTED_BY,BG_STATUS)
having (grouping(bg_detected_by) = grouping(bg_status))

Tester Percentage_completed Target Defects
empty space --->Grand Total

View 1 Replies View Related

Application Express :: How To Save And Edit Word Template

Aug 30, 2012

How to save and edit a Word template and excel (extension. doc and. xls), which can be opened to allow the document and record all changes made ​​by the user of the pacification.

View 0 Replies View Related

JDeveloper, Java & XML :: Regular Expression For Exact Word And Occurrence

Mar 15, 2012

I need to search a specific pattern from a source code. In word, I need to check whether "getCode" has been called or not, for all the string inside double-quote("). Following are sample code lines -

1.->if(val==23){ month_desc = "a sample data"; }
2.->if(val==23){ month_desc = getCode("a sample data"); }
3.->if(val==23){ month_desc = "a " + getCode("sample data"); }
4.->if(val==23){ month_desc = getCode("sample data"); var2="sample data2";}

Now, expression should be such that it will return true during check for 1, 3 and 4, although, for 3 & 4 getCode has been called for part of the String.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved