How can i Import a CSV File from Windows link by PLSQL
Discy Latest Questions
ShimulProfessional
create or replace FUNCTION base64encode(p_blob IN BLOB) RETURN CLOB IS l_clob CLOB; l_step PLS_INTEGER := 12000; -- make sure you set a multiple of 3 not higher than 24573 BEGIN FOR i IN 0 .. TRUNC((DBMS_LOB.getlength(p_blob) - 1 )/l_step) LOOP l_clob := l_clob || UTL_RAW.cast_to_varchar2(UTL_ENCODE.base64_encode(DBMS_LOB.substr(p_blob, l_step, i * l_step + 1))); END LOOP; RETURN l_clob; END; Please Explain this Function.
CREATE TABLE EMP (ID NUMBER, EMP_NAME VARCHAR2(50), ADDRESS VARCHAR2(500)); CREATE TABLE PROJECT (ID NUMBER, EMP_ID NUMBER, PROJECT_NAME VARCHAR2(50), LOCATION VARCHAR2(500))
I want to create a pivot report (Department wise sum salary). I need to use sub_query in pivot. XML cannot be used here. Example: SELECT * FROM ( SELECT DEPARTMENT_ID,SALARY FROM EMPLOYEES ) PIVOT (SUM(SALARY) FOR DEPARTMENT_ID IN (SELECT DISTINCT DEPARTMENT_ID FROM EMPLOYEES) )
The QR code of the report will show the link of the report. Clicking on that Report link will show the report.
ShimulProfessional
How Can i Send Bulk Email by using Mailchimp from Oracle Apex?
How to print directly when I click the Print button. No Print Preview. Bi Publisher or PLSQL Dynamic Content any one.
How to avoid a button from multiple clicking without Dynamic Action. Click to Disable Button or Avoid Multiple Clicking...
In Bi Publisher Report, How can i use multiple layouts through a Single query? That means my query will be one but the layout will be Many.
TABLE Like: Select Item_id,Item_name,Url from Item_Master. i have 300 Item And 300 Report Layout. But There is one print button.. when i will pressed print button. Item_Master Table Url Column Layout will be Preview.