if (!Debugger.IsAttached) Debugger.Break();
* This source code was highlighted with Source Code Highlighter.If Not Debugger.IsAttached Then
Debugger.Break()
End If
* This source code was highlighted with Source Code Highlighter.
- DECLARE
- table_ts_name VARCHAR2 (30) := 'USER_DATA'; –- табличное пространство для перемещения таблиц
- index_ts_name VARCHAR2 (30) := 'USER_INDEX'; –- табличное пространство для перемещения индексов
- varUser VARCHAR2(30) := 'HR'; – схема объекты которой необходимо переместить
- BEGIN
- FOR obj
- IN ( -- перемещение таблиц содержащих поля LOB типов
- SELECT 'alter table '||owner||'.'|| table_name||' move lob('|| column_name
- ||') store as (tablespace '|| table_ts_name move_sql
- FROM dba_tab_cols
- WHERE owner=varUser and data_type='%LOB'
- UNION ALL
- -- перемещение остальных таблиц
- SELECT 'alter table '||t1.owner|| '.'||t1.object_name||' move tablespace '||table_ts_name move_sql
- FROM all_objects t1
- WHERE t1.owner=varUser
- AND t1.object_type = 'TABLE'
- AND t1.temporary = 'N'
- AND NOT EXISTS (
- SELECT 1 from dba_tab_cols t2
- where t1.owner = t2.owner
- AND t1.object_name = t2.table_name
- AND t2.data_type = 'LONG'
- AND t2.data_type = 'LONG RAW')
- UNION ALL
- -- перемещение и ребилд индексов, за исключением IOT индексов
- SELECT 'alter index '||owner||'.'|| index_name|| ' rebuild tablespace '|| index_ts_name move_sql
- FROM all_indexes
- WHERE owner=varUser AND index_type <> 'IOT - TOP')
- LOOP
- dbms_output.put_line(obj.move_sql);
- EXECUTE IMMEDIATE obj.move_sql;
- END LOOP;
- END;
* This source code was highlighted with Source Code Highlighter. DateTime dt = DateTime.Now;
Trace.WriteLine("ToString() - " + dt.ToString());
Trace.WriteLine("dd/MM/yyyy HH:mm - " + dt.ToString("dd/MM/yyyy HH:mm"));
Trace.WriteLine("dd[MM[yyyy HH^mm - " + dt.ToString("dd[MM[yyyy HH^mm"));
Trace.WriteLine(@"dd\/MM\/yyyy HH:mm - " + dt.ToString(@"dd\/MM\/yyyy HH:mm"));
Trace.WriteLine("System.Globalization.DateTimeFormatInfo.CurrentInfo.DateSeparator - " +
System.Globalization.DateTimeFormatInfo.CurrentInfo.DateSeparator);
* This source code was highlighted with Source Code Highlighter.namespace SRM438
{
public class UnluckyNumbers
{
public int getCount(int[] luckySet, int n)
{
Array.Sort(luckySet);
int result = 0;
for (int i = 0; i < luckySet.Length - 1; i++)
{
if (luckySet[i] < n & luckySet[i + 1] > n)
{
if (luckySet[i + 1] - 1 - luckySet[i] + 1 > 1)
{
result += (luckySet[i + 1] - n) * (n - luckySet[i]) - 1;
}
}
}
return result;
}
}
}
* This source code was highlighted with Source Code Highlighter.[TestFixture]
public class UnluckyNumbersTests
{
[TestCase(new int[] { 1, 7, 14, 10 }, 2,4)]
[TestCase(new int[] { 4, 8, 13, 24, 30 }, 10,5)]
[TestCase(new int[] { 10, 20, 30, 40, 50 }, 30,0)]
[TestCase(new int[] { 3, 7, 12, 18, 25, 100, 33, 1000 }, 59,1065)]
public void getCountTest(int[] luckySet, int n, int expectedResult)
{
UnluckyNumbers unluckyNumbers = new UnluckyNumbers();
int result = unluckyNumbers.getCount(luckySet, n);
Assert.AreEqual(expectedResult, result);
}
}
* This source code was highlighted with Source Code Highlighter.namespace SRM438
{
public class UnluckyNumbers
{
public int getCount(int[] luckySet, int n)
{
Array.Sort(luckySet);
int result = 0;
for (int i = 0; i < luckySet.Length - 1; i++)
{
if (luckySet[i] < n & luckySet[i + 1] > n)
{
if (luckySet[i + 1] - 1 - luckySet[i] + 1 > 1)
{
result += (luckySet[i + 1] - n) * (n - luckySet[i]) - 1;
}
}
}
return result;
}
}
}
* This source code was highlighted with Source Code Highlighter.[TestFixture]
public class UnluckyNumbersTests
{
[TestCase(new int[] { 1, 7, 14, 10 }, 2,4)]
[TestCase(new int[] { 4, 8, 13, 24, 30 }, 10,5)]
[TestCase(new int[] { 10, 20, 30, 40, 50 }, 30,0)]
[TestCase(new int[] { 3, 7, 12, 18, 25, 100, 33, 1000 }, 59,1065)]
public void getCountTest(int[] luckySet, int n, int expectedResult)
{
UnluckyNumbers unluckyNumbers = new UnluckyNumbers();
int result = unluckyNumbers.getCount(luckySet, n);
Assert.AreEqual(expectedResult, result);
}
}
* This source code was highlighted with Source Code Highlighter.