hello I want to know if my column value is number or character in oracle 10g something like : select (case when ( is_number(mycolumn)) then 'your column value is number' else 'your column value is not number'
Question
Oraask Latest Questions
Question
Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" i face this error when trying to execute this update statement please can anyone tell me error cause and solution UPDATE employees set last_name = 'test' JOIN dept ...
Question
how can know all reserved words by oracle to avoid using it ?
Question
Please, I want to know how to create dynamic tables ,columns, and datatype for each column in oracle ?
Question
I have confused about the meaning of schema and user is there any difference between twice or not ?
Question
i have a table with some values in it basically i want to count how many number (2) present in this table : Col1 Col2 Col3 ----- ------- ------- 2 1 3 8 ...
Question
i want to update my table with data in another table in oracle sql for example Table 1: ID NAME DESC --------------------------- 1 ...
Question
i want to know whether partitioning enabled or not in my database
Question
i have two date columns and i want to get the number of days between those two dates
Question
i have a beginner question in SQL how to concatenate two string or two values in sql?