Arithmetic Operators
*, /, +, -, ^
Comparison Operators
>, < , >= , <= , <> , = , IN , BETWEEN, LIKE, IS
Logical Operators
NOT, AND, OR
Other Operators
.. , **, ||
End to End Topics With SQL,PL/SQL,Reports,Forms,XML Reports,OAF,Oracle Apps
Hi There,
ReplyDeleteFully agree on Operators in PL/SQL. 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.
can you please help me out on this.
The error what I am getting is (ORA-00904) highlighted at the end with RED color.
Below is the process what followed.
I think the issue with build query with QUOTES(').
By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
Best Regards,
Banu
Hello There,
ReplyDelete11/10!! Your blog is such a complete read. I like your approach with Operators in PL/SQL . Clearly, you wrote it to make learning a cake walk for me.
there are TWO tables as below
USER_DATA_B
1>USER_ID
2>CUST_ID
3>CREATE_DT
4>LOG_ID
USER_LOGON_ID_CHANGE_B
1> ID
2>USER_ID
3>NEW_LOGON_ID
4>OLD_LOGON_ID
5>OLD_CREATE_DT
6>ROW_CREATE_DT
the existing query to show the details in UI is as below
SELECT USER_ID,OLD_CREATE_DT,ROW_CREATE_DT FROM USER_LOGON_ID_CHANGE_B WHERE OLD_LOGON_ID=?
AND NEW_LOGON_ID IS NULL
UNION
SELECT USER_ID,CREATE_DT,NULL FROM USER_DATA_B WHERE LOG_ID=?
ORDER BY OLD_CREATE_DT
Now, my requirement is to join the above query with the following table
CUSTOMER_ATTRIBUTE_B
1>CUST_ID
2> ATTRIBUTE_TYPE_CD
3>ATTRIBUTE_DATA
The new query output should be below
1>USER_ID
2>OLD_CREATE_DT,
3>ROW_CREATE_DT
4> ATTRIBUTE_TYPE_CD
5>ATTRIBUTE_DATA
Great effort, I wish I saw it earlier. Would have saved my day :)
Thank you,
Preethi.
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDeleteOracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDeleteUsually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man learn Oracle SOA Online Training
ReplyDelete