Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in fetching data for a single column

Anindya GayenJul 29 2013 — edited Jul 31 2013

Hi,

I have a requirement where I have to fetch three records (intf.INTERFACE_DEF_ID , b2b.B2B_TPA_DEF_ID , osb.OSB_INF_DEF_ID) for the select statement to a particular column(val_id)

The below query is giving error.

Please help..

select

(intf.INTERFACE_DEF_ID or b2b.B2B_TPA_DEF_ID or osb.OSB_INF_DEF_ID) as val_id

FROM

ABC.INTERFACE_DEF intf,

ABC.B2B_TPA_DEF b2b,

ABC.OSB_INF_DEF osb;

Thanks.
This post has been answered by BluShadow on Jul 30 2013
Jump to Answer

Comments

Answer

they are ALL locked until you either unlock or end the session.

Marked as Answer by Mubashar Iftikhar · Sep 27 2020
Mubashar Iftikhar

Hi Dear
I need some guidance.

Can you please share with me your email address ?

Dave Stokes-MySQL Community Team-Oracle

it would probably be better to get help from https://forums.mysql.com as i am travelling so much this time of year.  Our MySQL Oracle Enginners monitor the forums and will be fast to answer then I

Mubashar Iftikhar

Actually i need guideline of MYSQL 5.6 Exam , and at forms i dont think i can get better information .

I am no longer involved with the MySQL certification exams but can tell you I took the beta of the 5.6 DBA exam and found it very hard.   Another member of the MySQL Community Team at the time of the beta took the DBA and Developer exams and concurred that they were very hard.  The best advise is to go through the list of items covered on the exam and study your rear end off.

Good luck.

Mubashar Iftikhar

Dear Sir

      I know this exam is very hard because i have already attempted 2 times and not able to clear the exam. . & i have done my complete preparation from official documentation https://dev.mysql.com/doc/refman/5.6/en/preface.html plus 6 months practical work. Now i just trying to find out a way how to clear this exam because this task giving me a lot of headache.

Mubashar Iftikhar

Hi Dear

I am in search of open source data platform which can perform ETL over Big data (structured, semi-structured & un-structured) and analytical tools for data visualization to build analytical dashboards.

I will be grateful if you can share your choice of open source data platform and data visualization tools information & your use case high level information their key features and unique capabilities. Also relevant enablement resources/training options.

Looking forward for a healthy discussion over here.

Regards

Mubashar Iftikhar

Mubashar Iftikhar

Dear Dave Stokes,
I need some help.

I have two MySQL Database Servers i.e. One is Active Server --> Master and second is Passive Server --> Slave.

And as we know we have 3-4 MySQL HR,DR Solutions / Clustering options.For example

01 : MySQL NDB Cluster

02 : MySQL InnoDB Cluster

03 : MySQL Cluster Carrier Grade

My First Question is i want to deploy One Active & One Passive MySQL Server so which Cluster Option / HA,DR Option will be fit for above mentioned scenario ?

My Second Question is suppose i have deploy One Active & One Passive MySQL Server in any above mentioned Cluster Option / HA,DR Option. So what about licensing ? I have to buy license of MySQL Servers/ Cluster ?

Regards,

Mubashar Iftikhar

Please see your other question asked today.

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 28 2013
Added on Jul 29 2013
#data, #error, #in, #pl, #pl-sql, #plsql, #query, #select, #sql
17 comments
1,410 views