Home » SQL & PL/SQL » SQL & PL/SQL » interact command line select to files in this ? (Sql Plus Oracle12c Release 1)
interact command line select to files in this ? [message #621835] Mon, 18 August 2014 22:56 Go to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
i saw information on
http://www.orafaq.com/forum/t/162827/
when i implemented this information in my job, It's well done!
i found many Out Put (10,080 rows selected.)
i'm used to Compiler Source code (FUNCTION your_func) with Oracle SqlPlus.
Select to files from the command line itterface ?
so, now i like some further information form you about Data management
-How i can queuing them?
-How to make them show some information that I choose.

please tell me
i look forward to hearing from you.

Yours sincerely,

Navamin-Thailand

navaminroad@hotmail.com
Re: interact command line select to files in this ? [message #621836 is a reply to message #621835] Mon, 18 August 2014 22:59 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
Source code (FUNCTION your_func)

SCOTT@orcl_11gR2> CREATE OR REPLACE FUNCTION your_func
2 (p_digits IN VARCHAR2)
3 RETURN SYS_REFCURSOR
4 AS
5 v_digits SYS_REFCURSOR;
6 BEGIN
7 OPEN v_digits FOR
8 select distinct replace (sys_connect_by_path (digit,

'*'), '*', '') digits
9 from (select level i,
10 substr (p_digits, level, 1) digit
11 from dual
12 connect by level <= length (p_digits))
13 where level = length (p_digits)
14 connect by nocycle prior i != i
15 order by digits;
16 RETURN v_digits;
17 END your_func;
18 /

Function created.

SCOTT@orcl_11gR2> SHOW ERRORS
No errors.
SCOTT@orcl_11gR2> VARIABLE g_digits REFCURSOR
SCOTT@orcl_11gR2> EXEC :g_digits := your_func ('12342387')

PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> PRINT g_digits

DIGITS
--------------------------------------------------------------

------------------
12233478
12233487
12233748
12233784
12233847
... truncated to save space
87432312
87432321
87433122
87433212
87433221

10080 rows selected.

SCOTT@orcl_11gR2>
Re: interact command line select to files in this ? [message #621843 is a reply to message #621835] Tue, 19 August 2014 01:50 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

You question is not clear (not to me, at least). Please can you describe it again? What is that you want to do?
Re: interact command line select to files in this ? [message #621848 is a reply to message #621843] Tue, 19 August 2014 02:14 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
For example,if i were to interact with the command line select to files in this way:

please tell me
i look forward to hearing from you.

Yours sincerely,

Navamin-Thailand

navaminroad@hotmail.com
Re: interact command line select to files in this ? [message #621850 is a reply to message #621848] Tue, 19 August 2014 02:17 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Sorry, I do not understand what you want to do. This "interact with the command line select to files in this way:" does not make sense to me.
Re: interact command line select to files in this ? [message #621887 is a reply to message #621848] Tue, 19 August 2014 07:46 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
============================================================================
I hope you enjoy having your mailbox flooded by offers for certain, uh, anatomical enhancement products as well as offers you make you wealthy if you will help launder money out of Nigeria by supplying your bank account. Even as I type this, every web crawler on the planet is harvesting your email from this post and selling it.

Re: interact command line select to files in this ? [message #621946 is a reply to message #621887] Tue, 19 August 2014 22:08 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
10080 rows selected.
example 2---8---3

If I want the results that begin with the number 2
in the first position and No. 8
in the fourth position and No. 3 in the
eighth position, and the other positions that are not specified.
Are there the ways to show the results?

please tell me
Yours sincerely,

Navamin-Thailand
navaminroad@hotmail.com

Re: interact command line select to files in this ? [message #621949 is a reply to message #621946] Wed, 20 August 2014 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A simple solution is to use SUBSTR, such as
where substr(col, 1, 1) = '2' 
  and substr(col, 4, 1) = '8'
  and substr(col, 8, 1) = '3'
Re: interact command line select to files in this ? [message #621955 is a reply to message #621949] Wed, 20 August 2014 01:38 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
If you want to use the function in a SQL select statement from SQL*Plus and be able to restrict the results in the select statement, then I would use a pipelined function instead, as demonstrated below.

SCOTT@orcl12c> CREATE OR REPLACE FUNCTION my_func
  2    (p_digits IN VARCHAR2)
  3    RETURN	    SYS.ODCIVARCHAR2LIST PIPELINED
  4  AS
  5  BEGIN
  6    FOR v_rec IN
  7  	 (SELECT  DISTINCT REPLACE (SYS_CONNECT_BY_PATH (digit, '*'), '*', '') digits
  8  	  FROM	  (SELECT  LEVEL i, SUBSTR (p_digits, LEVEL, 1) digit
  9  		   FROM    DUAL
 10  		   CONNECT BY LEVEL <= LENGTH (p_digits))
 11  	  WHERE   LEVEL = LENGTH (p_digits)
 12  	  CONNECT BY NOCYCLE PRIOR i != i
 13  	  ORDER   BY digits)
 14    LOOP
 15  	 PIPE ROW (v_rec.digits);
 16    END LOOP;
 17  END my_func;
 18  /

Function created.

SCOTT@orcl12c> SELECT *
  2  FROM   TABLE (my_func ('12342387'))
  3  WHERE  SUBSTR (COLUMN_VALUE, 1, 1) = '2'
  4  AND    SUBSTR (COLUMN_VALUE, 4, 1) = '8'
  5  AND    SUBSTR (COLUMN_VALUE, 8, 1) = '3'
  6  /

COLUMN_VALUE
--------------------------------------------------------------------------------
21283473
21283743
21284373
21284733
21287343
21287433
21382473
21382743
21384273
21384723
21387243
21387423
21482373
21482733
21483273
21483723
21487233
21487323
21782343
21782433
21783243
21783423
21784233
21784323
22183473
22183743
22184373
22184733
22187343
22187433
22381473
22381743
22384173
22384713
22387143
22387413
22481373
22481733
22483173
22483713
22487133
22487313
22781343
22781433
22783143
22783413
22784133
22784313
23182473
23182743
23184273
23184723
23187243
23187423
23281473
23281743
23284173
23284713
23287143
23287413
23481273
23481723
23482173
23482713
23487123
23487213
23781243
23781423
23782143
23782413
23784123
23784213
24182373
24182733
24183273
24183723
24187233
24187323
24281373
24281733
24283173
24283713
24287133
24287313
24381273
24381723
24382173
24382713
24387123
24387213
24781233
24781323
24782133
24782313
24783123
24783213
27182343
27182433
27183243
27183423
27184233
27184323
27281343
27281433
27283143
27283413
27284133
27284313
27381243
27381423
27382143
27382413
27384123
27384213
27481233
27481323
27482133
27482313
27483123
27483213

120 rows selected.

Re: interact command line select to files in this ? [message #621958 is a reply to message #621955] Wed, 20 August 2014 01:56 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
You could also use regexp_like instead of substr, as shown below.

SCOTT@orcl12c> CREATE OR REPLACE FUNCTION my_func
  2    (p_digits IN VARCHAR2)
  3    RETURN	    SYS.ODCIVARCHAR2LIST PIPELINED
  4  AS
  5  BEGIN
  6    FOR v_rec IN
  7  	 (SELECT  DISTINCT REPLACE (SYS_CONNECT_BY_PATH (digit, '*'), '*', '') digits
  8  	  FROM	  (SELECT  LEVEL i, SUBSTR (p_digits, LEVEL, 1) digit
  9  		   FROM    DUAL
 10  		   CONNECT BY LEVEL <= LENGTH (p_digits))
 11  	  WHERE   LEVEL = LENGTH (p_digits)
 12  	  CONNECT BY NOCYCLE PRIOR i != i
 13  	  ORDER   BY digits)
 14    LOOP
 15  	 PIPE ROW (v_rec.digits);
 16    END LOOP;
 17  END my_func;
 18  /

Function created.

SCOTT@orcl12c> SELECT *
  2  FROM   TABLE (my_func ('12342387'))
  3  WHERE  REGEXP_LIKE (COLUMN_VALUE, '^2\d{2}8\d{3}3\d*')
  4  /

COLUMN_VALUE
--------------------------------------------------------------------------------
21283473
21283743
21284373
21284733
21287343
21287433
21382473
21382743
21384273
21384723
21387243
21387423
21482373
21482733
21483273
21483723
21487233
21487323
21782343
21782433
21783243
21783423
21784233
21784323
22183473
22183743
22184373
22184733
22187343
22187433
22381473
22381743
22384173
22384713
22387143
22387413
22481373
22481733
22483173
22483713
22487133
22487313
22781343
22781433
22783143
22783413
22784133
22784313
23182473
23182743
23184273
23184723
23187243
23187423
23281473
23281743
23284173
23284713
23287143
23287413
23481273
23481723
23482173
23482713
23487123
23487213
23781243
23781423
23782143
23782413
23784123
23784213
24182373
24182733
24183273
24183723
24187233
24187323
24281373
24281733
24283173
24283713
24287133
24287313
24381273
24381723
24382173
24382713
24387123
24387213
24781233
24781323
24782133
24782313
24783123
24783213
27182343
27182433
27183243
27183423
27184233
27184323
27281343
27281433
27283143
27283413
27284133
27284313
27381243
27381423
27382143
27382413
27384123
27384213
27481233
27481323
27482133
27482313
27483123
27483213

120 rows selected.

Re: interact command line select to files in this ? [message #622082 is a reply to message #621958] Wed, 20 August 2014 16:26 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
why not simply

SELECT *
FROM TABLE (my_func ('12342387'))
WHERE column_value like '2__8___3%';
Re: interact command line select to files in this ? [message #622084 is a reply to message #622082] Wed, 20 August 2014 19:41 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Bill B wrote on Wed, 20 August 2014 14:26
why not simply

SELECT *
FROM TABLE (my_func ('12342387'))
WHERE column_value like '2__8___3%';


Sometimes we get so focused on the fancy new methods that we forget about the simple old ones.
Re: interact command line select to files in this ? [message #622085 is a reply to message #622084] Wed, 20 August 2014 22:49 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
If I want to display from 8 columns to display only 5 columns.

example
21283473
21283743
21284373
21284733
21287343
21287433
21382473
21382743
21384273
21384723
... truncated to save space
21387423
21482373
21482733
21483273
21483723
21487233

120 rows selected.

-----------------

I want the results that display

21283
21283
21284
21284
21287
21287
21382
21382
21384
21384
... truncated to save space
21387
21482
21482
21483
21483
21487

120 rows selected.

Are there the ways to show the results?
please tell me
i look forward to hearing from you.
Yours sincerely,

Navamin-Thailand
navaminroad@gmail.com

Re: interact command line select to files in this ? [message #622086 is a reply to message #622085] Wed, 20 August 2014 22:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
consider to actually Read The Fine Manual, before posting here

http://docs.oracle.com/database/121/SQLRF/functions195.htm#SQLRF06114
Re: interact command line select to files in this ? [message #622090 is a reply to message #622085] Thu, 21 August 2014 00:00 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
navaminroad wrote on Thu, 21 August 2014 09:19
If I want to display from 8 columns to display only 5 columns.

example
21283473

I want the results that display

21283


You are confused between digits and columns. Your question should have been, how to get the first 5 digits.
Re: interact command line select to files in this ? [message #622231 is a reply to message #622090] Fri, 22 August 2014 14:52 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Read the link that BlackSwan provided and your problem will be solved.
Re: interact command line select to files in this ? [message #622232 is a reply to message #622231] Fri, 22 August 2014 21:11 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member


How do I Design (Database Management System) (Data Store) (Create Table) to store the Results and will be used in the calculation, search, find out Report?

To Run the Out Put (my_func) came out very long time. How can I Save file or use Temp File.

To insert into the Table A, B, C ... N under such conditions.
Table A collect all the Rows where first position is No. 1.
Table B collect all the Rows where first position is No. 2.
Table C collect all the Rows where first position is No. 3.
... truncated to save space
Table N collect all the Rows where first position is No. 0.
and how to reduce the size of the data.

please tell me.
i look forward to hearing from you.

Yours sincerely,
Thanks with best regards,

Navamin-Thailand.
navaminroad@gmail.com


**********************
Results all the Rows.
16494488379128759841194311665590386511882406836298391400708734708401382919636
46808466148656674590229646503558677146520742916825967268314373975466950565603
55540746705637562240501155776567564785022522219704232111595011221458008894065
76207005305754043815320793873732776711260530318905387139904743632738725295644
839894665068189311105518354942178373831442020424406884197134050000000 rows selected.
**********************

SCOTT@orcl12c> SELECT *
2 FROM TABLE (my_func ('111111111111111111111111111111112222222222222222222222222222222233333333333
33333333333333333333344444444444444444444444444444444555555555555555555555555
55555555666666666666666666666666666666667777777777777777777777777777777788888
88888888888888888888888888899999999999999999999999999999999000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000'))
3 WHERE SUBSTR (COLUMN_VALUE, 1, 1) = '1'
4 /
----------------------
SCOTT@orcl12c> SELECT *
2 FROM TABLE (my_func ('111111111111111111111111111111112222222222222222222222222222222233333333333
33333333333333333333344444444444444444444444444444444555555555555555555555555
55555555666666666666666666666666666666667777777777777777777777777777777788888
88888888888888888888888888899999999999999999999999999999999000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000'))
3 WHERE SUBSTR (COLUMN_VALUE, 1, 1) = '2'
4 /
---------------------------
SCOTT@orcl12c> SELECT *
2 FROM TABLE (my_func ('111111111111111111111111111111112222222222222222222222222222222233333333333
33333333333333333333344444444444444444444444444444444555555555555555555555555
55555555666666666666666666666666666666667777777777777777777777777777777788888
88888888888888888888888888899999999999999999999999999999999000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000'))
3 WHERE SUBSTR (COLUMN_VALUE, 1, 1) = '3'
4 /
--------------------
... truncated to save space
---------------------
SCOTT@orcl12c> SELECT *
2 FROM TABLE (my_func ('111111111111111111111111111111112222222222222222222222222222222233333333333
33333333333333333333344444444444444444444444444444444555555555555555555555555
55555555666666666666666666666666666666667777777777777777777777777777777788888
88888888888888888888888888899999999999999999999999999999999000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000'))
3 WHERE SUBSTR (COLUMN_VALUE, 1, 1) = '0'
4 /
----------------------------
Re: interact command line select to files in this ? [message #622233 is a reply to message #622232] Fri, 22 August 2014 21:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/
Re: interact command line select to files in this ? [message #622234 is a reply to message #622232] Fri, 22 August 2014 23:50 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
If you want to save the results to files, then you can use SPOOL.

If you want to save the results to tables, then you can use:

CREATE TABLE AS SELECT ...

You can find information about both in the online Oracle documentation.

Re: interact command line select to files in this ? [message #622242 is a reply to message #622084] Sat, 23 August 2014 08:36 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
Barbara Boehmer wrote on Wed, 20 August 2014 20:41
Sometimes we get so focused on the fancy new methods that we forget about the simple old ones.


In this particular case - we are looking for string that starts with certain character - it is not just "simple old one" but is also more efficient one since it supports index range scan, assuming column is indexed.

SY.
Re: interact command line select to files in this ? [message #622492 is a reply to message #621835] Wed, 27 August 2014 02:07 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
How do I know when I Run command functions and the computer processing which only while it is working.
Because it takes a long time.

(my_func ('11111111111111111111111111111111222222222222222222222222222222223333333333333333333333333333333344444444444444444444444444444444555 5555555555555555555555555555566666666666666666666666666666666777777777777777777777777777777778888888888888888888888888888888899999999 9999999999999999999999990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000'))


please tell me
i look forward to hearing from you.

Yours sincerely,

Navamin-Thailand

navaminroad@hotmail.com
Re: interact command line select to files in this ? [message #622495 is a reply to message #622492] Wed, 27 August 2014 02:57 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
There were two other methods also mentioned :

LF suggested,

SQL> WITH data
  2       AS (SELECT '122333444455555' COL
  3           FROM   dual)
  4  SELECT col
  5  FROM   data
  6  WHERE  Substr(col, 1, 1) = '1'
  7         AND Substr(col, 2, 1) = '2'
  8         AND Substr(col, 4, 1) = '3'
  9         AND Substr(col, 7, 1) = '4';

COL
---------------
122333444455555


Bill suggested,

SQL> WITH data
  2       AS (SELECT '122333444455555' COL
  3           FROM   dual)
  4  SELECT col
  5  FROM   data
  6  WHERE  col LIKE '12_3__4%';

COL
---------------
122333444455555


I would go with Bill's suggestion considering the performance point of view as SY already explained.

Regards,
Lalit
Re: interact command line select to files in this ? [message #622804 is a reply to message #622495] Fri, 29 August 2014 22:30 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
I want the results only the first position to the

fith 5 position to do ?
And each row is unique.
Do not show all 8 position.

For example.

COLUMN_VALUE
--------------
21283473
21283743
21284373
21284733
21287343
21287433
21382473
21382743
21384273
21384723
21387243
21387423
21482373
21482733
21483273
21483723
21487233

17 rows selected.
--------------
I Need Preview

21283
21284
21287
21382
21384
21387
21482
21483
21487

9 rows selected.
-------------

please tell me
i look forward to hearing from you.

Yours sincerely,

Navamin-Thailand

navaminroad@gmail.com
Re: interact command line select to files in this ? [message #622805 is a reply to message #622804] Fri, 29 August 2014 23:41 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Now it is time that you show us what you tried. There are so many ways already shown to you.

Hint : substr(col,1,5) and then distinct
Re: interact command line select to files in this ? [message #622807 is a reply to message #622805] Sat, 30 August 2014 05:39 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
Will give GPU processing needs to be done to it.
Because CPU processing for a long time.
Re: interact command line select to files in this ? [message #622808 is a reply to message #622807] Sat, 30 August 2014 06:24 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
navaminroad wrote on Sat, 30 August 2014 16:09
Will give GPU processing needs to be done to it.
Because CPU processing for a long time.


Sorry, I don't understand. Are you trying to say that you are facing performance issue?

Edit : Show what you did. I re-read your previous post about the query running too long. Can you post the execution plan for the above query using substr. Also, in sqlplus, set time on timing on; and then execute the query and post the results using copy paste. You might need to remove the entire resultset.

[Updated on: Sat, 30 August 2014 08:39]

Report message to a moderator

Re: interact command line select to files in this ? [message #622814 is a reply to message #622808] Sat, 30 August 2014 22:56 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
Oracle - generating combination of numbers

I have been trying to covert my generating combination of numbers of SQL Plus Oracle into Cuda generating combination of numbers program
It is used by CUDA routine in order to perform calculations based on the GPU to GPU where available lol for parallel processing (Parallel Processing) to process the data are very large.

"Compute Unified Device Architecture"
GPU ( Graphic Processing Units )

Yours sincerely,
Thanks with best regards,
Re: interact command line select to files in this ? [message #622815 is a reply to message #622814] Sat, 30 August 2014 23:24 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
/forum/fa/12132/0/
Re: interact command line select to files in this ? [message #622816 is a reply to message #622815] Sat, 30 August 2014 23:25 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
/forum/fa/12133/0/
Re: interact command line select to files in this ? [message #622819 is a reply to message #622816] Sun, 31 August 2014 02:42 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
I have no idea what your intentions are with above three posts. This discussion is now going directionless. Your original topic(which I still don't understand) was releated to finding values based on the position of the digits. Then you asked how to get only the first 5 digits, to which you didn't feedback. Now you talk about "CUDA", which I don't understand how is it related to Oracle. This is my opinion.
Re: interact command line select to files in this ? [message #622941 is a reply to message #622819] Tue, 02 September 2014 06:16 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
Dear Lalit Kumar B,

I have an intense number crunching application which I need converted into

CUDA to maximize speed. I will also need you to add a couple of features to

the program. I need someone with years of CUDA experience.

please tell me.
i look forward to hearing from you.

Yours sincerely,
Thanks with best regards,

Navamin-Thailand.
navaminroad@gmail.com
Re: interact command line select to files in this ? [message #622943 is a reply to message #622941] Tue, 02 September 2014 06:27 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
navaminroad wrote on Tue, 02 September 2014 16:46
Dear Lalit Kumar B,

I have an intense number crunching application which I need converted into

CUDA to maximize speed. I will also need you to add a couple of features to

the program. I need someone with years of CUDA experience.


Sorry, but I can't help you with this "CUDA". This is an "Oracle" forum. You need to post in some "CUDA" forum.
Re: interact command line select to files in this ? [message #623064 is a reply to message #622943] Wed, 03 September 2014 23:26 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
Dear Lalit Kumar B,

I will solve the problem?

I can not. Compile Generating Combination of Numbers From (Source code FUNCTION my_func.) Because came out very long time and Big Data.
Please help me.

Yours sincerely,
Thanks with best regards,

Navamin-Thailand.
Re: interact command line select to files in this ? [message #623223 is a reply to message #623064] Sat, 06 September 2014 06:37 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
navaminroad wrote on Thu, 04 September 2014 00:26
Because came out very long time and Big Data.


You asked for assistance with generation of digit permutations for
'111111111111111111111111111111112222222222222222222222222222222233333333333
33333333333333333333344444444444444444444444444444444555555555555555555555555
55555555666666666666666666666666666666667777777777777777777777777777777788888
88888888888888888888888888899999999999999999999999999999999000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000'

This is 416 digit number. Do you know that number of permutations for N of N is N! (N factorial)? And do you realize what 416! is?
It is 1 * 2 * 3 * 4 *... * 416 which is infinity for all computers, well maybe except some supercomputers.

SY.

[Updated on: Sat, 06 September 2014 06:39]

Report message to a moderator

Re: interact command line select to files in this ? [message #623227 is a reply to message #623223] Sat, 06 September 2014 11:11 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Good point SY. And apart from the permutations, there will more load when Oracle would interact with the 3rd party program/software. In OP's case, the software is CUDA, I don't know what is it at all.
Re: interact command line select to files in this ? [message #623621 is a reply to message #623227] Fri, 12 September 2014 00:06 Go to previous messageGo to next message
navaminroad
Messages: 15
Registered: August 2014
Location: Thai
Junior Member
What can I do to make the program. (Source code FUNCTION my_func.) As multi-threading (parallel programming)

Yours sincerely,
Thanks with best regards,

Navamin-Thailand.
Re: interact command line select to files in this ? [message #623662 is a reply to message #623621] Fri, 12 September 2014 06:50 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
navaminroad wrote on Fri, 12 September 2014 01:06
What can I do to make the program. (Source code FUNCTION my_func.) As multi-threading (parallel programming)


It looks like you didn't get it. So I'll repeat again. Number of permutaions for 416 digit number is 416!. And 416! is 3846313387719957490284353898010600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000. How many parallel threads your computer can handle?

SY.
Re: interact command line select to files in this ? [message #623667 is a reply to message #623621] Fri, 12 September 2014 07:37 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
navaminroad wrote on Fri, 12 September 2014 00:06
What can I do to make the program. (Source code FUNCTION my_func.) As multi-threading (parallel programming)

Yours sincerely,
Thanks with best regards,

Navamin-Thailand.



http://ldworen.net/fun/osvu.html
Previous Topic: join query
Next Topic: Count employees for a department
Goto Forum:
  


Current Time: Fri Mar 29 02:19:51 CDT 2024