Code Tester for Oracle Forum - Toad for Oracle - Toad World
gene.l.bradley
Follow / 23 May 2017 at 9:39pm / Toad for Oracle

Re: [Code Tester for Oracle - Discussion Forum] How to declare local...

Expand content
Run the script with (F5) On Tue, May 23, 2017 at 3:10 PM, haifaG < bounce-haifaG@toadworld.com > wrote: How to declare local and global variables and execute a script with toad Thread...
Run the script with (F5)

On Tue, May 23, 2017 at 3:10 PM, haifaG <bounce-haifaG@toadworld.com> wrote:
Thread created by haifaG

Good evening everybody, I'm a new toad's user. Actually I'm doing a BI solution for commercial activity of a company.

I already construct my datawarehouse with 3dimensions (customers, products and structure) now all I have to do is to add a dimension for date to make my events organised and to add a calendar in my qlikview sheets. I started with creating a table DIMTIME :

CREATE TABLE DimDate

(DateKey NUMBER(10) primary key, Datt date, FullDateTN CHAR(10), DayOfMonth VARCHAR2(2), DaySuffix VARCHAR2(4), DayName VARCHAR2(9),  DayOfWeekTN CHAR(1), DayOfWeekInMonth VARCHAR2(3), DayOfWeekInYear VARCHAR2(2), DayOfQuarter VARCHAR2(3), DayOfYear VARCHAR2(3), WeekOfMonth VARCHAR2(1), WeekOfQuarter VARCHAR2(2), WeekOfYear VARCHAR2(2), Month VARCHAR2(2), MonthName VARCHAR2(9), MonthOfQuarter VARCHAR2(2), Quarter CHAR(1), QuarterName VARCHAR2(9), Year CHAR(4), YearName CHAR(7), MonthYear CHAR(10), MMYYYY CHAR(6), FirstDayOfMonth DATE, LastDayOfMonth DATE,

FirstDayOfQuarter DATE,

LastDayOfQuarter DATE,

FirstDayOfYear DATE,

LastDayOfYear DATE,

IsHolidayTN NUMBER(1),

IsWeekday NUMBER(1),

HolidayTN VARCHAR2(50));

Now I have to declare a new local variable and table to generate my table

My boss said that he wants the years in the calendar generated automatically, I found this script in t-sql (to populate my time dimension) I already converted it to plsql but when I execute it on toad it didn't stop showing errors messages:

--Specify Start Date and End date here

--Value of Start Date Must be Less than Your End Date

v_StartDate TIMESTAMP(3) := '01/01/2013' --Starting value of Date Range

v_EndDate TIMESTAMP(3) := '01/01/2015' --End Value of Date Range

--Temporary Variables To Hold the Values During Processing of Each Date of Year

v_DayOfWeekInMonth NUMBER(10);

v_DayOfWeekInYear NUMBER(10);

v_DayOfQuarter NUMBER(10);

v_WeekOfMonth NUMBER(10);

v_CurrentYear NUMBER(10);

v_CurrentMonth NUMBER(10);

v_CurrentQuarter NUMBER(10)

/*Table Data type to store the day of week count for the month and year*/

DECLARE @DayOfWeek TABLE (DOW NUMBER(10), MonthCount NUMBER(10), QuarterCount NUMBER(10), YearCount NUMBER(10))

INSERT INTO @DayOfWeek VALUES (1, 0, 0, 0)

INSERT INTO @DayOfWeek VALUES (2, 0, 0, 0)

INSERT INTO @DayOfWeek VALUES (3, 0, 0, 0)

INSERT INTO @DayOfWeek VALUES (4, 0, 0, 0)

INSERT INTO @DayOfWeek VALUES (5, 0, 0, 0)

INSERT INTO @DayOfWeek VALUES (6, 0, 0, 0)

INSERT INTO @DayOfWeek VALUES (7, 0, 0, 0)

--Extract and assign various parts of Values from Current Date to Variable

v_CurrentDate TIMESTAMP(3) := v_StartDate

v_CurrentMonth := TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM'))

v_CurrentYear := TO_NUMBER(TO_CHAR(v_CurrentDate, 'YY'))

v_CurrentQuarter := TO_NUMBER(TO_CHAR(v_CurrentDate, 'QQ'))

/********************************************************************************************/

--Proceed only if Start Date(Current date ) is less than End date you specified above

WHILE v_CurrentDate < v_EndDate

LOOP

/*Begin day of week logic*/

        /*Check for Change in Month of the Current date if Month changed then

         Change variable value*/

IF v_CurrentMonth != TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM'))

THEN

UPDATE @DayOfWeek

SET MonthCount = 0

