babyDBA

Connect to the database as SYS and execute this query [CODE]ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;[/CODE] or set in the init.ora file parameter open_cursors, for example [CODE]open_cursors=400[/CODE] and restart database instead of 400 set as you want

Just add two line on the end of your query [CODE] SELECT student.student_id, student_name FROM enrolls, class, student WHERE course_num LIKE 'csci_6___' AND class.schedule_num =enrolls.schedule_num AND student.student_id = enrolls.student_id [COLOR="Red"]GROUP BY student.student_id, student_name HAVING COUNT(*) >= 2[/COLOR] [/CODE]

You can try this code select (case when shipdate-orderdated>=4 then 'Unsatisfactory!' else 'Satisfactory!' end) from orders

select utl_inaddr.get_host_address serverIP from dual;

select * from all_tables where temporary='Y'

Try this [CODE] select table_name, column_name, data_type from user_tab_columns where data_type='DATE' and lower(table_name)='mytable' [/CODE]

You must enter the date in the format that you specified in the script ('DD.MM.YY' or 'DD-MON-YY') and it looks like you forgot to do fetch I added comments to the lines that I corrected / added. I hope it will be helpful [CODE] CREATE OR REPLACE PROCEDURE A_SIPARIS_EKLE_SP IS …

I think this script you will be sufficient [CODE] create table test_result ( date1 date, date2 date ); create or replace procedure split_months(dDate1 date, dDate2 date) is tempDate date; begin tempDate := dDate1; loop if last_day(tempDate)<dDate2 then insert into test_result(date1, date2) values(tempDate, last_day(tempDate)); tempDate := last_day(tempDate)+1; else insert into test_result(date1, …

if Employee_ID and Last_Name can be any, within a specified Job_ID, You can also use the group functions, eg [CODE] SELECT Job_ID, max(Employee_ID), max(Last_Name) FROM Employees GROUP BY Job_ID [/CODE]

You have to add command SET PAGESIZE 0 at the top script [CODE] SET PAGESIZE 0 -- <-- add this line SET FEEDBACK OFF SET HEADING OFF SPOOL OUTPUT.TXT; SELECT username||','||profession FROM users; SPOOL OFF; [/CODE]