Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java Training in Chennai. or learn thru Java Online Training in India . Nowadays Java has tons of job opportunities on various vertical industry.
Hello,I genuinely do look forward for the time where you post some new write ups. Your blog make me feel so educated! Continue soaring and writing please.I need to build a select from table & data to outputa single row for the ID:Data in table test_tbl.. attached snapshot The output of select shall be as follows, in single row per IDe.g 100 21:00 21:30 22:00200 15:00 15:30 16:00 16:00 17:00Awesome! Thanks for putting this all in one place. Very useful!Grazie,Bindu
Hello There,I genuinely do look forward for the time where you post some new write ups. Your blog make me feel so educated! Continue soaring and writing please.write a programme that reads standard input and prints the characters greater than 40But nice Article Mate! Great Information! Keep up the good work!Thanks and Regards,Irene
Hello,#Topic being contrived to exist for many projects simply so it can be run will be the first to hit the wall, but those projects where the functions to make existing transactions cheaper in real world applications will find the elusive real world demand.I am trying to use this in a materialized view and got below error:SQL Error: ORA-12015: cannot create a fast refresh materialized view from a complex query12015. 00000 - "cannot create a fast refresh materialized view from a complex query"*Cause: Neither ROWIDs and nor primary key constraints are supported forcomplex queries.*Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETEoption or create a simple materialized view.select IR.rowid MV_INST_LOBR_ROWID, J.rowid Job_ROWID, J.* FROM JOB JLEFT JOIN MV_INST_LOB_R IR ON(IR.I1503_CUST_AC_NO_PT1 = J.I3200_CUST_AC_NO_PT1 AND IR.I1503_CUST_AC_NO_PT2 = J.I3200_CUST_AC_NO_PT2 AND IR.I1503_INST_SEQ_NO = J.I3200_INST_SEQ_NO)WHERE IR.I1503_CUST_AC_NO_PT1 IS NOT NULL AND IR.I1503_CUST_AC_NO_PT2 IS NOT NULLUNION SELECT null, J.rowid Job_ROWID, J.* FROM JOB J WHERE J.I3200_CUST_AC_NO_PT1 IS NULL AND J.I3200_CUST_AC_NO_PT1 IS NULL;Basically, the intention is to get all the records joining MV_INST_LOB_R and JOB tablewhere MV_INST_LOB_R do not have record for the joining condition J.I3200_CUST_AC_NO_PT1 / J.I3200_CUST_AC_NO_PT2Can you help me in converting to simple query, so that I can use simple materialized view.Follow my new blog if you interested in just tag along me in any social media platforms!,Merci
Hi There,Interesting piece!Great to see someone write "Interviews company" who is not a fanatic or a complete skepticI was trying to retrieve all the columns names from over 100 different views in an oracle database earlier today. I wasn't quite sure how to do it, so to save time I used query to get all the view names, then simply wrote a query that selected the view name and column names from all views where view_name in (list of views).I was thinking about writing looping through all the view_names in the database and for each iteration storing the column_names in a variable and the outputting this to the screen.As each view can have differing number of columns though would I have to store the column names in a record variable?Then how would I retrieve the column names for each view name stored in this record variable?Very useful article, if I run into challenges along the way, I will share them here.Shukran,Preethi.
Post a Comment
Subscribe in a reader