suppose I want to find all tables and views that has column name "last_name" for example.
Question
Oraask Latest Questions
Question
how do I check before adding a new column to a table if it's exists or not ? thanks in advance
Question
I want to create new column say (ID) with auto generated sequence number with auto increment by 10.how can I achieve this in oracle database 11g ?
Question
I have a column with datatype CLOB and I want to get column valueI tried using select DBMS_LOB.substr(last_name) from employees for example but it's throwing error ,I need help to query a CLOB column.
Question
i have two date columns and i want to get the number of days between those two dates