Home » Other » Client Tools » package (SQL developer)
package [message #603902] Fri, 20 December 2013 04:38 Go to next message
natheem.iqbal02@gmail.com
Messages: 1
Registered: December 2013
Location: Chennai
Junior Member
What are the actions you have to perform when you rename/drop a package using SQL developer ?

Report message to a moderator

Re: package [message #603904 is a reply to message #603902] Fri, 20 December 2013 04:46 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It depends. If nothing referenced it, no action is required. If something did, it will fail.

Report message to a moderator

Re: package [message #603910 is a reply to message #603902] Fri, 20 December 2013 05:15 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Not sure what exactly you mean by renaming a package? You need to drop it and recreate it with a new name for that.

DROP PACKAGE Statement

Report message to a moderator

Re: package [message #603915 is a reply to message #603902] Fri, 20 December 2013 05:26 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
This sounds like an interview question or a homework question. No problem asking them, but if you tell us the context of the question, the response may differ.

Report message to a moderator

Previous Topic: INSERT INTO with GUI - insert record greyed out
Next Topic: Cnnot import more than 65536 rows from excel
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 02 16:16:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.