oracle dynamic select into
Solutions on MaxInterview for oracle dynamic select into by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle dynamic select into"
Athalia
23 Jan 2016
1SET SERVEROUTPUT ON;
2DECLARE
3 sql_qry VARCHAR2 (150);
4 emp_tot NUMBER(3);
5BEGIN
6
7 sql_qry:= 'SELECT count (*) FROM employees';
8 EXECUTE IMMEDIATE sql_qry INTO emp_tot;
9 DBMS_OUTPUT.PUT_LINE ('Total employees are: '||emp_tot);
10
11END;similar questions
oracle procedure dynamic sqlselect sequence oraclefor select oraclequery saurce oracleoracle sql create or replace viewchange date format in oracle queryhow to use or values in oracleoracle sql wildcard likeselect all source oracleset sequence value oracleinsert into select oracleoracle select intoupdate from select oraclehow to store select query result in variable in oracleoracle selectoracle insert from selectoracle select partitionoracle select first resultoracle create as selectoracle source queryoracle query to see what scema i am working inoracle 3a using statementoracle sql drop sequenceoracle sql select into variableoracle sql create table from select your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful