Interviews company

Interview Questions By Company Name



5 comments:

for IT the said...

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.

Abhiram Sharma said...

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 output
a single row for the ID:
Data in table test_tbl.. attached snapshot

The output of select shall be as follows, in single row per ID
e.g 100 21:00 21:30 22:00
200 15:00 15:30 16:00 16:00 17:00


Awesome! Thanks for putting this all in one place. Very useful!


Grazie,
Bindu

Abhiram Sharma said...

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 40

But nice Article Mate! Great Information! Keep up the good work!


Thanks and Regards,
Irene

Morgan lee said...

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 query

12015. 00000 - "cannot create a fast refresh materialized view from a complex query"

*Cause: Neither ROWIDs and nor primary key constraints are supported for

complex queries.

*Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE

option or create a simple materialized view.


select IR.rowid MV_INST_LOBR_ROWID, J.rowid Job_ROWID, J.* FROM JOB J

LEFT 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 NULL

UNION 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 table
where MV_INST_LOB_R do not have record for the joining condition J.I3200_CUST_AC_NO_PT1 / J.I3200_CUST_AC_NO_PT2


Can 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

preethi Sharma said...

Hi There,

Interesting piece!Great to see someone write "Interviews company" who is not a fanatic or a complete skeptic

I 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.

 
Top Blogs