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
Oraask Latest Questions
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
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
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