v_CurrentMonth := TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM'));

END IF;

       /* Check for Change in Quarter of the Current date if Quarter changed then change

        Variable value*/

IF v_CurrentQuarter != TO_NUMBER(TO_CHAR(v_CurrentDate, 'QQ'))

THEN

UPDATE @DayOfWeek

SET QuarterCount = 0

v_CurrentQuarter := TO_NUMBER(TO_CHAR(v_CurrentDate, 'QQ'));

END IF;

       /* Check for Change in Year of the Current date if Year changed then change

        Variable value*/

IF v_CurrentYear != TO_NUMBER(TO_CHAR(v_CurrentDate, 'YY'))

THEN

UPDATE @DayOfWeek

SET YearCount = 0

v_CurrentYear := TO_NUMBER(TO_CHAR(v_CurrentDate, 'YY'));

END IF;

       -- Set values in table data type created above from variables

UPDATE @DayOfWeek

SET

MonthCount = MonthCount + 1,

QuarterCount = QuarterCount + 1,

YearCount = YearCount + 1

WHERE DOW = TO_NUMBER(TO_CHAR(v_CurrentDate, 'DW'))

SELECT

MonthCount,

QuarterCount,

YearCount INTO v_DayOfWeekInMonth, v_DayOfQuarter, v_DayOfWeekInYear

FROM @DayOfWeek

WHERE DOW = TO_NUMBER(TO_CHAR(v_CurrentDate, 'DW'));

/*End day of week logic*/

/* Populate Your Dimension Table with values*/

INSERT INTO DimDate

SELECT

TO_CHAR (v_CurrentDate,112) as DateKey,

v_CurrentDate AS Date,

TO_CHAR (v_CurrentDate,103) as FullDateUK,

TO_CHAR (v_CurrentDate,101) as FullDateUSA,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD')) AS DayOfMonth,

--Apply Suffix values like 1st, 2nd 3rd etc..

CASE

WHEN TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD')) IN (11,12,13) _

THEN FROM dual TO_CHAR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD'))(1)) || 'th'

WHEN SUBSTR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD')), GREATEST(-LENGTH(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD',v_CurrentDate))),-1)) = 1 _

THEN TO_CHAR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD'))(1)) || 'st'

WHEN SUBSTR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD')), GREATEST(-LENGTH(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD',v_CurrentDate))),-1)) = 2 _

THEN TO_CHAR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD'))(1)) || 'nd'

WHEN SUBSTR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD')), GREATEST(-LENGTH(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD',v_CurrentDate))),-1)) = 3 _

THEN TO_CHAR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD'))(1)) || 'rd'

ELSE TO_CHAR(TO_NUMBER(TO_CHAR(v_CurrentDate, 'DD'))(1)) || 'th'

END LOOP; AS DaySuffix,

TO_CHAR(v_CurrentDate, 'DW') AS DayName,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'DW')) AS DayOfWeekUSA,

-- check for day of week as Per US and change it as per UK format

CASE TO_NUMBER(TO_CHAR(v_CurrentDate, 'DW'))

WHEN 1 THEN 7

WHEN 2 THEN 1

WHEN 3 THEN 2

WHEN 4 THEN 3

WHEN 5 THEN 4

WHEN 6 THEN 5

WHEN 7 THEN 6

END

AS DayOfWeekUK,

v_DayOfWeekInMonth AS DayOfWeekInMonth,

v_DayOfWeekInYear AS DayOfWeekInYear,

v_DayOfQuarter AS DayOfQuarter,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'DY')) AS DayOfYear,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'WW')) + 1 - TO_NUMBER(TO_CHAR(TO_CHAR, 'WW' (_

TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM'))) + '/1/' || TO_CHAR (_

TO_NUMBER(TO_CHAR(v_CurrentDate, 'YY')))) AS WeekOfMonth,

(_ - DATEDIFF * INTERVAL '1' QQ(QQ, 0, v_CurrentDate) + 0 _

v_CurrentDate) / 7) + 1 AS WeekOfQuarter,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'WW')) AS WeekOfYear,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM')) AS Month,

TO_CHAR(v_CurrentDate, 'MM') AS MonthName,

CASE

WHEN TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM')) IN (1, 4, 7, 10) THEN 1

WHEN TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM')) IN (2, 5, 8, 11) THEN 2

WHEN TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM')) IN (3, 6, 9, 12) THEN 3

END AS MonthOfQuarter,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'QQ')) AS Quarter,

CASE TO_NUMBER(TO_CHAR(v_CurrentDate, 'QQ'))

WHEN 1 THEN 'First'

WHEN 2 THEN 'Second'

