- Displays date but not time
Hi all,I have problem in displaying time. it only displays date but not time. i am using DECODE(PROC_TM,'999999', NULL,PROC_TM) proc_tmand then PROC_TME = TO_DATE(C2.PROC_TM, 'HH24MISS')It only displays date but not the time. what should i do?And in another procedure i have time displayed bu...
- DISPLAYNAME_CONVERSION_ERROR in XML DB
Hello,After I have installed Oracle 10g Release 2 patchetset 1 (10.2.0.2.0), I have created a new database (the previous one was disabled after the update process, I suppose I did not make all steps well). This new database has the NLS parameters following:nls_language: SPANISHnls_territory: SPA...
- Displaying XMLTYPE columns values in SQLPLUS
I am trying to convert DB Table Data to XML. I am trying to use a Query like this in SQLPLUS in Oracle Version 9.2.0.3.0.I am using a Query like the one belowSELECT XMLELEMENT ( "Emp", XMLATTRIBUTES (e.id,e.fname ||' ' || e.lname AS "name")) AS "result" FROM employees e WHERE employee_...
- displaying xml tables in oracle
Hi, i've never worked with oracle before and i have a trouble with displaying blobs.I use oracle 10g and i create a table of xml type or one that has a column of xml type and every time i select to view it's contents i get an error message(Oracle cannot display tables of blob type...et...
- displaying while FOR loop is executing
If I have a dbms_output.put_line statement inside a FOR loop, I won't be able to see the output until all the iterations of the loop are completed. If I want to see the record that is currently being processed in the for loop while the loop is still running, what should I do ?...
- displaying values separated by comma
I dont know how to describe my problem . i will demonsatrate it using an example .Consider a query :select name , age , things from table :the output is like :name age thingsharris 21 batharris 21 ballharris 21 bagharris 10 notebookrovina 21 laptoprovina 21 cablerovina 21 penbut i should get the...