hello guys can someone explain to me what is the differences by easy way and with example if possible.
Question
Oraask Latest Questions
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
please i want to find way to convert clob datatype to varchar2 datatype i searched many times through google but with no valuable result.
Question
hello can I use select inside if statement like : begin if (select count(*) from employees) >= 15 then do something; end if; end; note : I want to delete rows from table where above condition evaluates with true
Question
I have a PL/SQL procedure to update a number of rows in a table. is there is there any way to know the number of rows updated by update statement executed inside my procedure?
Question
I want to raise user defined exception but with custom exception error message something like this : DECLARE ex_custom EXCEPTION; BEGIN RAISE ex_custom; EXCEPTION WHEN ex_custom THEN DBMS_OUTPUT.PUT_LINE(SQLERRM); END; The output is "User-Defined Exception" ...
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.