| Author | Message | ||
     Subzero Comedian Username: Subzero Post Number: 1263 Registered: 04-2008 Posted From: 59.93.96.12 Rating: N/A |
I need to take backup to a tape from Oracle 10g db. Can anyone give me the working script (using exp) ? I have 110 tables in the database. సర్వ దేవాత్మకో హ్యేస తేజస్వీ రశ్మీభావనాః ఎస దేవాసుర గణమ్ లోకాం పాతి గభాస్తీభీః | ||
| Okkamogaadu Comedian Username: Okkamogaadu Post Number: 1024 Registered: 02-2008 Posted From: 166.129.54.119 Rating: N/A |
hmm aite vake Live Like an Elephant Die Like a Lion | ||
| Kadapanagfan Hero Username: Kadapanagfan Post Number: 11037 Registered: 12-2006 Posted From: 192.76.82.89 Rating: N/A |
basic ga memu UI develop setunnnamu and search criteria depends on the searchable fields from the screeen!!!so based on conditions we are developing the query annnamata !!!so where 1=1 default and searchable fields prakaram and condition bulit chestamu!!! | ||
| Okkamogaadu Comedian Username: Okkamogaadu Post Number: 1022 Registered: 02-2008 Posted From: 166.129.54.119 Rating: N/A |
btb why do u need 1 = 1 condition i feel its not necessary unless until u are going to create a table that is similar to the existing table with same schema along with its data Live Like an Elephant Die Like a Lion | ||
| Okkamogaadu Comedian Username: Okkamogaadu Post Number: 1020 Registered: 02-2008 Posted From: 166.129.54.119 Rating: N/A |
u welcome  Live Like an Elephant Die Like a Lion | ||
| Kadapanagfan Hero Username: Kadapanagfan Post Number: 11034 Registered: 12-2006 Posted From: 192.76.82.89 Rating: N/A |
got it!!! THX OM | ||
| Okkamogaadu Comedian Username: Okkamogaadu Post Number: 1018 Registered: 02-2008 Posted From: 166.129.54.119 Rating: N/A |
also missing '%' here UPPER(ORDER_NUMBER) LIKE 'DEVEMEASUB0000868%' Live Like an Elephant Die Like a Lion | ||
| Okkamogaadu Comedian Username: Okkamogaadu Post Number: 1017 Registered: 02-2008 Posted From: 166.129.54.119 Rating: N/A |
on top of it u have to use AND ACTIVITYDATE <= to_date('2009-Jan-08 23:59:59','YYYY-MON-DD HH24:MI:SS') instead of AND ACTIVITYDATE <= to_date('2009-Jan-08 11:59:59','YYYY-MON-DD HH24:MI:SS') } Live Like an Elephant Die Like a Lion | ||
| Okkamogaadu Comedian Username: Okkamogaadu Post Number: 1016 Registered: 02-2008 Posted From: 166.129.54.119 Rating: N/A |
why do u need to use 1 = 1 in the condition? Live Like an Elephant Die Like a Lion | ||
| Kadapanagfan Hero Username: Kadapanagfan Post Number: 11032 Registered: 12-2006 Posted From: 192.76.82.89 Rating: N/A |
bump idea ledha yevariki!!! | ||
| Kadapanagfan Hero Username: Kadapanagfan Post Number: 11030 Registered: 12-2006 Posted From: 192.76.82.89 Rating: N/A |
SELECT AUDIT_TYPE,to_char(ACTIVITYDATE,'MM/DD/YYYY HH24:MI:SS AM') ACTIVITYDATE, VZ_ID,DESCRIPTION,ORDER_NUMBER,ORDER_TYPE,ORDER_CATEGORY,ORD ER_STATUS FROM VOIP_AUDIT WHERE 1=1 AND UPPER(ORDER_NUMBER) LIKE 'DEVEMEASUB0000868' AND ACTIVITYDATE >= to_date('2009-Jan-08 00:00:00','YYYY-MON-DD HH24:MI:SS') AND ACTIVITYDATE <= to_date('2009-Jan-08 11:59:59','YYYY-MON-DD HH24:MI:SS') adi naaaa query!!!naaaaku JUST 8th na midnitght 12 nunchi nigt 11:59 varaku recs kavali!!! table lo data unnnna yeee query work avvvadam ledu!!!yee query lo yemannna tapppu unda? |
