how do I check before adding a new column to a table if it's exists or not ? thanks in advance
Question
Oraask Latest Questions
Question
suppose we have 55214 (number of seconds) and i want to convert this number to Hours:Minutes:Seconds format how to do this in oracle ?
Question
some people suggest to use this query : select * from employees where rownum <= 10 order by salary; but the problem with this will return a random set of ten rows ordered by salary which is not what I need.
Question
I have two tables one ordinary table and other is log of this table test_table test_tab_log I want to insert new row in the log table for each insert statement executed for basic table even if there is rollback executed. simply every row inserted in the base table ...
Question
hello guys can someone explain to me what is the differences by easy way and with example if possible.
Question
hi i have data set that has ampersand symbol "&" and i want to insert this data but when i put this symbol into values of insert statements TOAD asking for substitution value i tried to escape this symbol but it ...
Question
i have a string like this String Oracle Forms 10G and i want result to be like this String OracleForms10G without spaces between words is there any oracle function to do this ...
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 table has column ID,NAME which ID is PK I want to insert a new row if only this new row doesn't exist in the table something like this : if ID doesn't exist then INSERT STATEMENT HERE ; end if;
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.