coba bantu, Seperti yang di bantu bro Izzudin H, besar kemungkinan di schema tsb ga ada object tersebut, adanya di schema lain.
coba cek dulu pakai ,select owner,table_name from dba_tables where tbale_name ='STOCKS' kalau ternyata schema nya beda dengan posisi anda sekarang, cek dulu apakah table/object tersebut di kasih grant select ke schema dimana posisi anda sekarang kalo udah tinggal coba pakai select * from owner.Stocks mudah2an bisa bantu regards Henri ________________________________________ From: [email protected] [[email protected]] On Behalf Of Izzudin Hanafie [[email protected]] Sent: Saturday, July 11, 2009 7:30 AM To: [email protected] Subject: External Email : --> Re: [indo-oracle] membuat report builder Waalaikum salam Pak Abu Abdillah, Apakah didalam database nya sudah ada table stock tersebut..?. Mungkin salah connect ke schema di reportnya.. CMIIW, Regards, IH --- On Thu, 7/9/09, abu_abdillah_almadurie <[email protected]<mailto:ibnu.jafar%40gmail.com>> wrote: From: abu_abdillah_almadurie <[email protected]<mailto:ibnu.jafar%40gmail.com>> Subject: [indo-oracle] membuat report builder To: [email protected]<mailto:indo-oracle%40yahoogroups.com> Date: Thursday, July 9, 2009, 10:20 PM Assalaamu'alaykum warohmatulloh. .. salam ukhuwah.. saya mau tanya cara bikin report.. saat saya mencoba memasukkan query: ------------ ----- SELECT symbol, company, current_price, trade_date, number_traded_ today, todays_high, todays_low FROM stocks ------------ ---- kenapa ada pesan error: ORA-00942: table or view doesn't exist FROM => Stocks itu kenapa?apa karena gada datanya? tapi query diatas saya ambil dari tutorial pembuatan report builder dan disitu juga gada datanya cuman query doang...pliss. .soalnya saya lagi magang di RCTI nih.. jazakumullah atas bantuannya [Non-text portions of this message have been removed] This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference.
