Home » SQL & PL/SQL » SQL & PL/SQL » Retrieve font name available in OS using sql plus (Windows 7, Oracle 10g XE)
Retrieve font name available in OS using sql plus [message #602433] Wed, 04 December 2013 06:13 Go to next message
lock_heart
Messages: 36
Registered: November 2013
Member
I want to if is it possible to retrieve all font name which are available in operating system using sql plus. If yes can anyone tell me how to retrieve it...thanks in advanced

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602434 is a reply to message #602433] Wed, 04 December 2013 06:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
lock_heart wrote on Wed, 04 December 2013 04:13
I want to if is it possible to retrieve all font name which are available in operating system using sql plus. If yes can anyone tell me how to retrieve it...thanks in advanced



post OS command & results that show all available OS fonts.

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602440 is a reply to message #602434] Wed, 04 December 2013 06:32 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Can you please tell me query

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602442 is a reply to message #602440] Wed, 04 December 2013 06:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can you please tell me query
I will answer your question after you answer my question.
Which OS command shows all available fonts on this system?

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602444 is a reply to message #602442] Wed, 04 December 2013 06:39 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Control fonts commands

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602447 is a reply to message #602444] Wed, 04 December 2013 06:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
lock_heart wrote on Wed, 04 December 2013 04:39
Control fonts commands


use COPY & PASTE to show actual command invocation & results produced from your OS so I can replicate on my Windows PC

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602449 is a reply to message #602447] Wed, 04 December 2013 06:49 Go to previous messageGo to next message
Littlefoot
Messages: 21760
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try on my PC:
M:\>c:

C:\>cd windows\fonts

C:\Windows\Fonts>dir *.ttf
 Volume in drive C is OSDisk
 Volume Serial Number is EA24-C97C

 Directory of C:\Windows\Fonts

10.06.2009.  21:43           774.476 arial.ttf
10.06.2009.  21:43           751.104 arialbd.ttf
10.06.2009.  21:43           563.800 arialbi.ttf
10.06.2009.  21:43           557.760 ariali.ttf

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602450 is a reply to message #602449] Wed, 04 December 2013 06:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
1) issue DIR command that redirects results to a text file
2) map this text file as EXTERNAL TABLE
3) issue SELECT against EXTERNAL TABLE

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602453 is a reply to message #602450] Wed, 04 December 2013 07:12 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Hey thanks for all of your help Smile

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602457 is a reply to message #602450] Wed, 04 December 2013 07:21 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Hi i tried to redirect it into test file but it saying access is denied

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602458 is a reply to message #602457] Wed, 04 December 2013 07:27 Go to previous messageGo to next message
Littlefoot
Messages: 21760
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Redirect it to a file that is located in a directory you can write to. C:\Windows\Fonts, most probably, isn't the one to be chosen. Try C:\Users\... (on Windows 7).

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602461 is a reply to message #602458] Wed, 04 December 2013 07:34 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Thanks

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602468 is a reply to message #602433] Wed, 04 December 2013 08:54 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3212
Registered: January 2010
Location: Connecticut, USA
Senior Member
lock_heart wrote on Wed, 04 December 2013 07:13
I want to if is it possible to retrieve all font name which are available in operating system using sql plus. If yes can anyone tell me how to retrieve it...thanks in advanced


You must be more specific. Are you talking fonts on database server or on the client who runs SQL*PLus. Suggestion you were given will work if you are looking for fonts on database server, or if database server and client are on the same box.

SY.

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602553 is a reply to message #602468] Thu, 05 December 2013 11:40 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 606
Registered: August 2002
Senior Member
Most probabaly nearest solutions
https://www.java.net//node/709392
please read this..

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602560 is a reply to message #602553] Thu, 05 December 2013 12:49 Go to previous messageGo to next message
lock_heart
Messages: 36
Registered: November 2013
Member
Thanks but i simply want to use sql plus and oracle form

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #602564 is a reply to message #602560] Thu, 05 December 2013 13:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
lock_heart wrote on Thu, 05 December 2013 10:49
Thanks but i simply want to use sql plus and oracle form


most folks do not have to mess with OS fonts to use sqlplus or forms.

What problem are you really trying to solve?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Retrieve font name available in OS using sql plus [message #685001 is a reply to message #602457] Wed, 06 October 2021 23:28 Go to previous message
MaaM
Messages: 1
Registered: October 2021
Junior Member
I need guys to create fonts dialogue form in replace of using this function Choose_font because it's not supported in oracle forms 12c?
How can I create an item list by the available fonts on windows to display in form and also the style to work when the users open the list to choose the fon and style and reflected on the screen!

Thanks

Report message to a moderator

Previous Topic: REGEXP_LIKE
Next Topic: Is there a way to create a materialized view with datatype and length?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 28 03:40:18 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.