WHEN 3 THEN 'Third'

WHEN 4 THEN 'Fourth'

END AS QuarterName,

TO_NUMBER(TO_CHAR(v_CurrentDate, 'YEAR')) AS Year,

'CY ' || TO_CHAR (TO_NUMBER(TO_CHAR(v_CurrentDate, 'YEAR'))) AS YearName,

SUBSTR(TO_CHAR(v_CurrentDate, 'MM'), 1, 3) + '-' || TO_CHAR (_

TO_NUMBER(TO_CHAR(v_CurrentDate, 'YY'))) AS MonthYear,

SUBSTR('0' || TO_CHAR (TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM'))), GREATEST(-LENGTH('0' || TO_CHAR(VARCHAR, (TO_NUMBER(TO_CHAR(v_CurrentDate, 'MM', v_CurrentDate)))),-2)) + _

TO_CHAR (TO_NUMBER(TO_CHAR(v_CurrentDate, 'YY'))) AS MMYYYY,

CONVERT(DATETIME, CONVERT(DATE, DATEADD(DD, - (TO_NUMBER(TO_CHAR(_, 'DD'

v_CurrentDate) - 1), v_CurrentDate))) AS FirstDayOfMonth,

CONVERT(DATETIME, CONVERT(DATE, -  * INTERVAL '1' DD(5)(TO_NUMBER(TO_CHAR(_, 'DD'

(INTERVAL '1' MM + v_CurrentDate)))) + INTERVAL '1' MM + _

v_CurrentDate)))) AS LastDayOfMonth,

DATEDIFF * INTERVAL '1' QQ(QQ, 0, v_CurrentDate) + 0 AS FirstDayOfQuarter,

DATEDIFF * INTERVAL '1' QQ(QQ, -1, v_CurrentDate) + -1 AS LastDayOfQuarter,

CONVERT(DATETIME, '01/01/' || TO_CHAR (TO_NUMBER(TO_CHAR(_, 'YY'

v_CurrentDate))) AS FirstDayOfYear,

CONVERT(DATETIME, '12/31/' || TO_CHAR (TO_NUMBER(TO_CHAR(_, 'YY'

v_CurrentDate))) AS LastDayOfYear,

NULL AS IsHolidayUSA,

CASE TO_NUMBER(TO_CHAR(v_CurrentDate, 'DW'))

WHEN 1 THEN 0

WHEN 2 THEN 1

WHEN 3 THEN 1

WHEN 4 THEN 1

WHEN 5 THEN 1

WHEN 6 THEN 1

WHEN 7 THEN 0

END AS IsWeekday,

NULL AS HolidayUSA, Null, Null

v_CurrentDate := INTERVAL '1' DD(5) + v_CurrentDate;

END

/********************************************************************************************/

Step 3.

Update Values of Holiday as per UK Government Declaration for National Holiday.

/*Update HOLIDAY fields of UK as per Govt. Declaration of National Holiday*/

-- Good Friday  April 18

UPDATE DimDate

SET HolidayUK = 'Good Friday'

WHERE Month = 4 AND DayOfMonth  = 18

-- Easter Monday  April 21

UPDATE DimDate

SET HolidayUK = 'Easter Monday'

WHERE Month = 4 AND DayOfMonth  = 21

-- Early May Bank Holiday   May 5

  UPDATE DimDate

SET HolidayUK = 'Early May Bank Holiday'

WHERE Month = 5 AND DayOfMonth  = 5

-- Spring Bank Holiday  May 26

UPDATE DimDate

SET HolidayUK = 'Spring Bank Holiday'

WHERE Month = 5 AND DayOfMonth  = 26

-- Summer Bank Holiday  August 25

   UPDATE DimDate

SET HolidayUK = 'Summer Bank Holiday'

WHERE Month = 8 AND DayOfMonth  = 25

-- Boxing Day  December 26  

   UPDATE DimDate

SET HolidayUK = 'Boxing Day'

WHERE Month = 12 AND DayOfMonth  = 26

--CHRISTMAS

UPDATE DimDate

SET HolidayUK = 'Christmas Day'

WHERE Month = 12 AND DayOfMonth  = 25

--New Years Day

UPDATE DimDate

SET HolidayUK  = 'New Year''s Day'

WHERE Month = 1 AND DayOfMonth = 1

--Update flag for UK Holidays 1= Holiday, 0=No Holiday

UPDATE DimDate

SET IsHolidayUK  = CASE WHEN HolidayUK   IS NULL _

THEN 0 WHEN HolidayUK   IS NOT NULL THEN 1 END

Step 4.

Update Values of Holiday as per USA Govt. Declaration for National Holiday.

/*Update HOLIDAY Field of USA In dimension*/

/*THANKSGIVING - Fourth THURSDAY in November*/

UPDATE DimDate

SET HolidayUSA = 'Thanksgiving Day'

WHERE

Month = 11

AND DayOfWeekUSA = 'Thursday'

AND DayOfWeekInMonth = 4

/*CHRISTMAS*/

UPDATE DimDate

SET HolidayUSA = 'Christmas Day'

WHERE Month = 12 AND DayOfMonth  = 25

/*4th of July*/

UPDATE DimDate

SET HolidayUSA = 'Independance Day'

WHERE Month = 7 AND DayOfMonth = 4

/*New Years Day*/

UPDATE DimDate

SET HolidayUSA = 'New Year''s Day'

WHERE Month = 1 AND DayOfMonth = 1

/*Memorial Day - Last Monday in May*/

UPDATE DimDate

SET HolidayUSA = 'Memorial Day'

FROM dbo.DimDate

WHERE DateKey IN

(

SELECT

MAX(DateKey)

FROM dbo.DimDate

WHERE

MonthName = 'May'

AND DayOfWeekUSA  = 'Monday'

GROUP BY

Year,

Month

)

/*Labor Day - First Monday in September*/

UPDATE DimDate

SET HolidayUSA = 'Labor Day'

FROM dbo.DimDate

WHERE DateKey IN

(

SELECT

MIN(DateKey)

FROM dbo.DimDate

WHERE

MonthName = 'September'

AND DayOfWeekUSA = 'Monday'

GROUP BY

Year,

Month

)

/*Valentine's Day*/

UPDATE DimDate

SET HolidayUSA = 'Valentine''s Day'

WHERE

Month = 2

AND DayOfMonth = 14

/*Saint Patrick's Day*/

UPDATE DimDate

SET HolidayUSA = 'Saint Patrick''s Day'

WHERE

Month = 3

AND DayOfMonth = 17

/*Martin Luthor King Day - Third Monday in January starting in 1983*/

UPDATE DimDate

SET HolidayUSA = 'Martin Luthor King Jr Day'

WHERE

Month = 1

AND DayOfWeekUSA  = 'Monday'

AND Year >= 1983

AND DayOfWeekInMonth = 3

/*President's Day - Third Monday in February*/

UPDATE DimDate

SET HolidayUSA = 'President''s Day'

WHERE

Month = 2

AND DayOfWeekUSA = 'Monday'

AND DayOfWeekInMonth = 3

/*Mother's Day - Second Sunday of May*/

UPDATE DimDate

SET HolidayUSA = 'Mother''s Day'

WHERE

Month = 5

AND DayOfWeekUSA = 'Sunday'

AND DayOfWeekInMonth = 2

/*Father's Day - Third Sunday of June*/

UPDATE DimDate

SET HolidayUSA = 'Father''s Day'

WHERE

Month = 6

AND DayOfWeekUSA = 'Sunday'

AND DayOfWeekInMonth = 3

/*Halloween 10/31*/

UPDATE DimDate

SET HolidayUSA = 'Halloween'

WHERE

Month = 10

AND DayOfMonth = 31

/*Election Day - The first Tuesday after the first Monday in November*/

BEGIN

DECLARE @Holidays TABLE (ID NUMBER(10) , _

DateID int, Week TINYINT, YEAR CHR(4), DAY CHR(2))

INSERT INTO @Holidays(DateID, Year,Day)

SELECT

DateKey,

Year,

DayOfMonth

FROM DimDate

WHERE

Month = 11

AND DayOfWeekUSA = 'Monday'

ORDER BY

YEAR,

DayOfMonth

v_CNTR NUMBER(10); v_POS NUMBER(10); v_STARTYEAR NUMBER(10); v_ENDYEAR NUMBER(10); v_MINDAY NUMBER(10);

SELECT

MIN(Year)

, MIN(Year)

, MAX(Year) INTO v_CurrentYear, v_STARTYEAR, v_ENDYEAR

FROM @Holidays

WHILE; v_CurrentYear <= v_ENDYEAR

BEGIN

SELECT COUNT([Year]) INTO v_CNTR

FROM @Holidays

WHERE Year = v_CurrentYear;

v_POS := 1;

WHILE v_POS <= v_CNTR

LOOP

SELECT MIN(DAY) INTO v_MINDAY

FROM @Holidays

WHERE

Year = v_CurrentYear

AND Week IS NULL;

UPDATE @Holidays

SET Week = v_POS

WHERE

Year = v_CurrentYear

AND Day = v_MINDAY

v_POS := v_POS + 1 FROM dual;

END LOOP;

v_CurrentYear := v_CurrentYear + 1 FROM dual;

END

UPDATE DimDate

SET HolidayUSA  = 'Election Day'

FROM dbo.DimDate DT

JOIN @Holidays HL ON (HL.DateID + 1) = DT.DateKey

WHERE

Week = 1

END

--set flag for USA holidays in Dimension

UPDATE DimDate

SET IsHolidayUSA = CASE WHEN HolidayUSA  IS NULL THEN 0 WHEN HolidayUSA  IS NOT NULL THEN 1 END

/*****************************************************************************************

Does anyone know how to :

1. create and run a script file on toad

2. The syntax of creating a new local and global variables and tables

Thanks

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Code Tester for Oracle Forum notifications altogether.
Code Tester for Oracle - Discussion Forum

Flag this post as spam/abuse.




--
Gene L. Bradley Jr.
Systems Analyst
Office of Information Technology
Jackson State University
1400 J R Lynch Street
P.O. Box 17750
Jackson, MS 39217
 
ph 601.979.1042
fax 601.371.9146

In God we trust; all others bring data.  ~W.E. Deming



CONFIDENTIALITY STATEMENT

This electronic transmission is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.  If you have received this communication in error, please notify us immediately by telephone (601) 979-1042. Thank you.

 
18 0 / Create an account to join the discussion.
dayangedu
Follow / 4 May 2017 at 3:08am / Toad for Oracle
Latest post by on 4 May 2017 at 9:23am

利物浦大学毕业证办理,成绩单办理,教育部学历学位认证办理 University of Liverpool

Expand content
大洋教育,QQ/微信:1619053386,【如删除,请点击网页快照查看】专业为留学生办理毕业证、成绩单、使馆留学回国人员证明、教育部学历学位认证,网上存档永久可查! 大洋教育留学服务中心:实体公司,注册经营,行业标杆,精益求精! 咨询顾问:Paul QQ/微信:1619053386 为留学生提供以下服务(以下服务主要面对留学肄业生): ★真实教育部认证,教育部存档,中国教育部留学服务中心认证...

大洋教育,QQ/微信:1619053386,【如删除,请点击网页快照查看】专业为留学生办理毕业证、成绩单、使馆留学回国人员证明、教育部学历学位认证,网上存档永久可查!

大洋教育留学服务中心:实体公司,注册经营,行业标杆,精益求精!

咨询顾问:Paul QQ/微信:1619053386

为留学生提供以下服务(以下服务主要面对留学肄业生):
★真实教育部认证,教育部存档,中国教育部留学服务中心认证(即教育部留服认证)网站100%可查.
★真实使馆认证(即留学人员回国证明),使馆存档可通过大使馆查询确认.
★留信网认证,国家专业人才认证中心颁发入库证书,留信网永久存档可查.
★毕业证、成绩单等全套材料,从防伪到印刷,从水印到钢印烫金,高精仿度跟学校原版100%相同.

◆为什么您的学位需要到使馆进行公证?
使馆教育处开具的《留学回国人员证明》是留学人员在国内证明留学身份、联系工作、创办企业、落转户口、申请国内各类基金等必备的材料。留学人员持有此证明还可以享受购买国产汽车免税等多项优惠政策。

◆为什么您的学位需要在国内进一步认证?
如果您计划在国内发展,那么办理国内教育部认证是必不可少的。一般企事业用人单位在您应聘时都会需要您提供这个认证。办理教育部认证所需资料众多且烦琐,所有材料您都必须提供原件,我们凭借丰富的经验,帮您快速整合材料,让您少走弯路。专业服务,请勿犹豫联系我!

敬告:面对网上有些不良个人中介,真实教育部认证故意虚假报价,毕业证、成绩单却报价很高,挖坑骗留学学生做和原版差异很大的毕业证和成绩单,却不做认证,欺骗广大留学生,请多留心!办理时请电话联系,或者视频看下对方的办公环境,办理实力,选择实体公司,以防被骗!

诚招代理:本公司诚聘当地代理人员,如果您是在当地从事留学生服务相关行业的,或者是正在留学的朋友,有兴趣做代理,都可以联系我们,合作共赢,共创未来!

选择实体注册公司办理,更放心,更安全!我们的承诺:可来公司面谈,可签订合同,会陪同客户一起到教育部认证窗口递交认证材料,客户在教育部官方认证查询网站查询到认证通过结果后付款,不成功不收费!

致各位留学生:
1. 本行业市场混乱,不要只贪图便宜,无论是真实版还是顶级1:1复制版,都会有相应的成本在里面,我们绝对保证一分钱一分货!  
2. 真实的使馆认证及教育部认证,公司完全按照正规的流程手续,可陪同客户一起前往北京教育部窗口递交材料!!!目前有一些同行所办理出来的认证只能在虚假网站查询1-3个月左右的时间,并不是教育部官网,也不可能永久存档。那样是对学生的不负责任,在办理的时候一定要慎重! 
3. 随时可以监视进度,我们会让您清楚看到,你所投入的每一分钱都能够确实得到回报,若您认为不值得,完全可以中止付款。
4. 面对网上有些不良个人中介,真实教育部认证故意虚假报价,毕业证、成绩单却报价很高,挖坑骗留学学生做和原版差异很大的毕业证和成绩单,却不做认证,欺骗广大留学生,请多留心!办理时请电话联系,或者视频看下对方的办公环境,办理实力,选择实体公司,以防被骗!

96 1 / Create an account to join the discussion.
j.vaessen
Follow / 15 Feb 2017 at 12:43pm / Toad for Oracle
Latest post by on 17 Apr 2017 at 7:57pm

Code Tester Freeware license expired

Expand content
Hi, I have downloaded recently Code Tester Freeware v2.7. After installation it appears I can't use the program, because I get the message that the edition is expired since 19-July-2016. Does anyone...

Hi, I have downloaded recently Code Tester Freeware v2.7. After installation it appears I can't use the program, because I get the message that the edition is expired since 19-July-2016. Does anyone know a solution? Thanks in advance.

289 1 / Create an account to join the discussion.
Rajthilak
Follow / 23 Mar 2017 at 7:56am / Toad for Oracle
Latest post by on 23 Mar 2017 at 9:58am

Best way to integrate Sonar to Toad for Oracle Professional 12.0.0...

Expand content
Hi All, Trying to identify bestway to integrate sonar tool into toad to analyse existing code and packages. There are standard quality profile setup in Sonar website across our organisation for each...

Hi All,

Trying to identify bestway to integrate sonar tool into toad to analyse existing code and packages.

There are standard quality profile setup in Sonar website across our organisation for each technology.

Finding way to use sonar tool for existing code.

Toad version: Toad for Oracle Professional 12.0.0.61

Oracle version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Thanks

Unanswered 226 2 / Create an account to join the discussion.
Yashar
Follow / 9 Mar 2017 at 12:11pm / Toad for Oracle
Latest post by on 14 Mar 2017 at 7:40am

overloaded subprograms not listed

Expand content
Overloaded subprograms are not listed. seems like Overload feature is not supported. https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm#i12352 do you have the same problem?

Overloaded subprograms are not listed.

seems like Overload feature is not supported.

https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm#i12352 

do you have the same problem?

Unanswered 200 1 / Create an account to join the discussion.
soden
Follow / 14 Feb 2017 at 1:29pm / Toad for Oracle
Latest post by on 14 Mar 2017 at 7:34am

Customizing Test Definition in Code Tester fails

Expand content
We removed an Argument from the list of parameters for a function and tried to update the Test Definition. In order to remove the argument I: - Open up the Test Editor for the specific Program being...

We removed an Argument from the list of parameters for a function and tried to update the Test Definition. In order to remove the argument I:

- Open up the Test Editor for the specific Program being tested
- Expand list of Test Elements
- Right-click on the removed test element
- Select Remove test element. 

I immediately get the "Unexpected Error Occurred" dialog with the following Message:

Internal error. Test element {...long GUID...} not found in cache collection.

Then whether I cancel or continue to create the support bundle, the dialog repeatedly comes up. I have to End Task on Code Tester to continue working. Unfortunately we are developing on a separate network so I cannot send the support bundle. We are using version 2.0.0.582 of Code Tester.

Anyone know of a solution or workaround?

Thanks,
Mitch

Unanswered 305 1 / Create an account to join the discussion.
Damir Vadas
Follow / 18 Jan 2017 at 11:32am / Toad for Oracle

table rebuild with Mat View

Expand content
Hi, When you choose for some table "Rebuild" option, Toad creates script. Unfortunately it does not works if a table has materialized view. Is there any way to fix that in next releases ...drop...

Hi,
When you choose for some table "Rebuild" option, Toad creates script.
Unfortunately it does not works if a table has materialized view.
Is there any way to fix that in next releases ...drop and create mat view script part for that table.
Brg
Damir

308 0 / Create an account to join the discussion.
karthik.rajashekaran@gmail.com
Follow / 29 Dec 2016 at 12:45pm / Toad for Oracle
Latest post by on 29 Dec 2016 at 1:35pm

Case Statement in Where clause

Expand content
I am having an issue in the where clause case statement of this select. please help me out it says 00907. 00000 - "missing right parenthesis" and e.entype = 'PRT' and (case ...

I am having an issue in the where clause case statement of this select. please help me out 

it says 00907. 00000 -  "missing right parenthesis"

                   and e.entype      = 'PRT'

                   and

                      (case

                           when (t.trans_code not in ('ABDC'))

                      then

                        (

                         (smd.user_group_desc3 = '12' and sm.process_sec_type <> 'OPOPSW' and nvl(sw.pay_receive_ind, '0') = 'C') or

                         (smd.user_group_desc3 = '12' and sm.process_sec_type = 'OPOPSW') or

                         (smd.user_group_desc3 not in ('3', '25', '12')) or

                         ((smd.user_group_desc3 = '3' and (trim(sm.ticker) = td.transaction_notes) or (t.user_char3 = 'FXO_EXERCISE' and sm.ticker <> 'USD') and e.user_field3 = 'CASH')

                           or

                          (smd.user_group_desc3 = '3' and trim(sm.ticker) = td.transaction_notes and e.user_field3 = 'FUT'

                             and exists

                              (select distinct ec.user_float10

                                   from pace_masterdbo.codes       c,

                                        pace_masterdbo.code_values cv,

                                        rulesdbo.entity_extension  ec

                                  where c.short_desc = 'ILFUTURESFXF'

                                    and c.instance = cv.code_inst

                                    and ec.user_float10 = rtrim(cv.short_desc)

                                    and trim(ec.entity_id) = trim(ee.user_char1)))

                           or

                          (smd.user_group_desc3 = '25' and t.trade_currency <> 'USD')

                         )

                       )

                    end)=1

                   and e.user_float5 is not null

499 2 / Create an account to join the discussion.
Gregory Liss
Follow / 29 Sep 2016 at 8:13pm / Toad for Oracle
Latest post by on 22 Dec 2016 at 1:56pm

Code Tester for Oracle v3.0 is out in the wild...

Expand content
All, We've been working hard for quite some time now and we're finally able to release the latest version of Code Tester for Oracle. You can get it as part of the Toad for Oracle developers Suite...

All,

  We've been working hard for quite some time now and we're finally able to release the latest version of Code Tester for Oracle.  You can get it as part of the Toad for Oracle developers Suite at https://support.software.dell.com/toad-for-oracle/12.10.  Aside from lots of bug fixes, the key change in this release is we now have a true 64 bit version (along with the 32 bit version). 

Lots of new stuff is on the way so stay tuned as we continue to work hard to make Code Tester even better.

960 1 / Create an account to join the discussion.
christophe.wirtz.external
Follow / 16 Dec 2016 at 7:50am / Toad for Oracle
Latest post by on 16 Dec 2016 at 7:59am

Editor : right click for collapse all (+)

Expand content
Hello, there a was an useful feature, collapse all folds, in TOAD for Oracle editor (v12.6 ?), and I cannot see it anymore, in beta releases too. Is this feature planned yet, in a future version...
Hello,
there a was an useful feature, collapse all folds, in TOAD for Oracle editor  (v12.6 ?), and
I cannot see it anymore, in beta releases too.

Is this feature planned yet, in a future version  ?

Thank you.

Best regards,

Christophe WIRTZ
Oracle Developper


Unanswered 402 1 / Create an account to join the discussion.
tjs_klh
Follow / 19 Jul 2016 at 8:18am / Toad for Oracle
Latest post by on 1 Aug 2016 at 9:44am

Quest Code Tester: test all packages

Expand content
Can i test all the packages in my schema at one go or one shot? Can i test selected packages (80-90 packages) from my schema at one shot? My requirement is to test some selective packages in one shot...

Can i test all the packages in my schema at one go or one shot? Can i test selected packages (80-90 packages) from my schema at one shot?

My requirement is to test some selective packages in one shot.

1345 4 / Create an account to join the discussion.
neethubeth
Follow / 7 Jul 2016 at 10:50am / Toad for Oracle
Latest post by on 28 Jul 2016 at 2:14pm

How can I combine a value from a output to another output variabl...

Expand content
My proc has to results-one is a number and other a string.I need to combine the number with the string as the second output in code tester. i tried the below. 'Member ID ' || e_OUT_MEMBER_ID...

My proc has to results-one is a number and other a string.I need to combine the number with the string as the second output in code tester. i tried the below.

'Member ID ' || e_OUT_MEMBER_ID  ||'does not exist'. but output is without the number.

What should i do to get the proper output .I cannot hardcode the value bcoz the id would change.Please advice.

Unanswered 1074 1 / Create an account to join the discussion.
Karpov Denis
Follow / 10 Mar 2016 at 11:18am / Toad for Oracle
Latest post by on 17 Mar 2016 at 2:28pm

DctoCmd.ехе

Expand content
Good afternoon, Advice on DctoCmd.eхe. Completed step import. There metodannye, but there is a package for testing. Package testing is always necessary to create or have a team? -Generate Test definitions...

Good afternoon,
Advice on DctoCmd.eхe.
Completed step import.
There metodannye, but there is a package for testing.
Package testing is always necessary to create or have a team?
-Generate Test definitions
/ Import =
/ Generate / T =

Analog button, but the command line

1497 4 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 4 Jan 2016 at 11:21am / Toad for Oracle
Latest post by on 17 Mar 2016 at 6:09am

Want to test the code in SCHEMA A, but the extra code for each test...

Expand content
My code is in Schema A, I want to test in Schema A but the extra code that is getting generated for each test case should be stored in Schema B. Please Suggest the Correct approach.


My code is in Schema A, I want to test in Schema A but the extra code that is getting generated for each test case should be stored in Schema B. Please Suggest the Correct approach.

1228 1 / Create an account to join the discussion.
n_praveen_kumar
Follow / 19 Jan 2016 at 10:49am / Toad for Oracle
Latest post by on 13 Mar 2016 at 6:18pm

How to handle raise_application_error in test cases

Expand content
Hi All, In the exception block of pl/sql code i have raise_application_error(-20001,.......) and when i create a test case and try to run getting the below error Error.docx

Hi All,

In the exception block of pl/sql code i have raise_application_error(-20001,.......) and when i create a test case and try to run getting the below error

Error.docx

1318 1 / Create an account to join the discussion.
dfacch
Follow / 3 Mar 2016 at 8:16pm / Toad for Oracle

Multiple Inputs and Outcomes

Expand content
I am testing a function that return a single value and takes 5 as input. For the test values and results I have generated a view where each record consists of the 5 inputs and the correct output value...

I am testing a function that return a single value and takes 5 as input.  For the test values and results I have generated a view where each record consists of the 5 inputs and the correct output value.  In setting up the Inputs I select from the view to retrieve multiple values for each input parameter and sort each the same way.  I do the same for the outcomes.  In the Test Case Properties window I chose "Correlation of values between groups" and then I preview that correlation.  All the inputs are matched correctly and appear with their correct outcome and there are 23 records.  Now when I run the test the very first record in the group passes and then the rest fail.  Upon reviewing the results I notice that the Inputs are all the same record, the first one.  The outcomes are the results for each of the 23 records so it appears that the tester is comparing the first set of inputs to each of the 23 outcomes and not comparing each record I saw in the correlation preview to the matching outcome.  I am working with a trial version 2.7.0.1026.

I am a code tester rookie and could very well be doing something wrong but not sure that that could be.

Unanswered 1001 0 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 11 Jan 2016 at 11:02am / Toad for Oracle

How to test a function that Anydata input parameter ????/

Expand content
How to test a function that Anydata input parameter ????/

How to test a function that Anydata input parameter ????/

Unanswered 1122 0 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 7 Jan 2016 at 10:27am / Toad for Oracle

Database objects are not displayed in code tester, after connection...

Expand content
Database objects are not displayed in code tester, after connection is established

Database objects are not displayed in code tester, after connection is established 

999 0 / Create an account to join the discussion.
n_praveen_kumar
Follow / 6 Jan 2016 at 2:59pm / Toad for Oracle

Getting Error when running Dynamic Sql

Expand content
Hi All, I am getting error message as below, when creating test case for procedure which has result set query build dynamically, took the dynamically created query and tried to equate it will the result...

Hi All,

I am getting error message as below, when creating test case for procedure which has result set query build dynamically, took the dynamically created query and tried to equate it will the result set  in

outcomes tab using the Query option, please let me know the correct solution for this problem

Type        Description

ERROR  Code Tester cannot determine the list of elements in the select list for this test. You must either specify a valid table, view or query in the Properties Window of the cursor variable or you must                             compare the cursor variable to a static table, view or query  (not an expression).

1051 0 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 5 Jan 2016 at 12:59pm / Toad for Oracle

issue when testing with type

Expand content
Internal error. Unable to resolve type test_TBL". Please make sure that this type exists in your data base or is "visible" to your connected schema. Please help to resolve this issue...

Internal error.
Unable to resolve type test_TBL". Please make sure that this type exists in your data base or is "visible" to your connected schema.

Please help to resolve this issue.

1033 0 / Create an account to join the discussion.