What is the typical enclosure type used for Indoor switchgear / Outdoor switchgear Units? - In Onshore / offshore Units?
1000I have more than 10years of experience in software company and my company is filling for l1b blanket visa. My b.tech degree is in chemical engineering. Do you see any issues in getting the visa?
980Dear all i want to know SEWA Electrical Supervisor Licence test Previous Year Questions ? If any body know please send to me zohairaukllah@yahoo.com
1038create 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: := . ( @ % ;
1001Create a structure to specify data on students as given below: Roll number, Name, Department, Course, and Year of joining. Assume that there are not more than 450 students in the collage. (a) Write a function to print the names of all students who joined in the last 3 years. (b) Write a function to print the data of a student whose roll numbers are divisible by 4.
1115I have learn the course SAP FI/CO in the Yr.2007 and have an experience in this part as a FI-End user of 2.8 yrs. Presently I have working in ERP –Accounts department & have More than 15 yrs. Experience. Please suggest me how can I grow my experience in SAP FI/Co due to changing my job? Waiting for your response plese.
913Determine the production capacity of a treatment plant for a city of 1,250,000 population. Assume the specific consumption per capita of 15ol/c/d, non-domestic water use of 30,000,000 m³/year, and UFW of 12%.
1109I need to learn who the major stakeholders are in each of the 7 stages of the SDLC. What is the best online resource?
1168I need to learn everything I can about what a Waterfall approach vs. an Agile approach looks like in QA Testing. What is the best online resource?
1093
How to culture bone marrow monoclear cells?
What is Event - Delegate? clear syntax for writing a event delegate
I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com
In near future would you be willing to manage a branch office? If no, why not?
What would you say your one or two biggest failures or mistakes were? What did you learn from them?
What are your research skills?
Where do you see yourself in 5 years? Are you intent on becoming a career prosecutor?
What is the fertilizing value of hog manure, and also what is the best fertilizer to use for potatoes as Our potatoes are planted early in January.
How many years you are having experience in supervising others in lab environment?
During a heart attack, blood flowing to the heart muscle is interrupted by blockage of a coronary artery. How would you expect the metabolism in the heart to change?
According to ACOG, Pap smears should be obtained at what regular periods of time?
A certain radioactive element A, has a half life = t seconds. In (t/2) seconds the fraction of the initial quantity of the element so far decayed is nearly how much?
Assume that I am a potential corporate partner. Tell me on the benefits of the Industrial Research Office with 3 bullet points.
Which marketing research tools and techniques did you used?
Tell me about the most difficult sale you have made. What did you learn from it?