What relational operators is used for in groovy?

5

From the following information you are to prepare a Cash Budget for the period from July to December 2008. (i) The estimated sales and expenses are as follows: June July Aug. Sep. Oct. Nov. Dec. Sales 35,000 40,000 40,000 50,000 50,000 60,000 65,000 Purchases 14,000 16,000 17,000 20,000 20,000 25,000 28,000 Wages & Salaries 12,000 14,000 14,000 18,000 18,000 20,000 22,000 Expenses 5,000 6,000 6,000 6,000 7,000 7,000 7,000 Interest Received 2,000 - - 2,000 - - 2,000 Sale of Fixed Assets - - 20,000 - - - - (ii) Sales are 20% in cash and balance on credit. 50% of the debtors are collected in the month of sales and the remaining in the next month. (iii) The time lag in payment of purchases and expenses is 1 month. However, wages and salaries are paid fortnightly with a time lag of 15 days. (iv) The company maintains a minimum cash balance of Rs. 5,000. The cash balance in excess of Rs. 7,000 is invested in government securities in multiples of Rs. 1,000. Short falls in cash balance are made good by borrowing from banks. The interest received as well as paid is to be ignored.

4173

what is the difference between public cloud and private cloud?

592

Can a .net web application consume java web service?

906

What is a healing tool?

33

What are the life cycle of reactjs?

348

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2105

What is the use of swing in java?

1004

What are the significance of mqseries?

877

​​Can multiple abap systems connect to abap database?

1071

why you are using proxy adapter and why you are not using idoc and rfc adapters ?

1494

What are literals in sql server?

1085

how to implement data validations?

542

How do you describe the correlation of a scatter plot?

590

create or replace procedure search_matter(empno varchar2) as sql_stmt varchar2(200); stmt varchar2(200); v_table_name varchar2(200); val_pres number; inp_value varchar2(200); type obj_typ is table of cols.column_name%type index by binary_integer; type all_col is table of varchar2(100) index by binary_integer; typ_obj_typ obj_typ; typ_all_col all_col; begin select object_name bulk collect into typ_obj_typ from user_tables,user_objects where table_name = object_name AND object_type = 'TABLE'; select empno into inp_value from dual; dbms_output.put_line('inp value : '||inp_value); for i in typ_obj_typ.first..typ_obj_typ.last loop v_table_name := NULL; v_table_name := typ_obj_typ(i); dbms_output.put_line(i||':'||typ_obj_typ(i)); dbms_output.put_line('....................'); sql_stmt := 'select column_name from cols where table_name = :1 and data_type in (''CHAR'', ''VARCHAR2'', ''NCHAR'', ''NVARCHAR2'',''NUMBER'')'; EXECUTE IMMEDIATE sql_stmt bulk collect into typ_all_col using typ_obj_typ(i); for inside in typ_all_col.first..typ_all_col.last loop dbms_output.put_line('sql stmt: '||sql_stmt); dbms_output.put_line('column name: '||typ_all_col(inside)||'table name: '||typ_obj_typ(i)); stmt := 'select count(*) from ||typ_obj_typ(i)||'; EXECUTE_IMMEDIATE stmt into val_pres ; if val_pres = 1 then dbms_output.put_line('value present col name: '||typ_all_col(inside)||'table name :'||typ_obj_typ(i)); end if; end loop; dbms_output.put_line('....................'); end loop; exception when others then dbms_output.put_line('sql code '||sqlcode||'Table name: '||v_table_name); dbms_output.put_line('sql message '||sqlerrm); end; Compile-time I am getting below error, Plz help to resolve. LINE/COL ERROR -------- ----------------------------------------------------------------- 47/23 PLS-00103: Encountered the symbol "STMT" when expecting one of the following: := . ( @ % ;

965