SQL & PL/SQL :: Possible To Do Specific Word Count
Jan 24, 2011Can 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
ADVERTISEMENT
SQL & PL/SQL :: Count Of Rows For Specific Period?
Aug 12, 2010I need to get the number of rows based on one condition for certain time period. For example, writing a query for 3(any) hrs , i need to get the output as count of rows as hourly basis. Like these:
Date Time Count
12/08/2010 16:00 234
12/08/2010 17:00 345
12/08/2010 18:00 645
Security :: Audit Specific Statement On Specific Table By Specific User?
May 29, 2012I'd like to know if it is possible to track DML actions issued on a specific table by a specific user, for example , i tried :
AUDIT SELECT on SCOTT.DEPT by HR by ACCESS;
I get an error, where is my syntax error ?
i want to know if it's possible to do it without trigger ?
Displaying Records Between Specific Times On Specific Dates?
Apr 11, 2011I have a database which consists of various orders and various field.
I have a variable called createddatetime . I want that whenever i should run the database it should display records from
Yesterday 06:00:00 am to Current Date 05:59:59 am
Now to implement this i tried to put this syntax
and to_char(Createddatetime,'dd/mm/yyyy HH24:mi:ss') between 'sysdate-1 06:00:00' and 'sysdate 05:59:59'
But nothing comes up
where as definitely there are records between times because when i do and Createddatetime between sysdate-1 and sysdate I see valid records coming up.
SQL & PL/SQL :: How To Get First Word From String
Aug 22, 2013how 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.
SQL & PL/SQL :: Function To Duplicate The Word
Apr 13, 2012function to duplicate the word
example member
result will be meber
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.
SQL & PL/SQL :: Letter Generation In Word?
Jul 2, 2012i 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 RelatedSQL & PL/SQL :: Upload Word File
Aug 9, 2010i 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
PL/SQL :: Counting Particular Word In String?
Jul 17, 2012Have 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
Data Migration From WORD To ORACLE?
Sep 20, 2011I 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..
How To Convert PDF To Office Word File
May 26, 2012I download a pdf file,but I want to use it in the office word,who knows how to convert it?
View 11 Replies View RelatedForms :: Printing A Word Document
Feb 9, 2011I 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]...
SQL & PL/SQL :: How To Retrieve First Letter Of Every Word From String
Oct 4, 2013I 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..
SQL & PL/SQL :: Escape Special Character Word
Jan 7, 2011E1 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
Forms :: Open New Word Document And Delete It?
Mar 26, 2013i 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.
Reports & Discoverer :: Masking Number To Word
May 21, 2013I 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
Windows :: Data From Oracle To Microsoft Word
Jun 30, 2011I 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.
Generate Oracle Report And To MS Word Format?
May 25, 2011I would like to generate oracle report and to MS word format? new xml format of MS office?
View 2 Replies View RelatedForms :: Create And Format A Word Document From 6i
Oct 6, 2011I 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.
Reports & Discoverer :: To Use Superscript / Subscript Just Like In Word In Rdf
Jun 15, 2010I 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 RelatedSQL & PL/SQL :: Implement Word Wrap Feature In Code
Jan 24, 2012I 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;
Reports & Discoverer :: Adding Word (continued) To Report Value?
Apr 18, 2012I 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
Forms :: Open Word Document / Excel / PDF From Oracle?
Mar 25, 2008I would like to open a word document /excel sheet /pdf from oracle forms.
View 20 Replies View RelatedReports & Discoverer :: How To Make Subscript In Oracle Like In MS Word
Jun 17, 2011How to make subscript in Oracle like in Msword
View 1 Replies View RelatedForms :: Open Word Document / Excel And PDF From Oracle?
Apr 29, 2010does the path of office on the server or on the client PC?
View 1 Replies View RelatedForms :: Ole2 Data From Database To Word Document?
Apr 25, 2007I 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.
SQL & PL/SQL :: Add Word Grand Total Under Tester Column After Roll Up
Sep 17, 2010Below 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
Application Express :: How To Save And Edit Word Template
Aug 30, 2012How 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 RelatedSQL & PL/SQL :: Difference Between Count(*) And Count(1)?
Nov 16, 2009When we execute select count(*) from table_name it returns the number of rows.
What does count(1) do? What does 1 signifies over here? Is this same as count(*) as it gives the same result on execution?