Question: ```
    <?xml version="1.0" encoding="utf-8"?>
       <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
        android:layout_width="fill_parent"
        android:layout_height="fill_parent"
        android:orientation="vertical" >

       <TextView
         android:id="@+id/textView1"
         android:layout_width="wrap_content"
         android:layout_height="wrap_content"
         android:text="EN LEZİZ KISIR TARİFİ BURADA"
         android:textAppearance="?android:attr/textAppearanceLarge" />

     <ImageView
         android:id="@+id/imageView1"
         android:layout_width="wrap_content"
         android:layout_height="wrap_content"
         android:src="@drawable/kisir" />

     <Button
        android:id="@+id/button1"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/malzemeler" />

     <Button
       android:id="@+id/button2"
       android:layout_width="fill_parent"
       android:layout_height="wrap_content"
       android:text="@string/hazirlanisi" />

    <ScrollView
        android:id="@+id/scrollView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:fillViewport="true" >

         <TextView 
            android:id="@+id/textView2"
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:singleLine="false"
            android:text="@string/secenek" />

     </ScrollView>

  </LinearLayout>

```

When i click the button i want to be able to use the scrollView to be able to read the rest of the text and i kept text long in string values but i couldn't create scrollView. Where am i doing wrong? Thx.

Answer: 
Would something like the following help?

```
BEGIN
  FOR source_row IN (SELECT rule FROM some_table)
  LOOP
    INSERT INTO some_other_table (rule_match)
      WITH numbers AS (SELECT LPAD(LEVEL - 1, 4, '0') AS num FROM DUAL CONNECT BY LEVEL <= 10000)
      SELECT num FROM numbers WHERE num LIKE REPLACE(source_row.rule, '?', '_');
  END LOOP;
END;
/

```

This assumes you have a table called `some_table` with a column `rule`, which contains text such as `??01`, `0??1` and `????`. It inserts into `some_other_table` all numbers from 0000 to 9999 that match these wild-carded patterns.

The subquery 

```
SELECT LPAD(LEVEL - 1, 4, '0') AS num FROM DUAL CONNECT BY LEVEL <= 10000)

```

generates all numbers in the range `0000` to `9999`. We then filter out from this list of numbers any that match this pattern, using `LIKE`. Note that `_` is the single-character wildcard when using `LIKE`, not `?`. 

I set this up with the following data:

```
CREATE TABLE some_table (rule VARCHAR2(4));

INSERT INTO some_table (rule) VALUES ('??01');
INSERT INTO some_table (rule) VALUES ('0??1');
INSERT INTO some_table (rule) VALUES ('????');
COMMIT;

CREATE TABLE some_other_table (rule_match VARCHAR2(4));

```

After running the above PL/SQL block, the table `some_other_table` had 10200 rows in it, all the numbers that matched all three of the patterns given.
Replace \* to %, ? to \_ and use **LIKE** clause with resulting values.