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
Oraask Latest Questions
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
How to repeat the same values to the next record from the previous record ?
Question
hi, we using message('') in oracle forms to show message what is the equivalent approach to do this in oracle reports 10g?
Question
Hello guys, i called a report (10g) from apex page and it's working fine without errors but i have found that all the schema informations like schema nam, username and password it's appear in the url which is not secure, so please ...
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
please someone explain shortly what is major differences between ADF and JSF ?