for example I have one table with unique constraint on ID column and it has values like this : ID Name 1 test and I want to catch and handle unique constraint exception. thanks
Question
Oraask Latest Questions
Question
I have a query and I want to use if statement inside where clause like this : [code] SELECT e.first_name, e.last_name, e.status FROM employees e WHERE IF status_flag = STATUS_ACTIVE then e.status = 'A' IF status_flag = STATUS_INACTIVE then e.status = 'T' IF source_flag = SOURCE_FUNCTION then e.business_unit = ...
Question
hello, I'm using Oracle 10gR2 and i want to know what's the differences between both because I take a look at the documentation and i find out there no differences. any suggestions will be appreciated.
Question
I have a test_table with the following data : [code] select * from test_table; [/code] Number Name 1 AA 1 DD 2 QQ 3 WW 4 EE
Question
Hi , I have the below query where am using TRUNC on the column2 filed which is increasing the performance delay. so need to avoid the TRUNC on this check and need to use BETWEEN operator. Here SYSTEMDATE is the currentdateandtime. So how can ...
Question
Hi, I need a sample for using sys_connect_by_path in sql query please regards,
Question
How to drop all partitions from all tables belonging to this schema based on date Hi, I have a script to delete the partition from a table which meet certain criteria and this the block of code to do this : DECLARE v_sql varchar2(500); v_date ...
Question
oracle userExplorer
hello experts, what i want is : query to display 'job' & their counts & then display the no. of distinct 'dept no' under each 'job' & their counts ? consider i have these dataset : SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ...
Question
How to call MySQL Procedure from Oracle using HS Link ? HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way ...
Question
I face this error when I want to execute this block of code in an anonymous pl/sql block: DECLARE BEGIN SELECT last_name INTO v_last FROM employees; dbms_output.put_line('v_last is :' || v_last ); END; PLS-00201: identifier must be declared thanks.