tag:blogger.com,1999:blog-5996086843181765772.post6973833279775848013..comments2018-11-15T06:05:05.465-08:00Comments on Oracle Appplications: SQL Grant and RevokeDayakar knoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5996086843181765772.post-82662488844038673902018-06-23T02:55:31.746-07:002018-06-23T02:55:31.746-07:00Hey,
I learnt so much in such little time about ...Hey,<br /><br /><br />I learnt so much in such little time about #topic. Even a toddler could become smart reading of your amazing articles.<br />I have requirement like <br /><br />select COL1,Col2 from A<br />minus<br />Select COL1,COL2 from B;<br /><br />both tables have 50+ millions record so I want to automate a job which will execute this query for 1millions records for one<a href="https://asha24.com/blog/plsql-interview-questions-and-answers/" rel="nofollow"> time </a> and then again 1 millions for second time...like loop and store output in record type.<br /><br /><br /><br />But nice Article Mate! Great Information! Keep up the good work!<br /><br /><br />Kind Regards<br />Morgan leehttps://www.blogger.com/profile/11357663258455123293noreply@blogger.comtag:blogger.com,1999:blog-5996086843181765772.post-4423407122068135402018-06-19T02:09:53.724-07:002018-06-19T02:09:53.724-07:00Hi Dayakar,
Fully agree on SQL Grant and Revoke ....Hi Dayakar,<br /><br />Fully agree on SQL Grant and Revoke . We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.<br /><a href="https://asha24.com/blog/plsql-interview-questions-and-answers/" rel="nofollow"> <br />My table </a> column type is clob. Field value contain double quotes<br /><br />id,text_clob,date<br /><br />1,&quot;\&quot;data1\&quot;,0,1,1,1,\&quot;data2\&quot;&quot;,&quot;2018-03-03 09:08:45&quot;<br /><br />can you kindly help loader query. i cant use replace in clob field.<br /><br /><br /><br /><br /><br /><br />It was cool to see your article pop up in my google search for the process yesterday. Great Guide.<br />Keep up the good work!<br /><br /><br /><br />Thank you, <br />AjeethAjeeth Kapoorhttps://www.blogger.com/profile/11674257547961232200noreply@blogger.comtag:blogger.com,1999:blog-5996086843181765772.post-59029732014966212342018-05-03T23:36:26.553-07:002018-05-03T23:36:26.553-07:00Ohayo,
Best thing I have read in a while on this...Ohayo,<br /><br /><br />Best thing I have read in a while on this SQL Grant and Revoke . There should be a standing ovation button. This is a great piece.<br /><br />1) I am new to Oracle, Im not a DBA and I ve tring to figure out this error in a log:<br /><br />ERROR in QUETOL.tol_lc_movimientos_pg.movimientos SQLCODE[=ORA-20109:<br />ORA-20109: ORA-01422: exact fetch returns more than reques]<br /><br /><br />The problem arises I dont even know exactly this error which object references to: ie package, procedure,table,etc<br /><br />QUETOL.tol_lc_movimientos_pg.movimientos<br /><br />I tried to find this object as a Package but i could not find it?<br /><br />SQL&gt; SELECT object_name,OBJECT_TYPE,CREATED,STATUS,GENERATED FROM dba_objects<br /> 2 WHERE object_name = &#39;QUETOL.tol_lc_movimientos_pg.movimientos&#39;<br /> 3 AND object_type = &#39;PACKAGE&#39;;<br /><br />no rows selected<br /><br />I tried to find as any other object but i didn’t get anything.<br />SQL&gt; SELECT object_name,OBJECT_TYPE,CREATED,STATUS,GENERATED FROM dba_objects<br /> 2 WHERE object_name LIKE &#39;%tol_lc_movimientos_pg.movimi%&#39;<br /> 3 ;<br /><br />no rows selected<br /><br />I thought it was a Package so I could see its DML code.<br /><br />I appreciate your help in advanced to <a href="https://asha24.com/blog/plsql-interview-questions-and-answers/" rel="nofollow"> identify </a>which Object this log error point to point.<br /><br /><br />Anyways great write up, your efforts are much appreciated.<br /><br /><br />Obrigado,<br /><br />Ganesh Ponnahttps://www.blogger.com/profile/04859983121687046225noreply@blogger.comtag:blogger.com,1999:blog-5996086843181765772.post-24498332954901333812018-04-22T23:51:07.595-07:002018-04-22T23:51:07.595-07:00hi Dayakar,
Amaze! I have been looking bing for h...hi Dayakar,<br /><br />Amaze! I have been looking bing for hours because of this and i also in the end think it is in this article! Maybe I recommend you something helps me all the time?<br /><br />i am trying to create a database to calculate employees’ net montly payments for lunch. But i have a problem and cannot find a way to solve it. I can describe my problem shortly as follows: <br />I have three table. In the first one, i keep the employees’ personal details like id, name, dob etc. In the second one i keep the net workday number for each month along 10 years. In the third one, i want to keep all employees’ ids, net workday numbers at the second table as a default value and the payments he/she have to do.<br /><a href="https://asha24.com/blog/sql-interview-questions-and-answers/" rel="nofollow">At the first sight, i think </a> that i can do it like the second table for ten years. But, due to the fact that there can be a rotation among the employees, this table will not work as i hope.<br />I think that it can be a solution saving the third table at the beginning of the next month, but how can i do? Or, what will be your solution? (Please share your sample codes)<br /> <br /><br />Thank you very much and will look for more postings from you.<br /><br /><br />Obrigado, <br />Irene Hynes<br />Irene Hyneshttps://www.blogger.com/profile/01329230669792273903noreply@blogger.com