Hi,
I am new in pl/sql programming and I need your help.

I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1

================================================
|COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7|

|600 | 140 | 2 | 10 | 1300 | 500 | 1 |

|600 | 140 | 2 | 20 | 1400 | 340 | 4 |

|600 | 140 | 2 | 15 | 1400 | 230 | 3 |

|600 | 140 | 2 | 35 | 1700 | 120 | 2 |

|600 | 150 | 3 | 10 | 1300 | 166 | 6 |

|600 | 150 | 3 | 15 | 1400 | 435 | 5 |

For the same COL1 and COL2/COL3 , check the select different values from COL4
For instance for COL1=600 , COL2=140/COL3=2 and COL2=150/COL3=3
Return 20 and 35

And insert in this table TABLE1 the rows
600 , 150 , 3, 20 , 1400 , 340, 7 (seq number)
600 , 150 , 3, 35 , 1700 , 120, 8 (seq number)

I make inserts in Table1 if P_FLG1 = 'Y'. IF P_FLG2 = 'Y' I make inserts also in TABLE3 etc

I am trying to make the procedure like below but I can't finish it

PROCEDURE COPY_COLUMNS  ( P_COL1        IN  A.COL1%TYPE,
                          P_FROM_COL2   IN  B.COL2%TYPE,
                          P_FROM_COL3   IN  B.COL3%TYPE,
                          P_TO_COL2     IN  B.COL2%TYPE,
                          P_TO_COL3     IN  B.COL3%TYPE,
                          P_FLG1        IN  VARCHAR2,
                          P_FLG2 ...

Thanks for your answer but How can I run this ?
And what is the meaning of command

return system("perl summarize.pl");

Hi all,
I would like to make program reading 300 lines form a file with 24 columns.
the 24th column has an integer from 1 to 24, while the others columns are strings.

I want to summarize in seperate files this (last) column

For example,
assdsd, sdsds, asdasda, asda ,asdad, asdsad, ...., 1
hfghhghghghg,ghgh,gh,gh,g,hg,hg,h,gh,g,hg,hg, ... ,2
rtrtrtr ,rt r,t r, t,r,t r,t ,r t,r ,t ,r , r,t r,.... ,1

File1.txt
assdsd, sdsds, asdasda, asda ,asdad, asdsad, ...., 1
rtrtrtr ,rt r,t r, t,r,t r,t ,r t,r ,t ,r , r,t r,.... ,1

File2.txt
hfghhghghghg,ghgh,gh,gh,g,hg,hg,h,gh,g,hg,hg, ... ,2

Could you help me do it please ??

Hi all,
I have to make a project on my School until 18th of May.

I am using resEdit to make graphics for a c++ program. But there ara a lot of cases that the program crashes.

Could you help me ?

I don't know to use resEdit good so ..

Please if you have time, send me a private message

Hi,
I would like to do a presentation with a flipping page book.
I am searching the Web but I can't find a freeware.

Does everybody know one to help me ?

I don't know flash programming

Hi,
I have a problem with an xml file.
I am trying to develop an xml file based on vra core 4.0 but when I check if my code is valid I take
the following error.

Could not open file: http://www.vraweb.org/projects/vracore4/vra-4.0-restricted.xsd
(I use XML COPY EDITOR)

A part of my code is :

<?xml version="1.0" encoding="UTF-8" ?>
<vra xmlns="http://www.vraweb.org/vracore4.htm"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.vraweb.org/vracore4.htm 
http://www.vraweb.org/projects/vracore4/vra-4.0-restricted.xsd">
.........
</vra>

Thanks in advance

[QUOTE=NormR1;1587842]First comment is that most of the Thread methods used in your code are deprecated.
You should look at using the Timer class.

What code is supposed to start the timer again? Where/when is it called?[/QUOTE]

Ok thanks a lot for your help,
I did not know that exists Timer class already.

[QUOTE=NormR1;1587829]Are you having problems? Can you explain what the problem is?

Look at using a Timer vs writing your own using Thread.

Also its better NOT to use one of the standard Java class names for your class.[/QUOTE]

The problem I have is that when I click on stop and press again the button the counter increases a sec. And then increases only when I press button

Hi, I am trying to make a timer applet when I click stop button to stop counting, disappear stop and appears continue button and when I click continue to continue the counting.

My code is :

[CODE]
import java.applet.;
import java.awt.
;
import javax.swing.*;

public class Timer extends Applet implements Runnable
{
private String msg2 = new String("");
private int secs;
private int mins;
private int hrs;
private Thread clock;
public int time =300000;
Button clickOnMe;

 public void destroy()
 {
     clock.stop();
 }

 public void init()
 {
         clickOnMe = new Button("Stop!");
         add(clickOnMe);

         String parameter;

         if(clock == null)
         {
           clock = new Thread(this);
            clock.start();
         }
 }

 public void paint(Graphics gr)
     {
     ++secs;
     if(secs == 60)
         {
         mins++;
         secs = 0;
     }
     if(mins == 60)
         {
         hrs++;
         secs = 0;
         mins = 0;
     }
     gr.drawString(" "+ hrs + ":" + mins + ":" + secs, 10, 130);
     gr.drawString(msg2,10,150);
     setBackground(Color.white);
 }

 public void run()
     {
         while(true)
         {
         repaint();
         try
             {
             clock.sleep(1000);
         }
         catch(InterruptedException e)
             {}
     }
 }

 public void start()
     {
     clock.resume();
 }

 public void stop()
     {
     clock.suspend();
 }

 public boolean action (Event e, Object args)
 { 
   if (e.target == clickOnMe)
      stop();
   repaint();

   return true;

}

}
[/CODE]

Hi,
I am trying to make a program which reads 6 integers , insert into a file numbers1.txt
then copy numbers1.txt content to numbers2.txt and finally print numbers2.

The problem I have is that when I am trying to copy the file to another the system crashes.

My code is
[CODE]

include <stdio.h>

include <stdlib.h>

int main()
{
int array[6];
int i;
char ch;
FILE fp1,fp2;

printf("Give 6 numbers :\n");
for(i=0;i<6;i++)
scanf("%d",&array[i]);

fp1=fopen("numbers1.txt", "wb");

for(i=0; i<6;i++)
fprintf(fp1, "%d\n",array[i]);

fp2=fopen("numbers2.txt","wb");

while(!feof(fp1))
{
ch = fgetc(fp1);

if(!feof(fp1)) 
    fputc(ch, fp2);

}

fclose(fp1);
fclose(fp2);

system("pause");
return 0;

}
[/CODE]

Could you help me ?
Thanks a lot

Thanks a lot both

Hi,
I have a php array as the following format
array([4]=>6 [8]=>12 [3]=>5)
and I would like to add 6+12+5

The problem I have is that neither number of array cells nor array_keys are known.

Thanks a lot

Hi all,
I am trying to install jcart shopping cart but I have some problems when I am trying to modify it.
[URL="

thanks a lot for your answer

Hi all,
I am trying two days now to insert a cart link on my page. It is a e-shop bookstore.
I save my books in a database :
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| bookid | int(11) | NO | PRI | NULL | auto_increment |
| title | varchar(200) | NO | | NULL | |
| author | varchar(100) | NO | | NULL | |
| publisher | varchar(100) | NO | | NULL | |
| catid | int(11) | NO | | NULL | |
| cost | float | NO | | NULL | |
| isbn | varchar(10) | NO | | NULL | |
| description | text | NO | | NULL | |
| weight | int(5) | YES | | NULL | |
| nopages | int(4) | YES | | NULL | |
| imagename | varchar(100) | NO | | NULL | |
| sales | int(5) | NO | | NULL | |
+-------------+--------------+------+-----+---------+----------------+

And I have a detail page for book with a link "order".
When a user clicks on order then cart.php page opens.

The link order is ::
[CODE] echo '<a href="cart.php?action=add&id='.$isbn.'" class="more"><img src="images/order_now.gif" alt="" title="" border="0" /></a>';[/CODE]

While the cart.php is ::
[CODE]
<?php

include_once('header.php');

function writeShoppingCart()
{
$cart = $_SESSION['cart'];
if (!$cart) {
return '<p>You have no items in your shopping cart</p>';
} else {
// Parse the cart session ...

Thank you very much for your help.
It is exact what I want!

Thanks again

Hi all,
I don't know css and I would like your help.
I am trying to make an online bookstore.

The problem I have with divs is that when I am trying to make a new
all the below divs are moved down.

I would like to add welcome guest and register|login link in the position as image ideal.bmp sees.

Could you help me please ???

Thanks a lot

Hi all,
I have a file .c and I would like to format the comments of file like that :
/*
Comment
/

with a sed script

The comments in my file is
/ comment 1 /

/
comment 2
/

/* comment 3
/

I know to format file with diferrent commands
like sed -e 's/\/*+/\/**\n/g' filename
...
but there are empty lines between /** and comments

is it possible to become with only one regular expression ?

Thanks a lot

thanks a lot

[QUOTE=bufospro;1516580]Hi,
I use a command with awk in bash shell so as to extract info from a file.

[CODE]awk -F'[=,: ]' '{print /uid=/?$4:(/^telephoneN/)?$2:$3}' 1.txt[/CODE]

the output is something like
aaaa
bbbb
cccc
dddd

eeee
ffff
gggg
tttt

I would like to write this output in a file 2.xml
[CODE]<xml>
<name>aaaa</name>
<surname>bbbb</surname>
...
</xml>
<xml>
<name>eeee</name>
<surname>ffff</surname>
...
</xml>
[/CODE]

could you help me do it please ?

thanks a lot in advance[/QUOTE]

Somebody please ?

Hi,
I use a command with awk in bash shell so as to extract info from a file.

[CODE]awk -F'[=,: ]' '{print /uid=/?$4:(/^telephoneN/)?$2:$3}' 1.txt[/CODE]

the output is something like
aaaa
bbbb
cccc
dddd

eeee
ffff
gggg
tttt

I would like to write this output in a file 2.xml
[CODE]<xml>
<name>aaaa</name>
<surname>bbbb</surname>
...
</xml>
<xml>
<name>eeee</name>
<surname>ffff</surname>
...
</xml>
[/CODE]

could you help me do it please ?

thanks a lot in advance

[QUOTE=bufospro;1504112]Thanks a lot

I try for the other question something like that
find . -maxdepth 1 -type d -name './[dgDG]*'

but it doesn't work. :([/QUOTE]

OK I found it thanks a lot

Thanks a lot

I try for the other question something like that
find . -maxdepth 1 -type d -name './[dgDG]*'

but it doesn't work. :(

Hi all, I am new in shell scripting and I need your help

  1. I would like to make a list of files (no folders) of unix system which do not belong to root

  2. I would like to make a list with directories of system which the first letter is d or g.

=========
I know how can I list files or directories but unfortunately I don't know to do the above

ls -l | grep ^d list the directories

ls -l |grep ^- list files

Could you help me please ?

[QUOTE=jonsca;1464299]Check out Emergent [url]http://grey.colorado.edu/emergent/index.php/Main_Page[/url]. It's got a bit of a learning curve, but in return for it you get a very powerful tool. I haven't used it recently, so I'm not sure how much help I could be with it.

This one [url]http://www.justnn.com/[/url] is more straightforward.[/QUOTE]

Thanks a lot for your answer
I found also AI Solver Studio

Hi, I am new in neural networks and I would like
to tell me a program that I can simulate networks (except Matlab).

I have a train.txt and a test.txt file and I would like to make a multilayer perceptron
with back propagation.

Thanks a lot

Hi all,
I have a project in clips (fuzzy) and I would like to ask you something.

I use a template (A and B are defined with low, normal, high):
(deftemplate fuz
(slot FA (type FUZZY-VALUE A))
(slot FB (type FUZZY-VALUE B))
)

then I initialise the variables
(assert (fuz
(FA (pi 0 ?a))
(FB (pi 0 ?b))
)
)

And I am writing a rule
(defrule aaaaa
(declare (salience 430))
(fuz (FA ?c))
=>
(printout t "" ?c "")
)

But the output is '???'

How can I print low, high, normal ?

And last question can I pause the program with a command ?

[QUOTE=vijayan121;1438292]You need to read lines (not individual strings) from the file. Use [b]std::getline()[/b] for that.
[icode]std::string someName ;
while( std::getline( infile, someName ) )
name_vec.push_back(someName);
[/icode]

See: [url]http://www.arachnoid.com/cpptutor/student2.html[/url]

Then use std::random_suffle() to randomly shuffle the contents of the vector.
See: [url]http://stdcxx.apache.org/doc/stdlibref/random-shuffle.html[/url]

Do not forget to seed the random number generator in main.
See: [url]http://www.richelbilderbeek.nl/CppSrand.htm[/url][/QUOTE]

Thanks a lot

[QUOTE=vijayan121;1438197][Font=large][b]Simple Random Selection Without Replacement From a Finite Population[/b][/Font]
[icode]1. Let [b]P[/b] be the fraction of lines to be written into the first file ( [b]P[/b] == 0.63 => 63% )

  1. Read all the 300 or so lines from the input file into a [b]std::vector< std::string >[/b]

  2. Let [b]N[/b] be the size of the vector (number of lines read)

  3. Shuffle the contents of the vector using [b]std::random_shuffle()[/b]

  4. Let [b]M[/b] be [b]P * N[/b] rounded to the nearest integer

  5. Write the first [b]M[/b] lines into the first output file.

  6. Write the remaining [b]N-M[/b] lines into the second output file.
    [/icode][/QUOTE]

I found the N and read all the lines but I don't understand how to do the others
:(

[CODE]

include <iostream>

include <fstream>

include <string>

include <vector>

include <cstdlib>

using namespace std;

void readFile(vector<string>& name_vec, string name_file);

int main()
{
float p;
int len;

   vector<string> lines;
   ifstream readLines;

   cout << "Fraction : ";
   cin >> p;

   readFile(lines, "in.txt");
   len = lines.size();

   ofstream outfile1("1.txt");
   ofstream outfile2("2.txt");

   if (!outfile1) {
    cerr << "Unable to write "  << endl;
    exit(1);
  }

  if (!outfile2) {
    cerr << "Unable to write "  << endl;
    exit(1);
  }

  cout <<"No Lines: "<< len << endl;

  cout<< lines[rand()];

   system("pause");
   return 0;

}

void readFile(vector<string>& name_vec, string name_file)
{
ifstream infile;
infile.open(name_file.c_str());
if (!infile) {
cerr << "Unable to read " << name_file << endl;
exit(1);
}
for (string someName; infile >> someName; ) {
name_vec.push_back(someName);
}
infile.close();
}

[/CODE]

Hi all,
I have a file with data 300 lines. (in.txt)

I want to make a program that seperates the file in two others (out1.txt, out2.txt).
But I would like to do it with percentage.

For example,
Percentage (%): 50

and seperate the in.txt file in the middle but with random lines from the file.

A line that is in the out1.txt there is no in out2.txt

Could you help me please ?