Find A String In Database
July 1st, 2017, posted in Oracle QueriesI’ve tried using this statement below to find an appropriate column based on what I think it should be named but it returned no results :
SELECT * from dba_objects WHERE
object_name like '%DTN%'
A column isn't an object. If you mean that you expect the column name to be like '%DTN%', the query you want is:
SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE '%DTN%';Bohlool and Serious Advice
June 30th, 2017, posted in MESSAGEs, POEPLes, STORiES, SufismIt is said that Bohlool mostly spent his time sitting in a graveyard. One day, as usual, he went there. Abbasid Caliph Haroon Al-Rashid passed by, desiring to hunt. When he arrived near Bohlool he asked, “Bohlool, what are you doing?”
“I have come to visit such people who don’t backbite, don’t expect anything from me and don’t cause me pain in any way.”
“Will you tell me something about Qiyamah (The day of Resurrection), Sirat (Bridge), and the questions and answers about this world?”
“Tell your slaves to kindle a fire and place a flat iron pan over it till it becomes red-hot.”
Abbasid Caliph Haroon Al-Rashid ordered it and it was done.
“O Abbasid Caliph Haroon Al-Rashid !! I will stand barefoot on this pan and introduce myself. I will describe whatever I have eaten and worn. After that, you also stand barefoot like I did, introduce yourself, and describe whatever you have eaten and worn.”
Abbasid Caliph Haroon Al-Rashid agreed.
Then Bohlool stood on the hot pan and quickly said, “Bohlool, a bundle (of tattered clothes), barley bread and vinegar.” He said this and immediately came off; his feet were not burned at all. When Abbasid Caliph Haroon Al-Rashid‘s turn came, he couldn’t introduce himself the way he wanted to, his feet got burned, and he fell off.
“O Abbasid Caliph Harun Al-Rashid !! Qiyamat’s questions and answers are like this. Those who worship Allah (SWT), are content, and stay away from greediness of the world’s rank and dignity will easily pass Sirat (Bridge), but those who are attached to worldly majesty and splendor will be arrested with troubles.”
